DAS-C01 · Question #40
DAS-C01 Question #40: Real Exam Question with Answer & Explanation
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #40. The question stem and answer options stay visible for context.
Question
A manufacturing company has been collecting IoT sensor data from devices on its factory floor for a year and is storing the data in Amazon Redshift for daily analysis. A data analyst has determined that, at an expected ingestion rate of about 2 TB per day, the cluster will be undersized in less than 4 months. A long- term solution is needed. The data analyst has indicated that most queries only reference the most recent 13 months of data, yet there are also quarterly reports that need to query all the data generated from the past 7 years. The chief technology officer (CTO) is concerned about the costs, administrative effort, and performance of a long-term solution. Which solution should the data analyst use to meet these requirements?
Options
- ACreate a daily job in AWS Glue to UNLOAD records older than 13 months to Amazon S3 and
- BTake a snapshot of the Amazon Redshift cluster. Restore the cluster to a new cluster using dense
- CExecute a CREATE TABLE AS SELECT (CTAS) statement to move records that are older than
- DUnload all the tables in Amazon Redshift to an Amazon S3 bucket using S3 Intelligent-Tiering.
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.