Exam DP-200 topic 6 question 113 discussion

Actual exam question from Microsoft's DP-200

Question #: 113
Topic #: 6

A company is planning on setting up an Azure SQL data warehouse. They want to setup different tables. The different tables have different requirements as stated below:
XYZ_sales `" Here the rows should be distributed in such a way that it offers high performance
XYZ_offers `" Here data should be available on all nodes to achieve better performance on table joins
XYZ_orders `" Here data should be loaded faster on the underlying table
Which of the following table type would you use for the table XYZ_orders?

A. Hash-distributed tables
B. Primary tables
C. Replicated tables
D. Round-robin tables

Show Suggested Answer

Suggested Answer: D 🗳️
Here you would use Round-robin tables.
The Microsoft documentation mentions the following:

Round-robin tables -
A round-robin table distributes table rows evenly across all distributions. The rows are distributed randomly. Loading data into a round-robin table is fast. However, queries can require more data movement than the other distribution methods.
Since this is clearly mentioned in the documentation, all other options are incorrect.
Reference:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-overview

by [deleted] at April 4, 2025, 9:52 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!