Find answers, ask questions, and connect with our
community around the world.

Home Forums AWS AWS Certified Data Engineer Associate DEA-C01 redshift spectrum and s3 glacier access

  • redshift spectrum and s3 glacier access

  • Ocean

    April 4, 2024 at 9:50 am

    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

    April 4, 2024 at 12:54 pm

    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.


    Carlo @ Tutorials Dojo

Viewing 1 - 2 of 2 replies

Log in to reply.

Original Post
0 of 0 posts June 2018