Google Cloud Certified - Professional Cloud Database Engineer (Professional-Cloud-Database-Engineer) Free Practice Test

Question 1

You run a toy sales ecommerce application on Spanner. The application contains details about the various product listings such as name, category, description, and review(s). Your leadership wants to enable customers to ask free-form questions about the product catalog. You want to implement this functionality in the easiest, quickest, and least expensive way possible.
What should you do?

A. Register an existing Generative AI Vertex model in Spanner. Use the ML.PREDICTfunction to supply the model with a user query along with the product information in a SQL query. Return the response back to the application.

B. Generate vector embeddings for product information in Spanner. Find the vector with the smallest distance between the users' query and existing product information or review by using the EUCLIDEAN_DISTANCE()function in Spanner. Return the closest product information or review.

C. Create a Spanner full-text search index. Find the product information or review against the user's question in a SQL query. Return the response back to the application.

D. Create, train and deploy a custom ML model(s). Fetch toy details from Spanner and invoke ML predictions from the application layer to return the response.

Correct Answer: A

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

Question 2

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

A. Migrate the databases to Cloud Spanner.

B. Migrate the databases to Bare Metal Solution for Oracle.

C. Migrate the databases to Cloud SQL, and enable a standby database.

D. Migrate the databases to Compute Engine using regional persistent disks.

Correct Answer: B

Question 3

Your company is developing a 24/7, global, real-time analytics platform that needs to store and process large amounts of versioned time-series data. You need to design a platform that is highly scalable to accommodate traffic spikes and ensure high availability for mission-critical operations.
What should you do-

A. Implement AlloyDB for PostgreSQL to handle the analytical workload using read replica.

B. Implement a single-cluster Bigtable instance with autoscaling enabled and row key design.

C. Implement a multi-cluster Bigtable instance with autoscaling enabled and optimal schema design.

D. Implement a multi-cluster Bigtable instance across multiple regions with replication.

Correct Answer: D

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

Question 4

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.

Correct Answer: C

Question 5

You are running a Cloud SQL for PostgreSQL 13 Enterprise Edition instance. During an audit, you discovered that the write-ahead logs used for point-in-time recovery (PITR) are stored on disk. You need to store PITR logs in a Cloud Storage bucket going forward. How should you do this without compromising recoverability or losing the current PITR logs-

A. Clone the instance. Create a new instance with PITR retention set to 30 days.

B. Disable PITR, then enable PITR.

C. Upgrade to Enterprise Plus Edition.

D. Change the transaction logs (WAL) retention period.

Correct Answer: C

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

Question 6

You are migrating an on-premises database to Spanner. There are a few tables, each with a few hundred records that do not have a primary key on the source database. You need to migrate all of the tables over to the news database while avoiding hot-spotting issues. What should you do-

A. Use the GENERATE_UUID()function to generate universally unique identifier (UUID) values with the STRING(36)data type when you do the migration.

B. Load the data into Spanner, and designate a primary key later based on business need.

C. Migrate the tables with no primary key to maintain consistency with source.

D. During the migration, swap the order of keys so that the column that contains the monotonically increasing or decreasing value is the first key par.

Correct Answer: A

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

Question 7

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. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.

B. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.

C. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.

D. Set your production instance's maintenance window to non-business hours.

Correct Answer: D

Question 8

Your company is launching a new globally distributed application with strict requirements for low latency, strong consistency, zero downtime, and high availability (HA). You need to configure a scalable database solution to support anticipated rapid growth and optimal application performance. What should you do-

A. Create a Cloud SQL instance in HA mode with a cross-region read replica.

B. Create an AlloyDB instance in HA mode with a cross-region read replica.

C. Implement Bigtable with replication across multiple regions and configure to prioritize data accuracy.

D. Create a Spanner instance across regions for optimal performance.

Correct Answer: D

Question 9

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

C. roles/spanner.viewer

D. roles/spanner.databaseReader

Correct Answer: D

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

Question 10

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over.
What should you do? (Choose two.)

A. Use replication from an external server to migrate the databases to Cloud SQL.

B. Use an external read replica to migrate the databases to Cloud SQL.

C. Use a cross-region read replica to migrate the databases to Cloud SQL.

D. Use Database Migration Service to migrate the databases to Cloud SQL.

E. Use a read replica to migrate the databases to Cloud SQL.

Correct Answer: A,D

Question 11

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance.
During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

A. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.

B. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).

C. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.

D. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.

Correct Answer: D

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

Welcome to TestSimulate

Google Cloud Certified - Professional Cloud Database Engineer (Professional-Cloud-Database-Engineer) Free Practice Test