Exam AWS Certified Database - Specialty topic 1 question 193 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 193
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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?

A. Check file sizes of fact tables in Amazon S3, and look for large files. Break up large files into smaller files of equal size between 100 MB and 1 GB
B. Reduce the number of queries that users can run in parallel.
C. Check file sizes of fact tables in Amazon S3, and look for small files. Merge the small files into larger files of at least 64 MB in size.
D. Review and optimize queries that submit a large aggregation step to Redshift Spectrum.

Show Suggested Answer

Suggested Answer: C 🗳️

by mbar94 at Sept. 3, 2022, 8:37 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

mbar94

Highly Voted 2 years, 3 months ago

Selected Answer: C

C for sure according to the link - https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-troubleshooting.html

upvoted 8 times

...

Skarlex77

Most Recent 10 months ago

Selected Answer: C

https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-troubleshooting.html

upvoted 1 times

...

missipssamarsh

11 months, 1 week ago

Selected Answer: C

If your Redshift Spectrum requests frequently get throttled by Amazon S3, reduce the number of Amazon S3 GET/HEAD requests that Redshift Spectrum makes to Amazon S3. To do this, try merging small files into larger files. We recommend using file sizes of 64 MB or larger. https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-troubleshooting.html

upvoted 1 times

...

OCHT

1 year, 9 months ago

Selected Answer: D

Option D suggests reviewing and optimizing the queries to submit a large aggregation step to Redshift Spectrum. This is the most appropriate solution to resolve the error, as it directly addresses the root cause of the issue. By optimizing the queries, it is possible to reduce the amount of data scanned by Redshift Spectrum, which will reduce the number of scan requests and prevent throttling.

upvoted 1 times

...

TL12345

2 years, 1 month ago

C. https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-troubleshooting.html#spectrum-troubleshooting-access-throttled

upvoted 1 times

...

JeanGat

2 years, 2 months ago

Selected Answer: C

C. Both S3 and AWS KMS can throttle..the fix is always the same...larger/less files. https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-troubleshooting.html

upvoted 4 times

...