Question 753 of 1,024
Cloud Technology and ServicesmediumMultiple ChoiceObjective-mapped

CLF-C02 Cloud Technology and Services Practice Question

This CLF-C02 practice question tests your understanding of cloud technology and services. The scenario asks you to isolate a root cause — eliminate options that address a different problem before choosing. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

A company runs a customer relationship management (CRM) application on a single Amazon RDS for PostgreSQL instance. The application experiences heavy read traffic during business hours, often causing the primary database to become overloaded with SELECT queries. The company needs a solution that offloads read queries to a separate database endpoint and provides automatic failover to a standby database in a different Availability Zone if the primary fails. Which combination of Amazon RDS features should the company use to meet these requirements?

Clue words in this question

Noticing these words before you look at the options changes how you read each choice.

  • Clue: "primary"

    Why it matters: Asks for the main purpose or function, not a secondary benefit. Eliminate answers that describe side-effects or partial functions.

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

Multi-AZ deployment with one or more Read Replicas

Option C is correct because it combines Multi-AZ deployment for automatic failover to a standby in a different Availability Zone with Read Replicas to offload SELECT queries to a separate database endpoint. Multi-AZ ensures high availability by synchronously replicating data to a standby instance, while Read Replicas asynchronously replicate data to handle read-heavy traffic without burdening the primary.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

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

  • Multi-AZ deployment only

    Why it's wrong here

    A Multi-AZ deployment provides automatic failover to a standby in a different Availability Zone, but the standby is not active for reads; it only takes over on failure. This does not offload read queries.

    When this WOULD be correct

    A company needs high availability and automatic failover for a production database with no need to offload read traffic. The question would specify that read performance is not a concern, only fault tolerance across AZs.

  • Read Replicas only

    Why it's wrong here

    Read Replicas provide a separate read-only endpoint to offload SELECT queries, but they do not provide automatic failover. If the primary database fails, you must manually promote a Read Replica, which incurs downtime.

    When this WOULD be correct

    A company needs to offload read queries from a primary database to improve read performance, but does not require automatic failover or high availability. For example, a reporting application that can tolerate brief downtime during manual promotion.

  • Multi-AZ deployment with one or more Read Replicas

    Why this is correct

    A Multi-AZ deployment ensures high availability with automatic failover to a standby in a different AZ. Adding Read Replicas offloads read traffic from the primary instance, reducing its load. Both features can be combined.

    Clue confirmation

    The clue word "primary" in the question point toward this answer.

    Related concept

    Read the scenario before looking for a memorised answer.

  • Cross-Region Read Replicas only

    Why it's wrong here

    Cross-Region Read Replicas provide read scaling and disaster recovery across AWS Regions, but they do not provide automatic failover in the primary region. If the primary database fails, you would still need to manually promote a replica, and the solution does not address high availability within a single region.

    When this WOULD be correct

    A company needs to offload read queries from a primary database and also requires disaster recovery across AWS regions, with the ability to promote a read replica to a standalone database in another region if the primary fails. The question would specify that the standby must be in a different AWS region, not just a different Availability Zone.

Option-by-option analysis

Why each answer is right or wrong

Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The CLF-C02 exam frequently reuses these exact scenarios with slightly different constraints.

Multi-AZ deployment with one or more Read ReplicasCorrect answer

Why this is correct

A Multi-AZ deployment ensures high availability with automatic failover to a standby in a different AZ. Adding Read Replicas offloads read traffic from the primary instance, reducing its load. Both features can be combined.

Multi-AZ deployment onlyWrong answer — click to see why

Why this is wrong here

Multi-AZ deployment provides automatic failover to a standby in a different AZ but does not offload read traffic; the standby is not used for reads. The requirement to offload SELECT queries requires Read Replicas.

★ When this WOULD be the correct answer

A company needs high availability and automatic failover for a production database with no need to offload read traffic. The question would specify that read performance is not a concern, only fault tolerance across AZs.

Why candidates choose this

Candidates may think Multi-AZ includes read scaling because the standby is available, but AWS RDS Multi-AZ standby is not accessible for reads; it only serves as a failover target.

Read Replicas onlyWrong answer — click to see why

Why this is wrong here

Read Replicas only offload read traffic but do not provide automatic failover to a standby in a different Availability Zone; they require manual promotion for failover, which does not meet the automatic failover requirement.

★ When this WOULD be the correct answer

A company needs to offload read queries from a primary database to improve read performance, but does not require automatic failover or high availability. For example, a reporting application that can tolerate brief downtime during manual promotion.

Why candidates choose this

Candidates may think that Read Replicas alone can handle both read offloading and failover, overlooking that automatic failover is a distinct feature of Multi-AZ deployments.

Cross-Region Read Replicas onlyWrong answer — click to see why

Why this is wrong here

Cross-Region Read Replicas are designed for disaster recovery and reducing latency for geographically distant users, not for offloading read traffic within the same region or providing automatic failover to a standby in a different Availability Zone within the same region.

★ When this WOULD be the correct answer

A company needs to offload read queries from a primary database and also requires disaster recovery across AWS regions, with the ability to promote a read replica to a standalone database in another region if the primary fails. The question would specify that the standby must be in a different AWS region, not just a different Availability Zone.

Why candidates choose this

Candidates may confuse 'different Availability Zone' with 'different region' or think that cross-region replicas inherently provide failover, not realizing that Multi-AZ is needed for automatic failover within a region.

Analysis generated from the official CLF-C02blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates often assume Multi-AZ alone can handle read offloading because the standby is available, but AWS explicitly prevents reads from the Multi-AZ standby to maintain consistency, making Read Replicas necessary for read scaling.

Detailed technical explanation

How to think about this question

Under the hood, Multi-AZ uses synchronous replication to a standby instance in a different AZ, with automatic DNS failover in under 60 seconds during primary failure. Read Replicas use asynchronous replication (based on PostgreSQL streaming replication) and can be promoted to standalone instances, but they do not provide automatic failover without manual intervention or additional configuration like a Multi-AZ deployment.

KKey Concepts to Remember

  • Read the scenario before looking for a memorised answer.
  • Find the constraint that changes the correct option.
  • Eliminate answers that are true in general but not in this case.

TExam Day Tips

  • Watch for words such as best, first, most likely and least administrative effort.
  • Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

An e-commerce site experiences heavy traffic on Black Friday and near-zero traffic during off-peak weeks. Rather than provisioning permanent large VMs, the team uses auto-scaling groups that add capacity automatically under load and reduce it overnight. Questions like this test whether you understand elasticity, availability zones, and cloud compute scaling patterns.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related practice questions

Related CLF-C02 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Practice this exam

Start a free CLF-C02 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

FAQ

Questions learners often ask

What does this CLF-C02 question test?

Cloud Technology and Services — This question tests Cloud Technology and Services — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: Multi-AZ deployment with one or more Read Replicas — Option C is correct because it combines Multi-AZ deployment for automatic failover to a standby in a different Availability Zone with Read Replicas to offload SELECT queries to a separate database endpoint. Multi-AZ ensures high availability by synchronously replicating data to a standby instance, while Read Replicas asynchronously replicate data to handle read-heavy traffic without burdening the primary.

What should I do if I get this CLF-C02 question wrong?

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Are there clue words in this question I should notice?

Yes — watch for: "primary". Asks for the main purpose or function, not a secondary benefit. Eliminate answers that describe side-effects or partial functions.

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Keep practising

More CLF-C02 practice questions

Last reviewed: Jun 11, 2026

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

Sign in to join the discussion.

This CLF-C02 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 CLF-C02 exam.