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 maximum query performance.
What should you include in the recommendation?
A . In each table, create a column as a composite of the other two columns in the table.
B. In each table, create an IDENTITY column.
C. In the tables, use a hash distribution of ArriveDateTime and ReportDateTime.
D. In the tables, use a hash distribution of ArriveAirPortID and AirportID.
Answer: D
Latest DP-203 Dumps Valid Version with 116 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund