Question 7:
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 SALES_FCT and DATE_DIM are joined together frequently since EOD sales reports are generated every day. please suggest your distribution style for both tables. Select 1 option.
Answer options:
A.Distribute the SALES_FCT with KEY DISTRIBUTION on its own Primary KEY ( one of the columns ) while DATE_DIM is distributed with KEY DISTRIBUTION on Its PRIMARY KEY B.Distribute the SALES_FCT with EVEN DISTRIBUTION on its own Primary KEY ( one of the columns ) while DATE_DIM is distributed with EVEN distribution on Its PRIMARY KEY C.Distribute the SALES_FCT with KEY DISTRIBUTION on its own Primary KEY ( one of the columns ) while DATE_DIM is distributed with ALL DISTRIBUTION on Its PRIMARY KEY D.Distribute the SALES_FCT with ALL DISTRIBUTION on its own Primary KEY ( one of the columns ) while DATE_DIM is distributed with EVEN distribution on Its PRIMARY KEY E.Distribute the SALES_FCT with EVEN DISTRIBUTION on its own Primary KEY ( one of the columns ) while DATE_DIM is distributed with ALL distribution on Its PRIMARY KEY