DBS-C01 · Question #203
DBS-C01 Question #203: Real Exam Question with Answer & Explanation
The correct answer is C: Check file sizes of fact tables in Amazon S3, and look for small files. Merge the small files into. https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-troubleshooting.html
Question
A retail company uses Amazon Redshift Spectrum to run complex analytical queries on objects that are stored in an Amazon S3 bucket. The objects are joined with multiple dimension tables that are stored in an Amazon Redshift database. The company uses the database to create monthly and quarterly aggregated reports. Users who attempt to run queries are reporting the following error message: error: Spectrum Scan Error: Access throttled Which solution will resolve this error?
Options
- ACheck file sizes of fact tables in Amazon S3, and look for large files. Break up large files into
- BReduce the number of queries that users can run in parallel.
- CCheck file sizes of fact tables in Amazon S3, and look for small files. Merge the small files into
- DReview and optimize queries that submit a large aggregation step to Redshift Spectrum.
Explanation
https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-troubleshooting.html
Topics
Community Discussion
No community discussion yet for this question.