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…

The correct answer is B. In the tables use a hash distribution of ArrivalAirportID and AirportID. 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…

Submitted by ravi_2018· Mar 30, 2026Design and implement data storage

Question

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?

Exhibit

Options

AIn the tables use a hash distribution of ArrivalDateTime and ReportDateTime.
BIn the tables use a hash distribution of ArrivalAirportID and AirportID.
CIn each table, create an IDENTITY column.
DIn each table, create a column as a composite of the other two columns in the table.

How the community answered

(56 responses)

A
11% (6)
B
80% (45)
C
4% (2)
D
5% (3)

Explanation

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.

Topics

#hash distribution#dedicated SQL pool#table joins#query performance

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice