DBS-C01 · Question #356
DBS-C01 Question #356: Real Exam Question with Answer & Explanation
The correct answer is B: Run an explain plan to analyze the queries on the tables. Consider recommendations from. https://aws.amazon.com/about-aws/whats-new/2020/10/amazon-redshift-supports-modifying- column-comprression-encodings-to-optimize-storage-utilization-query-performance/
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
Explanation
https://aws.amazon.com/about-aws/whats-new/2020/10/amazon-redshift-supports-modifying- column-comprression-encodings-to-optimize-storage-utilization-query-performance/
Topics
Community Discussion
No community discussion yet for this question.