The correct answer is to provision a separate Amazon RDS instance for each tenant. This model ensures strong multi-tenant database isolation by dedicating an entire relational database engine to a single tenant, which is essential for a SaaS application requiring complex joins and strict data separation. On the AWS Certified Database Specialty DBS-C01 exam, this scenario tests your understanding of the trade-off between isolation and cost: a single RDS instance with a tenant_id column risks the “noisy neighbor” problem where one tenant’s heavy workload degrades performance for others, while DynamoDB (a NoSQL option) lacks native relational join support and Redshift is built for analytical workloads, not OLTP. A common trap is choosing a shared database for cost savings, but the question’s emphasis on “strong isolation” and “complex joins” points directly to separate RDS instances. Memory tip: “One tenant, one RDS” — if the data must be walled off and relational, isolate at the instance level.
DBS-C01 Workload-Specific Database Design Practice Question
This DBS-C01 practice question tests your understanding of workload-specific database design. Compare every option against the stated constraints before choosing — the best answer satisfies all requirements, not just the most obvious one. 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 startup is building a multi-tenant SaaS application where each tenant's data must be isolated. The data model is relational with complex joins. Which database deployment model is most appropriate?
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Provision a separate Amazon RDS instance for each tenant
Option B is correct because a separate RDS instance per tenant provides strong isolation. Option A (single table with tenant_id) risks noisy neighbors. Option C (DynamoDB single table) is not relational. Option D (Redshift) is for analytics, not OLTP.
Key principle: OSPF neighbour adjacency depends on matching area, hello/dead timers, network type, and authentication — IP reachability alone is not enough.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✗
Use a single Amazon DynamoDB table with a tenant_id partition key
Why it's wrong here
DynamoDB is NoSQL and not ideal for complex relational joins.
✗
Use a single Amazon Redshift cluster with tenant_id distribution key
Why it's wrong here
Redshift is a data warehouse, not designed for transactional multi-tenant workloads.
✓
Provision a separate Amazon RDS instance for each tenant
Why this is correct
Separate instances ensure complete data isolation and independent scaling.
Use a single Amazon RDS database with a tenant_id column on every table
Why it's wrong here
Single database does not provide full isolation and can have performance interference.
Common exam traps
Common exam trap: OSPF can fail even when IP connectivity looks correct
OSPF neighbour formation depends on matching areas, timers, network type, authentication and passive-interface behaviour. Do not choose an answer only because the devices can ping.
Detailed technical explanation
How to think about this question
OSPF questions usually test the details that control adjacency and route selection. Read the neighbour state, area, router ID and interface configuration before deciding what is wrong.
KKey Concepts to Remember
OSPF neighbours must agree on key parameters.
Router ID selection can affect neighbour relationships and LSDB output.
OSPF cost influences the preferred path.
A route can appear in OSPF information but not become the installed route.
TExam Day Tips
→Check area mismatch first when OSPF adjacency fails.
→Review passive interfaces when a network is advertised but no neighbour forms.
→Use show ip ospf neighbor and show ip route clues carefully.
Key takeaway
OSPF neighbour adjacency depends on matching area, hello/dead timers, network type, and authentication — IP reachability alone is not enough.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. OSPF neighbour adjacency depends on matching area, hello/dead timers, network type, and authentication — IP reachability alone is not enough. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Got this wrong? Here's your next step.
Review OSPF neighbour requirements — matching area type, hello and dead timers, network type, stub flags, and authentication. Study show ip ospf neighbor states (INIT, 2-WAY, FULL). Then practise related DBS-C01 OSPF questions on adjacency and route selection.
Workload-Specific Database Design — This question tests Workload-Specific Database Design — OSPF neighbours must agree on key parameters..
What is the correct answer to this question?
The correct answer is: Provision a separate Amazon RDS instance for each tenant — Option B is correct because a separate RDS instance per tenant provides strong isolation. Option A (single table with tenant_id) risks noisy neighbors. Option C (DynamoDB single table) is not relational. Option D (Redshift) is for analytics, not OLTP.
What should I do if I get this DBS-C01 question wrong?
Review OSPF neighbour requirements — matching area type, hello and dead timers, network type, stub flags, and authentication. Study show ip ospf neighbor states (INIT, 2-WAY, FULL). Then practise related DBS-C01 OSPF questions on adjacency and route selection.
What is the key concept behind this question?
OSPF neighbours must agree on key parameters.
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 →
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.
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.
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.
Sign in to join the discussion.