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

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

• Question 121:

  Your organization is running a critical production database on a virtual machine (VM) on Compute Engine. The VM has an ext4-formatted persistent disk for data files. The database will soon run out of storage space. You need to implement a solution that avoids downtime. What should you do?

  A. In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.
  B. In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use
  C. In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.
  D. In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.
  A. In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.

  ---

  Explanation/Reference:

  https://cloud.google.com/compute/docs/disks/resize-persistent-disk#resize_partitions

• Question 122:

  Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?

  A. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
  B. Migrate applications and Oracle databases to Compute Engine.
  C. Migrate applications to Cloud SQL.
  D. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
  A. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).

  ---

  Explanation/Reference:

  https://cloud.google.com/blog/products/databases/migrate-databases-to-google-cloud-vmware-engine-gcve

• Question 123:

  You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?

  A. Use log messages produced by Cloud SQL.
  B. Use Query Insights for Cloud SQL.
  C. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
  D. Use Cloud SQL instance monitoring in the Google Cloud Console.
  B. Use Query Insights for Cloud SQL.

  ---

  Explanation/Reference:

  https://cloud.google.com/sql/docs/mysql/using-query-insights#introduction

• Question 124:

  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 unplanned outage. What should you do?

  A. Create one regional Cloud SQL instance with a read replica in another region.
  B. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
  C. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
  D. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
  B. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

  ---

  Explanation/Reference:

  This answer is correct because it meets the requirements of having an optimal and highly available environment with automatic failover. According to the Google Cloud documentation1, a regional Cloud SQL instance is an instance that has a primary server in one zone and a standby server in another zone within the same region. The primary and standby servers are kept in sync using synchronous replication, which ensures zero data loss and minimal downtime in case of a zonal outage or an instance failure. If the primary server becomes unavailable, Cloud SQL automatically fails over to the standby server, which becomes the new primary server1.

• Question 125:

  You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

  A. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
  B. Create your database with one primary node and one read replica in the region.
  C. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
  D. Configure your Cloud SQL instance with high availability enabled.
  A. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.

  ---

  Explanation/Reference:

  Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.

• Question 126:

  You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?

  A. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
  B. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
  C. Verify that the new replica is created automatically.
  D. Start the original primary instance and resume replication.
  C. Verify that the new replica is created automatically.

  ---

  Explanation/Reference:

  Recovery Process: Once Zone-B becomes available again, Cloud SQL will initiate the recovery process for the impacted read replica. The recovery process involves the following steps: 1. Synchronization: Cloud SQL will compare the data in the recovered read replica with the primary instance in Zone-A. If there is any data divergence due to the unavailability period, Cloud SQL will synchronize the read replica with the primary instance to ensure data consistency. 2. Catch-up Replication: The recovered read replica will start catching up on the changes that occurred on the primary instance during its unavailability. It will apply the necessary updates from the primary instance's binary logs (binlogs) to bring the replica up to date. 3. Resuming Read Traffic: Once the synchronization and catch-up replication processes are complete, the read replica in Zone-B will resume its normal operation. It will be able to serve read traffic and stay updated with subsequent changes from the primary instance.

• Question 127:

  Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?

  A. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
  B. Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.
  C. Use Memorystore to handle your low-latency requirements and for real-time analytics.
  D. Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.
  A. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.

  ---

  Explanation/Reference:

  Start with the lowest tier and smallest size and then grow your instance as needed. Memorystore provides automated scaling using APIs, and optimized node placement across zones for redundancy. Memorystore for Memcached can support clusters as large as 5 TB, enabling millions of QPS at very low latency

• Question 128:

  You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?

  A. Disable and remove the internal IP address assignment.
  B. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
  C. Specify an authorized network with the CIDR range of the VM.
  D. Disable and remove the external IP address assignment.
  D. Disable and remove the external IP address assignment.

  ---

  Explanation/Reference:

  It is always more secure to use an internal IP, so removing them doesn't make sense. Eliminate A. You can use Private Google Access when VM instances only have internal IP addresses, so disabling the internal IPs and use Private Google Access doesn't make sense. Eliminate B. Specifying an authorized network when they're on the same subnet doesn't make sense. Eliminate C. A way to improve network security would be to disable external IPs since they're not needed.

• Question 129:

  Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?

  A. Use Query Insights to identify idle instances.
  B. Remove inactive user accounts.
  C. Run the Recommender API to identify overprovisioned instances.
  D. Build indexes on heavily accessed tables.
  C. Run the Recommender API to identify overprovisioned instances.

  ---

  Explanation/Reference:

  The Cloud SQL overprovisioned instance recommender helps you detect instances that are unnecessarily large for a given workload. It then provides recommendations on how to resize such instances and reduce cost. This page describes how this recommender works and how to use it.

• Question 130:

  You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:

  Can read tables, views, and DDL

  Can write rows to the tables

  Can add columns and indexes

  Cannot drop the database

  What should you do?

  A. Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
  B. Assign the Cloud Spanner Database Admin role.
  C. Assign the Cloud Spanner Database User role.
  D. Assign the Cloud Spanner Admin role.
  C. Assign the Cloud Spanner Database User role.

  ---

  Explanation/Reference:

  https://cloud.google.com/spanner/docs/iam#spanner.databaseUser