Google ACE Deploying and Implementing a Cloud Solution Practice Question
An engineer needs to create a Cloud SQL MySQL instance with 4 vCPUs, 15 GB of RAM, and a root password. The instance should be in the us-east1 region. Which command should the engineer run?
⚠ Common exam trap
ACE often tests whether candidates can decode the `db-custom-<vCPU>-<memoryMB>` format and distinguish `--region` from `--zone` — picking a zone value for `--region` is a classic distractor.
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
✓
gcloud sql instances create my-instance --database-version=MYSQL_8_0 --tier=db-custom-4-15360 --region=us-east1 --root-password=myPassword
The correct command must specify a custom machine type matching 4 vCPUs and 15 GB RAM, which is `db-custom-4-15360` (the format is db-custom-<vCPUs>-<memoryMB>). It must also include the root password and target the us-east1 region (not a zone). Option D is the only command that includes all required parameters: MYSQL_8_0, the correct custom tier, the region, and the root password.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
gcloud sql instances create my-instance --database-version=MYSQL_8_0 --tier=db-custom-4-15360 --region=us-east1
Why it's wrong here
Missing --root-password flag.
- ✗
gcloud sql instances create my-instance --database-version=MYSQL_5_7 --tier=db-n1-standard-4 --region=us-east1-a --root-password=myPassword
Why it's wrong here
Wrong database version, wrong tier format, and region includes zone suffix.
- ✗
gcloud sql instances create my-instance --database-version=MYSQL_8_0 --tier=db-custom-2-7680 --region=us-east1 --root-password=myPassword
Why it's wrong here
Incorrect tier (2 vCPU, 7.5 GB RAM instead of 4 vCPU, 15 GB).
- ✓
gcloud sql instances create my-instance --database-version=MYSQL_8_0 --tier=db-custom-4-15360 --region=us-east1 --root-password=myPassword
Why this is correct
The `--tier=db-custom-4-15360` flag defines a custom machine type with exactly 4 vCPUs and 15360 MB (15 GB) of RAM, satisfying the stem's sizing constraint. Combined with `--database-version=MYSQL_8_0`, `--region=us-east1` and `--root-password`, it fulfils every stated requirement in one command.
Go deeper
Related to this question
Learn chapter
Compute Engine Machine Types and Families
Key term
Region
A region is a distinct geographic location where a cloud provider operates multiple data centers that are connected by low-latency networks and provide cloud services.
Key term
Machine type
A machine type defines the virtual hardware resources (vCPU, memory, and sometimes GPU) assigned to a virtual machine instance in a cloud computing environment.
About these practice questions
This ACE question is part of Courseiva's 775-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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Google Cloud exam blueprint
This ACE practice question is part of Courseiva's free Google Cloud 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 ACE exam.