ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 1 question 73 discussion

Actual exam question from Microsoft's DP-203
Question #: 73
Topic #: 1
[All DP-203 Questions]

HOTSPOT
-

You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool.
You plan to deploy a solution that will analyze sales data and include the following:

• A table named Country that will contain 195 rows
• A table named Sales that will contain 100 million rows
• A query to identify total sales by country and customer from the past 30 days

You need to create the tables. The solution must maximize query performance.

How should you complete the script? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by FRANCIS_A_M at April 3, 2023, 6:12 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
FRANCIS_A_M
Highly Voted 2 years, 1 month ago
Correct! 1. Hash(CustomerID) 2. Replicate
upvoted 21 times
zafnad
1 year, 12 months ago
Could you please explain why 1. Hash([CustomerID]) is correct, and 2. Hash([OrderDate]) is incorrect.
upvoted 2 times
ajhak
1 year, 11 months ago
It is hash because it is a fact table (you can tell because there is the "total" column being created which is numerical). Rule of thumb, never hash on a date field, so in this case you would hash on 'CustomerID'. You want the hash to have as many unique values as possible.
upvoted 7 times
...
Spam_Account
1 year, 10 months ago
Don't hash on date, only partition on date
upvoted 16 times
...
vctrhugo
1 year, 10 months ago
Never distribute on Date.
upvoted 5 times
...
...
...
AnhHoang
Most Recent 9 months, 3 weeks ago
1. You would want hash distribution to improve query performance. You don't want to hash on Date column since it can cause bottlenecks if many people query on a same date (eg. getdate()), so hash on customerid is the way. 2. You would want to replicate small tables across all distributions, so it can pick up any distribution and still have full data.
upvoted 2 times
...
kkk5566
1 year, 8 months ago
1. Hash(CustomerID) 2. Replicate
upvoted 2 times
...
Deeksha1234
1 year, 8 months ago
given answer is correct
upvoted 1 times
...
examtopicsofyannick
1 year, 9 months ago
Correct. Hash on Sales Table(Fact) and Replicate on Country table(Dimension)
upvoted 2 times
...
nmnm22
2 years, 1 month ago
correct
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago