Q1: You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

A: Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

B: Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

C: Create a read replica in another region, and promote the read replica if a failure occurs.

D: Enable high availability (HA) for the database to make it regional.

Answer

Correct Answer: D

Q2: You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?

A: Restore the Cloud SQL instance from the automatic backups in region 3.

B: Restore the Cloud SQL instance from the automatic backups in another zone in region 1.

C: Check 'Lag Bytes' in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

D: Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .

Answer

Correct Answer: C

Q3: You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

A: Place the bulk of the read and write workloads closer to the default leader region.

B: Use staleness of at least 15 seconds.

C: Add more read-write replicas.

D: Keep the total CPU utilization under 45% in each region.

Answer

Correct Answer: A

Q4: You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises. You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

A: Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.

B: Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.

C: Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.

D: Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.

Answer

Correct Answer: C

- Testimonials -

Real Results From Real Students

John Doe

This site has been a game-changer for my certification journey. The materials are current, reliable, and best of all—free! It's clear they're committed to supporting the IT community.

Emma

I passed my CompTIA Security+ exam on the first try thanks to this site. Their practice exams and study guides are top-notch. Highly recommend it to anyone serious about IT certifications.

Liam

I’ve passed three certifications using this site. Their materials are detailed and well-structured, and the fact that it’s free makes it even better.

Isabella

If you're studying for any IT certification, this should be your first stop. It’s comprehensive, organized, and constantly updated.

Benjamin

This website helped me prepare for multiple certifications, and today I’m working in cybersecurity. Without their free resources, I wouldn’t be here.

info@certsmasters.com

Exam overview

Google Professional Cloud Database Engineer Exam Questions

Purchase

$ 40

One-time payment • Instant access

Frequently Ask Questions

Hot Exams

Exam practice

Exam Q&A

Q4: You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises. You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

- Testimonials -

Real Results From Real Students

Useful Links

Extra Links