Which type of table should you use?

You plan to create a dimension table in Azure Data Warehouse that will be less than 1 GB.

You need to create the table to meet the following requirements:

Provide the fastest query time.

Minimize data movement.

Which type of table should you use?
A . hash distributed
B . heap
C . replicated
D . round-robin

View Answer

Answer: C

Explanation: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/design-guidance-for-replicated-tables