Question

A database specialist has been entrusted by an ecommerce firm with designing a reporting dashboard that visualizes crucial business KPIs derived from the company's primary production database running on Amazon Auror a. The dashboard should be able to read data within 100 milliseconds after an update. The Database Specialist must conduct an audit of the Aurora DB cluster's present setup and provide a cost-effective alternative. The solution must support the unexpected read demand generated by the reporting dashboard without impairing the DB cluster's write availability and performance. Which solution satisfies these criteria?

Accepted Answer

Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.

Answer

Turn on the serverless option in the DB cluster so it can automatically scale based on demand.

Answer

Provision a clone of the existing DB cluster for the new Application team.

Answer

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).

A database specialist has been entrusted by an ecommerce firm with designing a reporting dashboard that visualizes crucial business KPIs derived from…

Take the free DBS-C01 practice test

Other DBS-C01 practice questions