Courseiva

FC0-U71 Data and Database Fundamentals Practice Question

A database administrator needs to choose a database for an e-commerce application that requires high availability and automatic scaling. Which TWO options are cloud database services?

⚠ Common exam trap

The trap is confusing 'database software' with 'cloud database service' — FC0-U71 tests whether you recognize that MySQL Community Edition and SQL Server Express are self-managed products, not cloud services.

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

✓

Google Cloud SQL

Google Cloud SQL (B) is a fully managed, cloud-hosted relational database service on Google Cloud Platform that supports MySQL, PostgreSQL, and SQL Server, making it a cloud database service suitable for high availability and scaling needs. Amazon RDS (E) is AWS's managed relational database service that automates provisioning, patching, backups, and Multi-AZ failover, directly matching the e-commerce requirement for high availability and automatic scaling. By contrast, SQLite (A) is an embedded, serverless file-based library, not a cloud service. Microsoft SQL Server Express (C) is a free on-premises edition of SQL Server with size and resource limits, and MySQL Community Edition (D) is a self-managed open-source database typically deployed on your own infrastructure, so neither is a managed cloud database service.

Answer analysis

Option-by-option breakdown

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

  • ✗

    SQLite

    Why it's wrong here

    SQLite is an embedded, file-based library, not a cloud service, so it cannot deliver the managed high availability or automatic scaling the e-commerce application demands. It is tempting because it is a genuine relational database, and it would be the right choice for a local, single-user application or mobile app needing zero configuration.

  • ✓

    Google Cloud SQL

    Why this is correct

    Google Cloud SQL is a fully managed relational database service hosted on Google Cloud, so it satisfies the stem's cloud database requirement. The provider handles availability and scaling, meeting the high-availability and automatic-scaling constraint for the e-commerce application.

  • ✗

    Microsoft SQL Server Express

    Why it's wrong here

    SQL Server Express is an on-premises edition limited to 10 GB per database, with no automatic scaling or high availability. It is tempting because it is free and relational, and would be correct for a small local application with modest data and no resilience requirement.

  • ✗

    MySQL Community Edition

    Why it's wrong here

    MySQL Community Edition is self-hosted software; the administrator must provision servers, clustering and scaling themselves, so it provides no managed cloud high availability or automatic scaling. It is tempting because MySQL is a relational database, and it would be correct for an on-premises deployment where the team controls the infrastructure.

  • ✓

    Amazon RDS

    Why this is correct

    Amazon RDS is a managed relational database service running on AWS infrastructure, making it a cloud database service. It satisfies the stem's high-availability and automatic-scaling requirement, since AWS handles provisioning, failover and scaling rather than on-premises hardware.

Quick reference

Cloud Service Model Comparison

ModelYou ManageProvider ManagesExamples
IaaSOS, runtime, apps, dataHardware, hypervisor, networkingEC2, Azure VMs, GCP Compute Engine
PaaSApps and dataOS, runtime, middleware, hardwareElastic Beanstalk, Azure App Service
SaaSData and settings onlyEverything elseMicrosoft 365, Salesforce, Workday
FaaS / ServerlessFunction code onlyInfra, scaling, runtimeLambda, Azure Functions, Cloud Run
CaaSContainers and appsKubernetes, OS, hardwareEKS, AKS, GKE

About these practice questions

This FC0-U71 question is part of Courseiva's 988-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 and reviewed by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

Last reviewed September 2026 · checked against the official CompTIA exam blueprint

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.