Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You have a large 10 TB fact table in Azure Synapse Analytics. Queries primarily use the SaleKey column to retrieve data, as shown in the provided table.
To distribute this large fact table across multiple nodes for optimal performance, which distribution technology should you use?
A
hash distributed table with clustered index
B
hash distributed table with clustered Columnstore index
C
round robin distributed table with clustered index
D
round robin distributed table with clustered Columnstore index
E
heap table with distribution replicate