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

Answer: A

Latest DP-200 Dumps Valid Version with 242 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments