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

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

• Question 71:

  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?

  A. 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.
  B. 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.
  C. Pause the on-premises applications. Use the mysqldump utility to dump the database content in compressed format. Run gsutil
  D. Pause the on-premises applications. Use the mysqldump utility to dump the database content in CSV format. Run gsutil
  A. 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.

  ---

  Explanation/Reference:

  https://cloud.google.com/database-migration/docs/mysql/configure-source- database

  To migrate the database while preserving transactions and minimizing downtime, you should use Database Migration Service. This service will allow you to migrate the database in a way that is transparent to your users and applications. It will also allow you to test the migration before you make it live, so that you can be sure that everything will work as expected.

• Question 72:

  Your team is building an application that stores and analyzes streaming time series financial data. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?

  A. Use Firestore.
  B. Use Bigtable
  C. Use BigQuery.
  D. Use Cloud Spanner.
  B. Use Bigtable

  ---

  Explanation/Reference:

  Financial data, such as transaction histories, stock prices, and currency exchange rates. https://cloud.google.com/bigtable/docs/overview#what-its-good-for

  With SSD: Reads -up to 10,000 rows per second Writes -up to 10,000 rows per second Scans -up to 220 MB/s https://cloud.google.com/bigtable/docs/performance#typical-workloads

• Question 73:

  Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this data. What should you do?

  A. Use Identity and Access Management (IAM) for Bigtable access control.
  B. Use VPC Service Controls to create a trusted network for the Bigtable service.
  C. Use customer-managed encryption keys (CMEK).
  D. Use Google Cloud Armor to add IP addresses to an allowlist.
  B. Use VPC Service Controls to create a trusted network for the Bigtable service.

  ---

  Explanation/Reference:

  "Users can define a security perimeter around Google Cloud resources such as Cloud Storage buckets, Bigtable instances, and BigQuery datasets to constrain data within a VPC and control the flow of data." https://cloud.google.com/vpcservice-controls

• Question 74:

  You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?

  A. Set your production instance's maintenance window to non-business hours.
  B. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
  C. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
  D. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
  A. Set your production instance's maintenance window to non-business hours.

• Question 75:

  You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?

  A. Maintain a target of 23% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone europe-west1-d cluster-c in zone asia-east1-b
  B. Maintain a target of 23% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone us-central1-b cluster-c in zone us-east1-a
  C. Maintain a target of 35% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone australia-southeast1-a cluster-c in zone europe-west1-d cluster-d in zone asia-east1-b
  D. Maintain a target of 35% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone us-central2-a cluster-c in zone asia-northeast1-b cluster-d in zone asia-east1-b
  D. Maintain a target of 35% CPU utilization by locating: cluster-a in zone us-central1-a cluster-b in zone us-central2-a cluster-c in zone asia-northeast1-b cluster-d in zone asia-east1-b

  ---

  Explanation/Reference:

  https://cloud.google.com/bigtable/docs/replication-settings#regional-failover

• Question 76:

  Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?

  A. Recommend solid-state drives (SSD).
  B. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
  C. Recommend hard disk drives (HDD).
  D. Recommend mixed storage types.
  A. Recommend solid-state drives (SSD).

  ---

  Explanation/Reference:

  if you plan to store extensive historical data for a large number of remote-sensing devices and then use the data to generate daily reports, the cost savings for HDD storage might justify the performance tradeoff. On the other hand, if you plan to use the data to display a real-time dashboard, it probably would not make sense to use HDD storage--reads would be much more frequent in this case, and reads that are not scans are much slower with HDD storage.

• Question 77:

  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.
  D. Enable high availability (HA) for the database to make it regional.

• Question 78:

  You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?

  A. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
  B. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
  C. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
  D. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
  C. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.

  ---

  Explanation/Reference:

  The Cloud SQL connectors are libraries that provide encryption and IAM-based authorization when connecting to a Cloud SQL instance. They can't provide a network path to a Cloud SQL instance if one is not already present. Other ways to connect to a Cloud SQL instance include using a database client or the Cloud SQL Auth proxy. https://cloud.google.com/sql/docs/postgres/connect-connectors https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory/blob/main/ docs/jdbc-postgres.md

• Question 79:

  Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?

  A. Enable serializable isolation in the Firebase app.
  B. Deploy a US multi-region Firestore location.
  C. Build a Firestore bundle, and deploy bundles to Cloud CDN.
  D. Create a Firestore index on the news story date.
  C. Build a Firestore bundle, and deploy bundles to Cloud CDN.

  ---

  Explanation/Reference:

  A global audience strongly suggests serving content via Google's Content Delivery Network. Changing the isolation level won't decrease cost or latency

• Question 80:

  You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?

  A. Setup a static external IP address in your VPC network.
  B. Set up bring your own IP (BYOIP) in your VPC.
  C. Set up a Cloud NAT gateway on the Compute Engine VM.
  D. Set up Cloud NAT service.
  C. Set up a Cloud NAT gateway on the Compute Engine VM.

  ---

  Explanation/Reference:

  https://cloud.google.com/bare-metal/docs/bms-setup?hl=en#bms-access-internet-vm-nat

  The docs specifically says "Setting up a NAT gateway on a Compute Engine VM" is the way to give BMS internet access.