DP-201 Exam - Question 36

Question

HOTSPOT -You are designing an enterprise data warehouse in Azure Synapse Analytics that will store website traffic analytic in a star schema. You plan to have a fact table for website visits. The table will be approximately 5 GB. You need to recommend which distribution type and index type to use for the table. The solution must provide the fastest query performance. What should you recommend? To answer, select the appropriate options in the answer areaNOTE: Each correct selection is worth one point. Hot Area:.

Examice · Accepted Answer

Reference:https://docs. microsoft. com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-distribute https://docs. microsoft. com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-index.

dbdev · Answer

The answer is straightforward and correct. Even, there is no need to put a comment here.

Pairon · Answer

Shouldn't be "Round Robin" in the first box? Isn't it more efficient compared to "Hash" since avoids computing the partitions?

aksoumi · Answer

How should we decide if it is clustered or a non clustered index? Usually if there are over a million rows (or more than 60 million rows) we use  clustered index, but these aren't mentioned in question.

DP-201 Exam - Question 36

Discussion