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

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

• Question 21:

  Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?

  A. Migrate to Cloud SQL for SQL Server.
  B. Migrate to Cloud SQL for PostgreSQL.
  C. Migrate to Compute Engine.
  D. Migrate to Google Kubernetes Engine (GKE).
  C. Migrate to Compute Engine.

  ---

  Explanation/Reference:

  https://cloud.google.com/sql/docs/sqlserver/features

• Question 22:

  You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?

  A. Use Cloud SQL instance monitoring.
  B. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
  C. Use Cloud SQL logs.
  D. Use the SQL Server Always On Availability Group dashboard.
  D. Use the SQL Server Always On Availability Group dashboard.

  ---

  Explanation/Reference:

  Note, you cannot create a read replica in Cloud SQL for SQL Server unless you use an Enterprise Edition. Which is also a requirement for configuring SQL Server AG. That's not a coincidence. That's how Cloud SQL for SQL Server creates SQL Server read replicas. To find out about the replication, use the AG Dashboard in SSMS. https://cloud.google.com/sql/docs/sqlserver/replication/manage-replicas#promote-replica

• Question 23:

  Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

  A. Set Terraform deletion_protection to true.
  B. Rerun terraform apply.
  C. Create a read replica.
  D. Use point-in-time-recovery (PITR) to recover the database.
  A. Set Terraform deletion_protection to true.

  ---

  Explanation/Reference:

  From Google's documentation, "For stateful resources, such as databases, ensure that deletion protection is enabled. The syntax is: lifecycle { prevent_destroy = true } https://cloud.google.com/docs/terraform/best-practices-forterraform#stateful-resources

• Question 24:

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

  ---

  Explanation/Reference:

  https://cloud.google.com/sql/docs/mysql/backup-recovery/backing-up#locationbackups You can use a custom location for on-demand and automatic backups. For a complete list of valid location values, see the Instance locations.

• Question 25:

  You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)

  A. Use a change data capture (CDC) migration strategy.
  B. Move the physical database servers from on-premises to Google Cloud.
  C. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
  D. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
  E. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
  A. Use a change data capture (CDC) migration strategy.
  E. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

  ---

  Explanation/Reference:

  https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer

• Question 26:

  You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

  A. Place the bulk of the read and write workloads closer to the default leader region.
  B. Use staleness of at least 15 seconds.
  C. Add more read-write replicas.
  D. Keep the total CPU utilization under 45% in each region.
  A. Place the bulk of the read and write workloads closer to the default leader region.

  ---

  Explanation/Reference:

  https://cloud.google.com/spanner/docs/instance-configurations#multi-region-best-practices Best practices For optimal performance, follow these best practices: Design a schema that prevents hotspots and other performance issues. For optimal write latency, place compute resources for write-heavy workloads within or close to the default leader region. For optimal read performance outside of the default leader region, use staleness of at least 15 seconds. To avoid single-region dependency for your workloads, place critical compute resources in at least two regions. A good option is to place them next to the two different read-write regions so that any single region outage will not impact all of your application. Provision enough compute capacity to keep high priority total CPU utilization under 45% in each region.

• Question 27:

  Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

  A. Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-west1-b. Create a read replica in us-east1-c.
  B. Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-central1-b. Create a read replica in us-east1-b.
  C. Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-east-b. Create a read replica in us-east1-c.
  D. Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-east1-b. Create a read replica in us-central1-b.
  B. Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-central1-b. Create a read replica in us-east1-b.

  ---

  Explanation/Reference:

  https://cloud.google.com/sql/docs/sqlserver/intro-to-cloud-sql-disaster-recovery

• Question 28:

  You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

  A. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
  B. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
  C. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
  D. Configure the primary, standby, and read replica instances in zone A, all in the same region.
  A. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.

  ---

  Explanation/Reference:

  https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview

• Question 29:

  You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project. What should you do to configure the networks?

  A. Create a new VPC network in each project, and use VPC Network Peering to connect the two together.
  B. Create a Shared VPC that both the application VMs and Cloud SQL instances will use.
  C. Use the default networks, and leverage Cloud VPN to connect the two together.
  D. Place both the application VMs and the Cloud SQL instances in the default network of each project.
  B. Create a Shared VPC that both the application VMs and Cloud SQL instances will use.

  ---

  Explanation/Reference:

  https://groups.google.com/g/google-cloud-sql-discuss/c/M5G5_HPXytY?pli=1

• Question 30:

  You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?

  A. Use Cloud Spanner with a customer-managed encryption key (CMEK).
  B. Use Cloud Spanner with default encryption.
  C. Use Cloud SQL with a customer-managed encryption key (CMEK).
  D. Use Bigtable with default encryption.
  A. Use Cloud Spanner with a customer-managed encryption key (CMEK).

  ---

  Explanation/Reference:

  Yes default encryption comes with AES-256 but the question states that you need to control where you store the encryption keys. that can be achieved by CMEK.