Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer Exam Practice Test

Question 1

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. 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.

B. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.

C. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.

D. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.

Correct Answer: D

Question 2

You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?

A. Create a custom app profile with single-cluster routing.

B. Use the default app profile with multi-cluster routing.

C. Use the default app profile with single-cluster routing.

D. Create a custom app profile with multi-cluster routing.

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

You currently have a MySQL database running on Cloud SQL with a read replica in a different zone for non-mission critical analytics workloads. You want to enable high availability (HA) for the analytic workloads while keeping costs low. What should you do-

A. Enable HA on the current read replica.

B. Create a new HA instance in the same zone as the primary.

C. Create a new HA instance in a different region than the primary.

D. Increase the size of the read replica instance and enable HA.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?

A. Use Cloud Spanner to deploy the database.

B. Use Bigtable with clusters in multiple regions to deploy the database

C. Use Cloud SQL with a regional read replica to deploy the database.

D. Use BigQuery to deploy the database

Correct Answer: A

Question 5

Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hotspots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

A. Promote low-cardinality attributes in multi-attribute primary keys.

B. Promote high-cardinality attributes in multi-attribute primary keys.

C. Use bit-reverse sequential value as the primary key.

D. Normalize the data model.

E. Use an auto-incrementing value as the primary key.

Correct Answer: B,C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

You are implementing fine grained access (FGA) control on your Cloud SQL resources. You want to follow the principle of least privilege while maintaining centralized control for administrators.
What should you do?

A. Create labels at the project level.

B. Create labels at the organization level.

C. Create tags at the project level.

D. Create tags at the organization level.

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

You are the database specialist at BlueOrbit Logistics and you must grant access for a group of analysts who need to run queries against Cloud Spanner production databases while they must not write data, change schemas, or administer instances. Which IAM role should you assign to meet this requirement?

A. roles/spanner.databaseUser

B. roles/spanner.databaseReader

C. roles/spanner.databaseAdmin

D. roles/spanner.viewer

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 8

You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

A. Configure Cloud SQL for PostgreSQL read replicas to offload queries.

B. Configure Firestore, and modify your application to offload queries.

C. Configure Bigtable, and modify your application to offload queries.

D. Configure Memorystore, and modify your application to offload queries.

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 9

Your IoT monitoring platform ingests sensor data from 100,000 devices, generating 2 million writes per second during peak hours and 500,000 writes per second during off-peak hours. Each record is 1KB with a row key format: deviceId#timestamp. Your current 12-node Bigtable cluster experiences hotspotting on specific device ranges, with three nodes handling majority ofthe traffic while others remain underutilized. Read queries typically access the last 24 hours of data for specific devices. Storage costs are becoming a concern as you retain two years of historical data (500TB total). You need to optimize performance, eliminate hotspotting, and reduce storage costs while maintaining read latency under 10ms. What should you do-

A. Increase cluster size to 20 nodes, implement row key salting with hash prefix, and enable compression on all column families.

B. Split the table by device type, use separate Bigtable instances for different geographic regions, and implement read replicas for query optimization.

C. Implement row key sting wth hash prefix, configure automsted sealing with an optimal min max threshold setting, and migrate data older than 6 months to Cloud Storage.

D. Change the row key format to deviceId#timestamp, implement automated scaling with an optimal min max threshold setting based on CPU utilization, and migrate data older than 6 months to Cloud Storage

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 10

Your retail company is currently using DynamoDB to store product catalog data. Due to increasing data volumes and the need for better scalability, cost efficiency, and AI features; you have decided to migrate your data to Bigtable. You want a cost-effective migration, with minimal downtime and minimal effort, while ensuring data consistency between the two databases. What should you do-

A. Export the DynamoDB data to CSV files, upload them to Cloud Storage, and use the cbtCLI to import the data into Bigtable.

B. Use Dataproc to export the data from DynamoDB and load it into Bigtable.

C. Create a Dataflow pipeline using the DynamoDBIO and BigtableIO connectors to stream data from DynamoDB to Bigtable in near real time.

D. Develop a custom script using the DynamoDB and Bigtable APIs to directly transfer data between the two databases.

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer Exam Practice Test

Latest Update

Useful Links

Contact Us