DBS-C01 · Question #356
A retail company uses Amazon Redshift for its 1 PB data warehouse. Several analytical workloads run on a Redshift cluster. The tables within the cluster have grown rapidly. End users are reporting poo
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #356. The question stem and answer options stay visible for context.
Question
A retail company uses Amazon Redshift for its 1 PB data warehouse. Several analytical workloads run on a Redshift cluster. The tables within the cluster have grown rapidly. End users are reporting poor performance of daily reports that run on the transaction fact tables. A database specialist must change the design of the tables to improve the reporting performance. All the changes must be applied dynamically. The changes must have the least possible impact on users and must optimize the overall table size. Which solution will meet these requirements?
Options
- AUse the STL_SCAN view to understand how the tables are getting scanned. Identify the columns
- BRun an explain plan to analyze the queries on the tables. Consider recommendations from
- CRun an explain plan to analyze the queries on the tables. Consider recommendations from
- DRun an explain plan to analyze the queries on the tables. Consider recommendations from
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-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.