Question 194:
Cliff is a data analyst of Adatum Corp. working on designing fact & dimension tables of a SQLdata warehouse on Star schema. As an inventory application, there are several fact tables. There are sizes of more than 10 GB. The dimension tables are smaller in size & mostly, there’s no joining key available on those dimension tables. Which kind of Azure SQL data-warehouse distributed table type should be used for large size fact tables?
Answer options:
A.Round-robin distributed table B.Hash distributed table C.Distribution column D.Replicated table