DAS-C01 · Question #135
DAS-C01 Question #135: Real Exam Question with Answer & Explanation
The correct answer is C: Store the most recent 4 months of data in the Amazon Redshift cluster. Use Amazon Redshift. Only the last 4 months of data is required for 95%, the data can be stored in the Redshift cluster. The data covering the 12 months can be moved to S3 and queried using Redshift Spectrum. A mix of S3 and Redshift would provide the most cost-effective option. https://docs.aws.amaz
Question
An education provider's learning management system (LMS) is hosted in a 100 TB data lake that is built on Amazon S3. The provider's LMS supports hundreds of schools. The provider wants to build an advanced analytics reporting platform using Amazon Redshift to handle complex queries with optimal performance. System users will query the most recent 4 months of data 95% of the time while 5% of the queries will leverage data from the previous 12 months. Which solution meets these requirements in the MOST cost-effective way?
Options
- AStore the most recent 4 months of data in the Amazon Redshift cluster. Use Amazon Redshift
- BLeverage DS2 nodes for the Amazon Redshift cluster. Migrate all data from Amazon S3 to
- CStore the most recent 4 months of data in the Amazon Redshift cluster. Use Amazon Redshift
- DStore the most recent 4 months of data in the Amazon Redshift cluster. Use Amazon Redshift
Explanation
Only the last 4 months of data is required for 95%, the data can be stored in the Redshift cluster. The data covering the 12 months can be moved to S3 and queried using Redshift Spectrum. A mix of S3 and Redshift would provide the most cost-effective option. https://docs.aws.amazon.com/redshift/latest/dg/c-using-spectrum.html
Topics
Community Discussion
No community discussion yet for this question.