redshift spectrum and s3 glacier access

[Ocean]

Q: A multinational corporation requires a data storage solution that ensures data is kept in a consistent and highly structured format. The corporation needs rapid responses for business analysts’ queries when analyzing data from the current fiscal year, and analysts should have access to the entire 20-year dataset when necessary. This solution must also be capable of handling a varying number of incoming queries. The storage costs for the 150 TB of data should be minimized.

Correct answer: Implement an Amazon Redshift data warehouse solution with a dense storage instance to store the most recent data. Archive historical data on Amazon Glacier and access it using the Amazon Redshift Spectrum layer. Enable Amazon Redshift Concurrency Scaling.

documentation says redshift spectrum cannot access glacier data. please clarify

[Carlo-TutorialsDojo]

Hello Ocean,

Thanks for pointing this out.

Yes, you’re correct. For data to be queryable by Redshift Spectrum, the archived data must first be restored back into Amazon S3.

We apologize for this inaccuracy. We’ll revise the question to correct this mistake.

Let us know if there is anything you want us to clarify further.

Regards,

Carlo @ Tutorials Dojo