What should you include in the recommendation?

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 ArrivaIAirportID and AirportlD.
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.

View Answer

Answer: B

Explanation:

Hash-distribution improves query performance on large fact tables.