Prepare with Google : Professional-Cloud-Database-Engineer exam braindumps as your best preparation materials

You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process data. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?

• A. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
• B. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
• C. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
• D. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?

• A. Use the default app profile with single-cluster routing.
• B. Create a custom app profile with single-cluster routing.
• C. Create a custom app profile with multi-cluster routing.
• D. Use the default app profile with multi-cluster routing.

You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?

• A. Reset your SSL configuration, and download your server certificate.
• B. Create a new server certificate, and download it.
• C. Issue a rollback, and download your server certificate.
• D. Create a new client certificate, and download it.

You are configuring a new application that has access to an existing Cloud Spanner database.
The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

• A. Create a new service account, and grant it the Cloud Spanner Database Reader role.
• B. Reuse the existing service account that populates this database.
• C. Create a new service account, and grant it the spanner.databases.select permission.
• D. Create a new service account, and grant it the Cloud Spanner Database Admin role.

At Nimbus Retail you manage a Cloud SQL for MySQL instance called reporting-sql-01. The team needs to export a full database to Cloud Storage and later import it back into the same instance using gcloud without doing any format conversion. Which command should you run to create the export so that it can be imported back into Cloud SQL?

• A. gsutil cp gs://example-bucket-42/retail_backup.sql.gz | gcloud sql import sql reporting-sql-01 - database=analyticsdb -gzip
• B. gcloud sql export csv reporting-sql-01 gs://example-bucket-42/retail_backup.sql.gz - database=analyticsdb -gzip
• C. gcloud sql import csv reporting-sql-01 gs://example-bucket-42/export.csv -database=analyticsdb - gzip
• D. gcloud sql export sql reporting-sql-01 gs://example-bucket-42/retail_backup.sql.gz - database=analyticsdb -gzip