DEA-C01 · Question #281
DEA-C01 Question #281: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #281. The question stem and answer options stay visible for context.
Question
A company maintains a central Amazon Redshift data warehouse that aggregates daily transactional data from Amazon RDS for PostgreSQL and Amazon Aurora MySQL. A data engineer notices that some complex transformation queries take hours to finish. The data engineer wants to optimize query performance to reduce query execution time as much as possible. Which solution will meet this requirement?
Options
- AIncrease the concurrency scaling quota for the Redshift cluster.
- BExport the tables to an Amazon S3 bucket. Use Amazon Athena to query the data in the bucket.
- CUse Amazon Redshift Spectrum to create external tables based on the Redshift tables.
- DUse materialized views in Amazon Redshift for frequently queried data patterns.
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.