Microsoft Data Engineering on Microsoft Azure DP-203 Question # 34 Topic 4 Discussion

Microsoft Data Engineering on Microsoft Azure DP-203 Question # 34 Topic 4 Discussion

DP-203 Exam Topic 4 Question 34 Discussion:
Question #: 34
Topic #: 4

You plan to create a dimension table in Azure Synapse Analytics 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 during queries.

Which type of table should you use?


A.

hash distributed


B.

heap


C.

replicated


D.

round-robin


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.