The latest Google Professional Cloud Database Engineer certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Google Professional Cloud Database Engineer exam and earn Google Professional Cloud Database Engineer certification.
Table of Contents
- Question 11
- Exam Question
- Correct Answer
- Question 12
- Exam Question
- Correct Answer
- Question 13
- Exam Question
- Correct Answer
- Question 14
- Exam Question
- Correct Answer
- Question 15
- Exam Question
- Correct Answer
- Question 16
- Exam Question
- Correct Answer
- Question 17
- Exam Question
- Correct Answer
- Question 18
- Exam Question
- Correct Answer
- Question 19
- Exam Question
- Correct Answer
- Question 20
- Exam Question
- Correct Answer
Question 11
Exam Question
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.
Correct Answer
C. Use Cloud Audit Logs to verify the status.
Question 12
Exam Question
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.
Correct Answer
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.
Question 13
Exam Question
You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner.
A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?
A. Increase the number of processing units.
B. Modify the database schema, and add additional indexes.
C. Shard data required by the application into multiple instances.
D. Decrease the number of processing units.
Correct Answer
A. Increase the number of processing units.
Question 14
Exam Question
You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?
A. Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
B. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
C. Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
D. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
Correct Answer
B. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
Question 15
Exam Question
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.
Correct Answer
B. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
Question 16
Exam Question
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?
A. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
B. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
C. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
D. Create a CSV file by running the SQL statement SELECT…INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
Correct Answer
C. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
Question 17
Exam Question
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.
Correct Answer
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.
Question 18
Exam Question
Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?
A. Use Cloud Spanner instead of Cloud SQL.
B. Increase the number of CPUs for your instance.
C. Increase the storage size for the instance.
D. Use many smaller Cloud SQL instances.
Correct Answer
A. Use Cloud Spanner instead of Cloud SQL.
Question 19
Exam Question
You are building an Android game that needs to store data on a Google Cloud serverless database.
The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?
A. Use Firestore.
B. Use Cloud SQL with an external (public) IP address.
C. Use an in-app embedded database.
D. Use Cloud Spanner.
Correct Answer
B. Use Cloud SQL with an external (public) IP address.
Question 20
Exam Question
Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?
A. Use Firestore with Looker.
B. Use Cloud Spanner with Data Studio.
C. Use MongoD8 Atlas with Charts.
D. Use Bigtable with Looker.
Correct Answer
C. Use MongoD8 Atlas with Charts.