Google Professional Cloud Database Engineer exam Question and Updated Info

Google Professional Cloud Database Engineer Exam Questions

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 132

$59.00

Exam Details

Exam Name:

Google Cloud Certified - Professional Cloud Database Engineer

Exam Code:

Professional-Cloud-Database-Engineer

Total Questions in Exam:

132

Demo Questions

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

Answer

$59.00

Reviews

There are no reviews yet.

Be the first to review “Google Professional Cloud Database Engineer Exam Questions”

Google Professional Cloud Database Engineer Exam Questions

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 132

Exam Details

Demo Questions

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.

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 .

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.

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.

Reviews

Quick Links

Contact Us