DEA-C01 · Question #270
DEA-C01 Question #270: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #270. The question stem and answer options stay visible for context.
Question
A company has a data processing pipeline that runs multiple SQL queries in sequence against an Amazon Redshift cluster. The company merges with a second company. The original company modifies a query that aggregates sales revenue data to join sales tables from both companies. The sales table for the first company is named Table S1. The sales table for the second company is named Table S2. Table S1 contains 10 billion records. Table S2 contains 900 million records. The query becomes slow after the modification. A data engineer must improve the query performance. Which solutions will meet these requirements? (Choose two.)
Options
- AUse the KEY distribution style for both sales tables. Select a low cardinality column to use for the
- BUse the KEY distribution style for both sales tables. Select a high cardinality column to use for the
- CUse the EVEN distribution style for Table S1. Use the ALL distribution style for Table S2.
- DUse the Amazon Redshift query optimizer to review and select optimizations to implement.
- EUse Amazon Redshift Advisor to review and select optimizations to implement.
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-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.