Courseiva
← DBS-C01
Full test
Management and Operations →mediumMultiple ChoiceObjective-mapped

DBS-C01 Management and Operations Practice Question

A database administrator notices that an Amazon Aurora MySQL DB cluster's primary instance is experiencing high CPU utilization due to a long-running analytical query. The application can tolerate eventual consistency. What is the MOST cost-effective solution to reduce CPU load on the primary instance?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Configure an Auto Scaling policy for Aurora Replicas and modify the application to use the reader endpoint.

Offloading read queries to Aurora Replicas is cost-effective and reduces primary load without additional infrastructure.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✓

    Configure an Auto Scaling policy for Aurora Replicas and modify the application to use the reader endpoint.

    Why this is correct

    Aurora Replicas share the same storage and can offload SELECT queries.

  • ✗

    Create a read replica in a different region and route read traffic there.

    Why it's wrong here

    Cross-region replicas add latency and cost; not needed for eventual consistency.

  • ✗

    Increase the instance size of the primary instance.

    Why it's wrong here

    Scaling up is expensive and doesn't offload queries; it just gives more capacity.

  • ✗

    Enable Aurora Parallel Query on the cluster.

    Why it's wrong here

    Parallel Query offloads scan operations to Aurora storage, but is not as cost-effective as using replicas.

About these practice questions

This DBS-C01 question is part of Courseiva's 1,663-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.