Which technology should you use?

You implement 3 Azure SQL Data Warehouse instance.

You plan to migrate the largest fact table to Azure SQL Data Warehouse The table resides on Microsoft SQL Server on-premises and e 10 terabytes (TB) in size.

Incoming queues use the primary key Sale Key column to retrieve data as displayed in the following table: You need to distribute the fact table across multiple nodes to optimize performance of the table.

Which technology should you use?
A . hash distributed table with clustered ColumnStore index
B . hash distributed table with clustered index
C . heap table with distribution replicate
D . round robin distributed table with clustered index
E . round robin distributed table with clustered ColumnStore index

View Answer

Answer: A