Free Professional-Cloud-Database-Engineer Exam Dumps

No Installation Required, Instantly Prepare for the Professional-Cloud-Database-Engineer exam and please click the below link to start the Professional-Cloud-Database-Engineer Exam Simulator with a real Professional-Cloud-Database-Engineer practice exam questions.
Use directly our on-line Professional-Cloud-Database-Engineer exam dumps materials and try our Testing Engine to pass the Professional-Cloud-Database-Engineer which is always updated.

Exam Code: Professional-Cloud-Database-Engineer
Exam Title: Google Cloud Certified - Professional Cloud Database Engineer
Vendor: Google
Exam Questions: 132
Last Updated: December 21st,2024

Question 1

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google- recommended practices for high availability. What should you do?

A. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
B. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
C. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
D. Configure the primary, standby, and read replica instances in zone A, all in the same region.

Correct Answer:A
https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview

Question 2

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

A. Take no backups, and turn off transaction log retention.
B. Take one manual backup per day, and turn off transaction log retention.
C. Turn on automated backup, and turn off transaction log retention.
D. Turn on automated backup, and turn on transaction log retention.

Correct Answer:C
https://cloud.google.com/sql/docs/mysql/backup-recovery/backups

Question 3

You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?

A. Automate instance creation by writing a Dataflow job.
B. Automate instance creation by setting up Terraform scripts.
C. Create the instances using the Google Cloud Console UI.
D. Create clones from a template Cloud SQL instance.

Correct Answer:B

Question 4

Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?

A. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
B. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
C. Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
D. Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

Correct Answer:B
https://cloud.google.com/sql/docs/mysql/maintenance?hl=fr

Question 5

Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)

A. Create secondary indexes on the replica.
B. Create additional read replicas, and partition your analytics users to use different read replicas.
C. Disable replication on the read replica, and set the flag for parallel replication on the read replic
D. Re-enable replication and optimize performance by setting flags on the primary instance.
E. Disable replication on the primary instance, and set the flag for parallel replication on the primary instanc
F. Re-enable replication and optimize performance by setting flags on the read replica.
G. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.

Correct Answer:BC
Replication lag and slow report performance. E is eliminated because using BigQuery would mean changes to the current reports. Report slowness could be the result of poor indexing or just too much read load (or both!). Since excessive load is mentioned in the question, creating additional read replicas and spreading the analytics workload around makes B correct and eliminates A as a way to speed up reporting. That leaves the replication problem. Cloud SQL enables single threaded replication by default, so it stands to reason enabling parallel replication would help the lag. To do that you disable replication on the replica (not the primary), set flags on the replica and optionally set flags on the primary instance to optimize performance for parallel replication. That makes C correct and D incorrect. https://cloud.google.com/sql/docs/mysql/replication/manage- replicas#configuring-parallel-replication