A database administrator notices that a frequently run query on BigQuery scans a large amount of data and incurs high costs. Which query optimization technique would directly reduce the amount of data scanned?

Adding an ORDER BY clause to sort results.

Increasing the number of slots for the query.

Using SELECT * to retrieve all columns.

Using a WHERE clause to filter partitions.

A company runs a Cloud SQL for PostgreSQL instance for its application. The instance is currently sized at 8 vCPUs and 32 GB of memory. The team expects a 2x increase in traffic next month. They want to ensure the instance can handle the load without downtime. What should they do?

Add a read replica to handle the increased read traffic.

Wait for the traffic to increase and then scale up if needed.

Migrate to Cloud Spanner to handle the increased load.

Scale up the instance to 16 vCPUs and 64 GB of memory before the traffic increase.

A company runs a Cloud Spanner instance for its financial transactions. The instance is configured as a single-region in `us-central1`. The team needs to ensure that the database can survive a regional outage and maintain low write latency. What should they do?

Use a single-region configuration in a different region.

Create a read replica in a different region.

Change the instance to a multi-region configuration like `nam3`.

Take frequent backups and restore them in another region.

A retail company runs a Cloud SQL for MySQL instance for its e-commerce platform. The workload has predictable spikes during holiday sales and a steady baseline the rest of the year. The team wants to automate scaling to handle the spikes without manual intervention. What should they configure?

Migrate to Cloud Spanner for automatic scaling.

Enable automatic storage increases.

Set up a cron job to increase the machine type before the sale and decrease it after.

Use the Cloud SQL API to scale down during the sale.

Google CloudProfessional Cloud Database Engineer

Domain 2Objective 4

2.4 Optimize Database Cost and Performance in Google Cloud PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 4)

Part of the Manage a solution that can span multiple database technologies domain, which accounts for ~25% of the PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam.

23questions here

5free pages

5concepts

~25%of the exam

Questions 16–20

16foundation · easy
A database administrator notices that a frequently run query on BigQuery scans a large amount of data and incurs high costs. Which query optimization technique would directly reduce the amount of data scanned?
Select an answer first
17expert · medium
A company runs a Cloud SQL for PostgreSQL instance for its application. The instance is currently sized at 8 vCPUs and 32 GB of memory. The team expects a 2x increase in traffic next month. They want to ensure the instance can handle the load without downtime. What should they do?
Select an answer first
18foundation · easy
A database administrator wants to identify underutilized Cloud SQL instances that could be downsized to reduce costs. Which Google Cloud tool should be used to analyze historical CPU and memory utilization?
Select an answer first
19expert · medium
A company runs a Cloud Spanner instance for its financial transactions. The instance is configured as a single-region in `us-central1`. The team needs to ensure that the database can survive a regional outage and maintain low write latency. What should they do?
Select an answer first
20application · medium
A retail company runs a Cloud SQL for MySQL instance for its e-commerce platform. The workload has predictable spikes during holiday sales and a steady baseline the rest of the year. The team wants to automate scaling to handle the spikes without manual intervention. What should they configure?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-CLOUD-DATABASE-ENGINEER” is a trademark of its owner, used for identification only.