An Ecommerce Company Stores Customer Purchase Data in Amazon RDS

question 34

Multiple Choice

An ecommerce company stores customer purchase data in Amazon RDS. The company wants a solution to store and analyze historical data. The most recent 6 months of data will be queried frequently for analytics workloads. This data is several terabytes large. Once a month, historical data for the last 5 years must be accessible and will be joined with the more recent data. The company wants to optimize performance and cost. Which storage solution will meet these requirements?

• A) Create a read replica of the RDS database to store the most recent 6 months of data. Copy the historical data into Amazon S3. Create an AWS Glue Data Catalog of the data in Amazon S3 and Amazon RDS. Run historical queries using Amazon Athena.
• B) Use an ETL tool to incrementally load the most recent 6 months of data into an Amazon Redshift cluster. Run more frequent queries against this cluster. Create a read replica of the RDS database to run queries on the historical data.
• C) Incrementally copy data from Amazon RDS to Amazon S3. Create an AWS Glue Data Catalog of the data in Amazon S3. Use Amazon Athena to query the data.
• D) Incrementally copy data from Amazon RDS to Amazon S3. Load and store the most recent 6 months of data in Amazon Redshift. Configure an Amazon Redshift Spectrum table to connect to all historical data.

Understand the notion of activity-based management and its focus on eliminating waste.

Differentiate between traditional costing and activity-based costing systems.

Understand the weighted-average method in process costing.

Calculate equivalent units of production for both materials and conversion costs.

---

Definitions:

Mass Merchandisers

Large retail stores that sell a wide variety of goods at low prices, often in bulk quantities.

Food Distributor

An entity that acts as an intermediary between food manufacturers or producers and retail establishments or food service operators, facilitating the distribution of food products.

Target Market

A specific group of potential customers identified as the intended audience for a product or service, based on shared characteristics or needs.

Household Income

The combined gross income of all members of a household, contributing to its total earning capacity.