FC0-U71 Data and Database Fundamentals Practice Question
Which of the following are advantages of using a cloud database service (DBaaS) compared to an on-premises database? (Select TWO.)
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
✓
Managed maintenance and updates
DBaaS provides managed maintenance and automatic scalability without hardware management. High availability is inherent, and initial cost is lower (pay-as-you-go).
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Full control over underlying hardware
Why it's wrong here
Full control over underlying hardware is an on-premises or IaaS characteristic; DBaaS abstracts the host, patching and replication away from the customer. It is tempting because DBaaS does expose some instance sizing and parameter options, but that is configuration within a managed platform, not hardware control, so it is not an advantage.
- ✗
Requires dedicated IT staff for database administration
Why it's wrong here
Dedicated IT staff for database administration is a cost of on-premises operation, not an advantage of DBaaS; the provider handles patching, backups and scaling. It is tempting because DBaaS still needs some staff for schema, query tuning and access control, but that is shared responsibility, not dedicated infrastructure administration.
- ✓
Managed maintenance and updates
Why this is correct
DBaaS shifts patching, version upgrades and backups to the provider, so the customer inherits automatic maintenance rather than scheduling downtime and applying updates themselves. This directly satisfies the stem's advantage over on-premises databases, where the internal team owns every maintenance window.
- ✗
Higher initial capital expenditure
Why it's wrong here
Higher initial capital expenditure describes on-premises databases, where servers and licences are bought upfront; DBaaS shifts spend to operational subscription costs. It is tempting because large cloud commitments can look capital-like, but the billing model remains consumption-based operating expenditure, so it is the opposite of a DBaaS advantage.
- ✓
Automatic scalability
Why this is correct
Automatic scalability satisfies the elastic-demand constraint: DBaaS platforms provision additional compute, storage and IOPS on demand, whereas on-premises hardware requires manual capacity planning and procurement lead time. This lets workloads absorb traffic spikes without over-provisioning, an advantage unavailable when you own the underlying servers.
Go deeper
Related to this question
About these practice questions
One of 988 original FC0-U71 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This FC0-U71 practice question is part of Courseiva's free CompTIA 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 FC0-U71 exam.