Microsoft Data Engineering on Microsoft Azure DP-203 Question # 23 Topic 3 Discussion

Microsoft Data Engineering on Microsoft Azure DP-203 Question # 23 Topic 3 Discussion

DP-203 Exam Topic 3 Question 23 Discussion:
Question #: 23
Topic #: 3

You implement an enterprise data warehouse in Azure Synapse Analytics.

You have a large fact table that is 10 terabytes (TB) in size.

Incoming queries use the primary key SaleKey column to retrieve data as displayed in the following table:

DP-203 Question 23

You need to distribute the large fact table across multiple nodes to optimize performance of the table.

Which 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


Get Premium DP-203 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.