An Ecommerce Company Has Tasked a Database Specialist with Creating

question 116

Multiple Choice

An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora. Data that is read by the dashboard should be available within 100 milliseconds of an update. The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the reporting dashboard without any impact on the write availability and performance of the DB cluster. Which solution meets these requirements?

• A) Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
• B) Provision a clone of the existing DB cluster for the new Application team.
• C) Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).
• D) Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.

---

Definitions:

Calendar-year

A one-year period starting on January 1 and ending on December 31, used as the fiscal year by many companies.

Interest Income

Income earned on various forms of investments like savings accounts, certificates of deposit, bonds, and loans.

Credit Sales

Sales made by a business where payment is deferred, allowing the purchaser to pay at a later date.

Supplemental Detail

Additional information provided alongside financial statements to explain specific items or to disclose information not fully captured within the main financial statements.