Question 2:
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 One of the key requirements includes ORDER_FCT and PART_DIM are joined together in most of order related queries. ORDER_FCT has many other dimensions to support analysis. How would you design the distribution? Select 1 option.
Answer options:
A.Distribute the ORDER_FCT with KEY distribution on its primary KEY ( any one of the columns ) and PART_DIM with KEY distribution on its PRIMARY KEY B.Distribute the ORDER_FCT with ALL distribution on its primary KEY ( any one of the columns ) and PART_DIM with ALL distribution on its PRIMARY KEY C.Distribute the ORDER_FCT with EVEN distribution on its primary KEY ( any one of the columns ) and PART_DIM with EVEN distribution on its PRIMARY KEY D.Distribute the ORDER_FCT and PART_DIM on same key with KEY distribution E.Distribute the ORDER_FCT and PART_DIM on same key with EVEN distribution