DEA-C01 · Question #38
DEA-C01 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
Question
A company's data engineer needs to optimize the performance of table SQL queries. The company stores data in an Amazon Redshift cluster. The data engineer cannot increase the size of the cluster because of budget constraints. The company stores the data in multiple tables and loads the data by using the EVEN distribution style. Some tables are hundreds of gigabytes in size. Other tables are less than 10 MB in size. Which solution will meet these requirements?
Options
- AKeep using the EVEN distribution style for all tables. Specify primary and foreign keys for all
- BUse the ALL distribution style for large tables. Specify primary and foreign keys for all tables.
- CUse the ALL distribution style for rarely updated small tables. Specify primary and foreign keys for
- DSpecify a combination of distribution, sort, and partition keys for all tables.
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.