Microsoft Azure Data Engineer Associate - DP-203
Get started today
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?
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?
Exam-Like
A
In the tables use a hash distribution of ArrivalDateTime and ReportDateTime.
B
In the tables use a hash distribution of ArrivalAirportID and AirportID.
Comments
Loading comments...