Google Professional-Cloud-Database-Engineer Practice Test : Free Online Preparation

Question 1
- Your company is developing a global ecommerce website on Google Cloud. Your development team is
  working on a shopping cart service that is durable and elastically scalable with live traffic. Business
  disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the
  application needs to have very low latency writes. You need a data storage solution that has high write
  throughput and provides 99.99% uptime. What should you do?
  
  A : Use Cloud SQL for data storage.
  
  B : Use Cloud Spanner for data storage.
  
  C : Use Memorystore for data storage.
  
  D : Use Bigtable for data storage.
  
  Answer: A
Question 2
- You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?
  A : Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
  
  B : Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
  
  C : Create a read replica in another region, and promote the read replica if a failure occurs.
  
  D : Enable high availability (HA) for the database to make it regional.
  
  Answer: D
Question 3
- A :
  
  B :
  
  C :
  
  D :
  
  Answer: C
Question 4
- Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?
  A :
  Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your
  database changes to Cloud SQL.
  Select the Backfill historical data check box on your stream configuration to initiate Datastream to
  backfill any data that is out of sync between the source and destination.
  Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application
  to use the new instance.
  
  B :
  Create migration job using Database Migration Service.
  Set the migration job type to Continuous, and allow the databases to complete the full dump phase and
  start sending data in change data capture (CDC) mode.
  Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and
  wait for the migration job to complete.
  Update your application connections to the new instance.
  
  C :
  Create migration job using Database Migration Service.
  Set the migration job type to One-time, and perform this migration during a maintenance window.
  Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded
  into the Cloud SQL destination database and the destination database to be promoted to the primary
  database.
  Update your application connections to the new instance.
  
  D :
  Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance
  window.
  Move the files to Cloud Storage, and import each database into your Cloud SQL instance.
  Continue to dump each database until all the databases are migrated.
  Update your application connections to the new instance.
  
  Answer: C
Question 5
- Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
  A : Set up all read replicas in a different region using asynchronous replication.
  
  B : Set up all read replicas in the same region as the primary instance with synchronous replication.
  
  C : Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
  
  D : Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
  
  Answer: C

Free Google Professional-Cloud-Database-Engineer Exam Questions

Try our Free Demo Practice Tests for Comprehensive Professional-Cloud-Database-Engineer Exam Preparation