DAS-C01 · Question #53
DAS-C01 Question #53: Real Exam Question with Answer & Explanation
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #53. The question stem and answer options stay visible for context.
Question
A large ride-sharing company has thousands of drivers globally serving millions of unique customers every day. The company has decided to migrate an existing data mart to Amazon Redshift. The existing schema includes the following tables. - A trips fact table for information on completed rides. - A drivers dimension table for driver profiles. - A customers fact table holding customer profile information. The company analyzes trip details by date and destination to examine profitability by region. The drivers data rarely changes. The customers data frequently changes. What table design provides optimal query performance?
Options
- AUse DISTSTYLE KEY (destination) for the trips table and sort by date.
- BUse DISTSTYLE EVEN for the trips table and sort by date.
- CUse DISTSTYLE KEY (destination) for the trips table and sort by date.
- DUse DISTSTYLE EVEN for the drivers table and sort by date.
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.