PROFESSIONAL-CLOUD-DATABASE-ENGINEER Online Practice Questions and Answers

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 SQL for PostgreSQL with both cross-region read replicas.

B. Use Cloud Spanner in a multi-region configuration.

C. Use Firestore in Datastore mode.

D. Use a Bigtable instance with clusters in multiple regions.

Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?

A. Migrate the Oracle databases to Cloud Spanner.

B. Migrate the Oracle databases to Compute Engine.

C. Migrate the Oracle databases to Cloud SQL.

D. Migrate the Oracle databases to Bare Metal Solution for Oracle.

Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?

A. Use Logs Explorer to analyze log data.

B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

C. Use Error Reporting to count, analyze, and aggregate the data.

D. Use Cloud Debugger to inspect the state of an application.

Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?

A. Create the database with Google-managed encryption keys.

B. Create the database with customer-managed encryption keys.

C. Create the database persistent disk with Google-managed encryption keys.

D. Create the database persistent disk with customer-managed encryption keys.

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

A. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).

B. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.

C. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.

D. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.

You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

A. Set the automated backups to occur every other day to lower the frequency of backups.

B. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).

C. Select a different region to store your backups.

D. Reduce the number of automated backups that are retained to two (2).

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.

You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?

A. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.

B. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.

C. Verify that the new replica is created automatically.

D. Start the original primary instance and resume replication.

Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?

A. Issue a gcloud sql instances patch command to increase the number of vCPUs.

B. Update a MySQL database flag to increase the number of vCPUs.

C. Issue a gcloud compute instances update command to increase the number of vCPUs.

D. Back up the database, create an instance with additional vCPUs, and restore the database.

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

A. Create one regional Cloud SQL instance with a read replica in another region.

B. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

C. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.

D. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.