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 ``` You need to recommend a solution that maximizes query performance. What should you include in the recommendation? | Microsoft Azure Data Engineer Associate - DP-203 Quiz

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

You need to recommend a solution that maximizes query performance. What should you include in the recommendation?

Exam-Like

Powered ByGPT-5

Microsoft Azure Data Engineer Associate - DP-203