A Marketing Company Wants to Improve Its Reporting and Business

question 73

Multiple Choice

A marketing company wants to improve its reporting and business intelligence capabilities. During the planning phase, the company interviewed the relevant stakeholders and discovered that: The operations team reports are run hourly for the current month's data. The sales team wants to use multiple Amazon QuickSight dashboards to show a rolling view of the last 30 days based on several categories. The sales team also wants to view the data as soon as it reaches the reporting backend. The finance team's reports are run daily for last month's data and once a month for the last 24 months of data. Currently, there is 400 TB of data in the system with an expected additional 100 TB added every month. The company is looking for a solution that is as cost-effective as possible. Which solution meets the company's requirements?

• A) Store the last 24 months of data in Amazon Redshift. Configure Amazon QuickSight with Amazon Redshift as the data source.
• B) Store the last 2 months of data in Amazon Redshift and the rest of the months in Amazon S3. Set up an external schema and table for Amazon Redshift Spectrum. Configure Amazon QuickSight with Amazon Redshift as the data source.
• C) Store the last 24 months of data in Amazon S3 and query it using Amazon Redshift Spectrum. Configure Amazon QuickSight with Amazon Redshift Spectrum as the data source.
• D) Store the last 2 months of data in Amazon Redshift and the rest of the months in Amazon S3. Use a long-running Amazon EMR with Apache Spark cluster to query the data as needed. Configure Amazon QuickSight with Amazon EMR as the data source.

---

Definitions:

Classical Conditioning

A teaching method in which a response originally triggered by a second stimulus is ultimately triggered by the first stimulus after the two stimuli have been repeatedly associated.

Latent Learning

A form of learning that occurs without any obvious reinforcement of the behavior or associations that are learned, becoming apparent only when there is an incentive to demonstrate it.

Classical Conditioning

Classical conditioning is a learning process that occurs through associations between an environmental stimulus and a naturally occurring stimulus.

Operant Conditioning

A method of learning that occurs through rewards and punishments for behavior.