Professional-Cloud-Database-Engineer Google Exam Questions and Free Practice Test

Question 19

Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

A. Use Cloud SQL serverless exports.

B. Create a read replica, and then use the mysqldump utility to export each table.

C. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.

D. Use the mysqldump utility on the primary database instance to export the backup.

Correct Answer:A
https://cloud.google.com/blog/products/databases/introducing-cloud-sql- serverless-exports

Question 20

Your hotel booking company is expanding into Country A, where personally identifiable
information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer data. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

A. Apply a schema data management pattern.

B. Apply an instance data management pattern.

C. Apply a table data management pattern.

D. Apply a database data management pattern.

Correct Answer:B
https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner#multi-tenancy-data-management-patterns
https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner

Question 21

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us- east1. What should you do?

A. Provision a Cloud SQL for MySQL instance in us-central1-

B. Create a multiple-zone instance in us-west1-b.Create a read replica in us-east1-c.

C. Provision a Cloud SQL for MySQL instance in us-central1-

D. Create a multiple-zone instance in us-central1-b.Create a read replica in us-east1-b.

E. Provision a Cloud SQL for MySQL instance in us-central1-

F. Create a multiple-zone instance in us-east-b.Create a read replica in us-east1-c.

G. Provision a Cloud SQL for MySQL instance in us-central1-

H. Create a multiple-zone instance in us-east1-b.Create a read replica in us-central1-b.

Correct Answer:B
https://cloud.google.com/sql/docs/sqlserver/intro-to-cloud-sql-disaster- recovery

Question 22

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow Google- recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

A. Manually scale down the number of nodes after the peak period has passed.

B. Use interleaving to co-locate parent and child rows.

C. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

D. Use granular instance sizing in Cloud Spanner and Autoscaler.

Correct Answer:D
Granular instance is available in Public Preview. With this feature, you can run workloads on Spanner at as low as 1/10th the cost of regular instances, https://cloud.google.com/blog/products/databases/get-more-out-of-spanner-with-granular- instance-sizing

Question 23

You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

A. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.

B. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.

C. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.

D. Create a Cloud Scheduler job to start maintenance at 12 AM on Sunday

E. Pause the Cloud Scheduler job between November 1 and January 15.

Correct Answer:A
"Deny maintenance period. A block of days in which Cloud SQL does not schedule maintenance. Deny maintenance periods can be up to 90 days long. "
https://cloud.google.com/sql/docs/mysql/maintenance

Question 24

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

A. Set up manual backups.

B. Create a PostgreSQL database on-premises as the HA option.

C. Configure single zone availability for automated backups.

D. Enable point-in-time recovery.

E. Schedule automated backups.

Correct Answer:DE
D. Enable point-in-time recovery - This feature allows you to restore your database to a specific point in time. It helps protect against data loss and can be used in the event of data corruption or accidental data deletion. E. Schedule automated backups - Automated backups allow you to take regular backups of your database without manual intervention. You can use these backups to restore your database in the event of data loss or corruption.

START Professional-Cloud-Database-Engineer EXAM