DAS-C01 · Question #96
DAS-C01 Question #96: Real Exam Question with Answer & Explanation
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #96. The question stem and answer options stay visible for context.
Question
A large retailer has successfully migrated to an Amazon S3 data lake architecture. The company's marketing team is using Amazon Redshift and Amazon QuickSight to analyze data, and derive and visualize insights. To ensure the marketing team has the most up-to-date actionable information, a data analyst implements nightly refreshes of Amazon Redshift using terabytes of updates from the previous day. After the first nightly refresh, users report that half of the most popular dashboards that had been running correctly before the refresh are now running much slower. Amazon CloudWatch does not show any alerts. What is the MOST likely cause for the performance degradation?
Options
- AThe dashboards are suffering from inefficient SQL queries.
- BThe cluster is undersized for the queries being run by the dashboards.
- CThe nightly data refreshes are causing a lingering transaction that cannot be automatically closed
- DThe nightly data refreshes left the dashboard tables in need of a vacuum operation that could not
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.