Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER Online Practice Questions and Exam Preparation

Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER Online Questions & Answers

• Question 111:

  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.
  B. Use Cloud Spanner in a multi-region configuration.

  ---

  Explanation/Reference:

  https://cloud.google.com/blog/products/databases/manage-semi-structured-data-in-cloud-spanner-with-json

• Question 112:

  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?

  A. Use Cloud Scheduler and Cloud Functions to run the daily export.
  B. Create a streaming Datatlow job to export the table.
  C. Set up Cloud Composer, and create a task to export the table daily.
  D. Run the cron job on a Compute Engine instance to continue the export.
  A. Use Cloud Scheduler and Cloud Functions to run the daily export.

  ---

  Explanation/Reference:

  https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler

• Question 113:

  You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?

  A. Check the cloudsql.googleapis.com/postgres.log instance log.
  B. Perform the gcloud sql operations list command.
  C. Use Cloud Audit Logs to verify the status.
  D. Use the Google Cloud Console.
  B. Perform the gcloud sql operations list command.

  ---

  Explanation/Reference:

  https://cloud.google.com/sql/docs/postgres/backup-recovery/backups#troubleshooting-backups Under Troubleshooting: Issue: "You can't see the current operation's status." The Google Cloud console reports only success or failure when the operation is done. It isn't designed to show warnings or other updates. Run the gcloud sql operations list command to list all operations for the given Cloud SQL instance.

• Question 114:

  You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

  A. Use Cloud Spanner in a regional configuration.
  B. Use Cloud Spanner in a multi-region configuration.
  C. Use Cloud SQL with cross-region replicas.
  D. Use highly available Cloud SQL with multiple zones.
  A. Use Cloud Spanner in a regional configuration.

  ---

  Explanation/Reference:

  https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform

• Question 115:

  You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?

  A. Restore the Cloud SQL instance from the automatic backups in region 3.
  B. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.
  C. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.
  D. Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .
  C. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

  ---

  Explanation/Reference:

  https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery

• Question 116:

  Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?

  A. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
  B. Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.
  C. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
  D. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
  C. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.

  ---

  Explanation/Reference:

  Binary Logging enabled, with that you can identify the point of time the data was good and recover from that point time. https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#perform_the_point-in-time_recovery_using_binary_log_positions

• Question 117:

  Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?

  A. Use replication to roll out changes to higher environments.
  B. Use backup and restore to roll out changes to higher environments.
  C. Use Liquibase to roll out changes to higher environments.
  D. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
  C. Use Liquibase to roll out changes to higher environments.

  ---

  Explanation/Reference:

  To satisfy audit reporting you would need a way to record what was changed and when. The best answer is one which uses some kind of source code control system (SCCS). That rules out A and B. Any mention of anything manual in a cloud environment should look suspicious, which leave option C. As it happens, Liquibase is an SCCS and can be integrated with Spanner. https://cloud.google.com/spanner/docs/use-liquibase

• Question 118:

  You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest data. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?

  A. Create a read replica for the Sales Reporting application.
  B. Create two separate databases in the instance, and perform dual writes from the Order Management application.
  C. Use a Cloud SQL federated query for the Sales Reporting application.
  D. Queue up all the requested reports in PubSub, and execute the reports at night.
  A. Create a read replica for the Sales Reporting application.

• Question 119:

  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?

  A. Use Bigtable.
  B. Use Firestore.
  C. Use Cloud SQL for MySQL
  D. Use Cloud Spanner.
  D. Use Cloud Spanner.

  ---

  Explanation/Reference:

  Spanner covers the SLA

• Question 120:

  You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.

  You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

  A. Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.
  B. Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.
  C. Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.
  D. Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.
  C. Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.