Online Access Free Professional-Cloud-Database-Engineer Exam Questions

You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?

• A.Use query tags to add application-centric database monitoring.
• B.Write a utility to scan database query logs.
• C.Write a utility to scan application logs.
• D.Shut down and restart each application.

You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?

• A.Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
• B.Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
• C.Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross- region read replica, and promote the read replica as the primary node for disaster recovery.
• D.Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.

You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

• A.Use the default configuration for the automated backups location.
• B.Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
• C.Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
• D.Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hotspots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

• A.Use bit-reverse sequential value as the primary key.
• B.Promote low-cardinality attributes in multi-attribute primary keys.
• C.Use an auto-incrementing value as the primary key.
• D.Promote high-cardinality attributes in multi-attribute primary keys.
• E.Normalize the data model.

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
- Work with transactions and offer strong consistency.
- Work with structured and semi-structured (JSON) data.
- Scale transparently to multiple regions globally as the operation
grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?

• A.Use Cloud Spanner in a multi-region configuration.
• B.Use a Bigtable instance with clusters in multiple regions.
• C.Use Cloud SQL for PostgreSQL with both cross-region read replicas.
• D.Use Firestore in Datastore mode.