An Education Provider's Learning Management System (LMS) Is Hosted in a 100

question 57

Multiple Choice

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?

• A) Store the most recent 4 months of data in the Amazon Redshift cluster. Use Amazon Redshift Spectrum to query data in the data lake. Use S3 lifecycle management rules to store data from the previous 12 months in Amazon S3 Glacier storage.
• B) Leverage DS2 nodes for the Amazon Redshift cluster. Migrate all data from Amazon S3 to Amazon Redshift. Decommission the data lake.
• C) Store the most recent 4 months of data in the Amazon Redshift cluster. Use Amazon Redshift Spectrum to query data in the data lake. Ensure the S3 Standard storage class is in use with objects in the data lake.
• D) Store the most recent 4 months of data in the Amazon Redshift cluster. Use Amazon Redshift federated queries to join cluster data with the data lake to reduce costs. Ensure the S3 Standard storage class is in use with objects in the data lake.

---

Definitions:

Test Statistic Value

A value calculated from sample data that is used to make a decision in a hypothesis test.

Critical Value

A threshold in hypothesis testing that defines the boundary or cutoff for deciding whether to reject the null hypothesis, based on the observed data.

Significance Level

The probability threshold below which the null hypothesis is rejected in a statistical test.

P Value

The probability of obtaining test results at least as extreme as the results actually observed during the test, assuming that the null hypothesis is correct.