Microsoft Exam DP-203 Topic 2 Question 38 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 38
Topic #: 2

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?

AIn the tables use a hash distribution of ArrivalDateTime and ReportDateTime.

BIn the tables use a hash distribution of ArrivaIAirportID and AirportlD.

CIn each table, create an identity column.

DIn each table, create a column as a composite of the other two columns in the table.

Show Suggested Answer

Suggested Answer: B

Hash-distribution improves query performance on large fact tables.

Incorrect Answers:

A: Do not use a date column for hash distribution. All data for the same date lands in the same distribution. If several users are all filtering on the same date, then only 1 of the 60 distributions do all the processing work.

by Casie at May 03, 2022, 11:32 PM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

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