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 4 question 21 discussion

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

You have two fact tables named Flight and Weather. Queries targeting the tables will be based on the join between the following columns.

You need to recommend a solution that maximizes query performance.
What should you include in the recommendation?

  • A. In the tables use a hash distribution of ArrivalDateTime and ReportDateTime.
  • B. In the tables use a hash distribution of ArrivalAirportID and AirportID.
  • C. In each table, create an IDENTITY column.
  • D. In each table, create a column as a composite of the other two columns in the table.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by bad_atitude at Dec. 27, 2021, 11 a.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
PallaviPatel
Highly Voted 3 years, 6 months ago
Selected Answer: B
correct
upvoted 5 times
...
imatheushenrique
Most Recent 5 months ago
Selected Answer: B
correct. hash distribuition improves join operations
upvoted 1 times
...
renan_ineu
11 months ago
Selected Answer: B
Do not HASH where? Do not hash WHERE.
upvoted 1 times
...
7082935
1 year ago
Doing a Hash on the ArrivalAirportID/AirportID ensures that the joined data from each of these tables is located on the same distribution block. This ensure that no shuffling of data occurs between the 60 distribution blocks.
upvoted 1 times
...
pass3in3mon
1 year, 3 months ago
why not C? for answer B, if some airport is very large and busy, it will contain skewed data
upvoted 1 times
...
kkk5566
1 year, 11 months ago
Selected Answer: B
correct
upvoted 1 times
...
75082SN
2 years, 7 months ago
Why not D?
upvoted 2 times
shoottheduck
2 years, 5 months ago
Also, a composite key does not improve performance on its own. Distributing on the two columns that are joined, will
upvoted 2 times
...
sensaint
2 years, 7 months ago
Then you are partly distributing on a date column which is very bad for performance.
upvoted 2 times
...
...
Deeksha1234
3 years ago
B seems correct but not sure what's wrong with D ?
upvoted 3 times
...
bad_atitude
3 years, 7 months ago
B is correct
upvoted 3 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