Question 38:
Hymutabs Ltd (Hymutabs) is a global environmental solutions company running its operations in in Asia Pacific, the Middle East, Africa and the Americas. It maintains more than 10 exploration labs around the world, including a knowledge centre, an "innovative process development centre" in Singapore, a materials and membrane products development centre as well as advanced machining, prototyping and industrial design functions. Hymutabs hosts their existing enterprise infrastructure on AWS and runs multiple applications to address the product life cycle management. The datasets are available in Aurora, RDS and S3 in file format. Hymutabs Management team is interested in building analytics around product life cycle and advanced machining, prototyping and other functions. The IT team proposed Redshift to fulfill the EDW and analytics requirements. They adapt modeling approaches laid by Bill Inmon and Kimball to efficiently design the solution. The team understands that the data loaded into Redshift would be in terabytes and identified multiple massive dimensions, facts, summaries of millions of records and are working on establishing the best practices to address the design concerns. There are 6 tables that they are currently working on: ORDER_FCT is a Fact Table with billions of rows related to orders SALES_FCT is a Fact Table with billions of rows related to sales transactions. This table is specifically used to generate reports EOD (End of Day), EOW(End of Week), and EOM (End of Month) and also sales queries CUST_DIM is a Dimension table with billions of rows related to customers. It is a TYPE 2 Dimension table PART_DIM is a part dimension table with billions of records that defines the materials that were ordered DATE_DIM is a dimension table SUPPLIER_DIM holds the information about suppliers the Hymutabs work with LOCATION_DIM is a newly identified table and has around 2.8 million rows and size increases 4% every month. Hymutabs has very limited number of suppliers. The administrator just left the company for good and also not available during design meetings. There is a urgent need to deploy LOCATION_DIM. Being a new table and no workload requirements, the team is not aware of what approach need to be taken. What is the safest approach for distribution? select 1 option.
Answer options:
A.DISTRIBUTE LOCATION_DIM with KEY DISTRIBUTION style B.DISTRIBUTE LOCATION_DIM with EVEN DISTRIBUTION style C.DISTRIBUTE LOCATION_DIM with ALL DISTRIBUTION style D.DISTRIBUTE LOCATION_DIM without ANY DISTRIBUTION style