Question 254
DP-203 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →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?
- AIn the tables use a hash distribution of ArrivalDateTime and ReportDateTime.
- BIn the tables use a hash distribution of ArrivalAirportID and AirportID.
- CIn each table, create an IDENTITY column.
- DIn each table, create a column as a composite of the other two columns in the table.