Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You have two fact tables named Flight and Weather. Queries will join these tables on the following columns:
Flight Table | Weather Table
------------------|-----------------
DepartureDate | Date
DepartureAirport | AirportCode
Flight Table | Weather Table
------------------|-----------------
DepartureDate | Date
DepartureAirport | AirportCode
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.