Home / Google / Professional Cloud Database Engineer

Google Professional Cloud Database Engineer Practice Test - Questions Answers, Page 11

Question list

List of questions

Question 101

(0)

You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies: PostgreSQL databases must be migrated to a multi-region backup configuration wit

Question 102

(0)

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was pr

Question 103

(0)

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99

Question 104

(0)

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degrade

Question 105

(0)

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 unplan

Question 106

(0)

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on yo

Question 107

(0)

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 an

Question 108

(0)

Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up al

Question 109

(0)

You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You

Question 110

(0)

Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB

Question 101

You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:

PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.

MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.

You want to set up the environment with minimal administrative effort. What should you do?

Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.

Set up different organizations for each database type, and apply policy constraints at the organization level.

Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.

Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

Show Answer Comment (0)

Question 102

Bring DB-1 back online.

Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

Delete DB-2 so that DB-1 automatically reverts to the primary instance.

Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Show Answer Comment (0)

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

Use Bigtable.

Use Firestore.

Use Cloud SQL for MySQL

Use Cloud Spanner.

Show Answer Comment (0)

Question 104

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

View Cloud SQL operations to view historical query information.

White a Logs Explorer query to identify database queries with high execution times.

Review application logs to identify database calls.

Use the Query Insights dashboard to identify high execution times.

Show Answer Comment (0)

Question 105

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

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

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

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

Show Answer Comment (0)

Question 106

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

Shut down your existing Cloud SQL for MySQL instance, and enable HA.

Show Answer Comment (0)

Question 107

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?

Configure the automated backups to use a regional Cloud Storage bucket as a custom location.

Use the default configuration for the automated backups location.

Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

Show Answer Comment (0)

Question 108

Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.

Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

Show Answer Comment (0)

Question 109

You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?

Use Cloud Scheduler and Cloud Functions to run the daily export.

Create a streaming Datatlow job to export the table.

Set up Cloud Composer, and create a task to export the table daily.

Run the cron job on a Compute Engine instance to continue the export.

Show Answer Comment (0)

Question 110

Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?

Use Database Migration Service to connect to your on-premises database, and choose continuous replication. After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.

Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL. Schedule downtime to run each Cloud Data Fusion pipeline. Verify that the migration was successful. Re-point the applications to the Cloud SQL for MySQL instance.

Pause the on-premises applications. Use the mysqldump utility to dump the database content in compressed format. Run gsutil --m to move the dump file to Cloud Storage. Use the Cloud SQL for MySQL import option. After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

Pause the on-premises applications. Use the mysqldump utility to dump the database content in CSV format. Run gsutil --m to move the dump file to Cloud Storage. Use the Cloud SQL for MySQL import option. After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

Show Answer Comment (0)

Total 132 questions