DBS-C01 Management and Operations Practice Question
A company runs an Amazon RDS for SQL Server database. The database size is 500 GB. The company needs to create a test environment with a copy of the production database that refreshes daily. Which THREE steps should be taken to automate this? (Choose THREE.)
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
✓
Use AWS Backup or AWS Lambda to take a manual snapshot of the production DB instance daily.
Creates a manual snapshot of the production DB instance daily using AWS Backup or Lambda. Option D restores that snapshot to a new DB instance in the test environment. Option B updates the test application's connection string to point to the new test instance. Option C is incorrect because a read replica is not a full copy and promoting it would disrupt replication, not provide a daily refreshed copy. Option E is unnecessary because the restored instance can have automated backups enabled, but it is not a required step for the daily refresh process.
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 AWS Backup or AWS Lambda to take a manual snapshot of the production DB instance daily.
Why this is correct
Creates a consistent snapshot.
- ✓
Update the test application's connection string to point to the new test instance.
Why this is correct
Ensures application uses the refreshed database.
- ✗
Create a read replica of the production instance and promote it to the test environment.
Why it's wrong here
Read replica would incur ongoing replication costs.
- ✓
Restore the snapshot to a new DB instance in the test environment.
Why this is correct
Restores the snapshot as a new instance.
- ✗
Enable automated backups on the test instance after restoration.
Why it's wrong here
Not required for the daily refresh.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
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 →
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.