Free Access Google.Professional-Cloud-Database-Engineer.v2024-04-26.q86 Practice Test (Page 10)

Question 41

You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?

A.Automate instance creation by setting up Terraform scripts.

B.Create clones from a template Cloud SQL instance.

C.Automate instance creation by writing a Dataflow job.

D.Create the instances using the Google Cloud Console UI.

Question 42

You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

A.Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

B.Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.

C.Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

D.Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences

Question 43

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

A.Take no backups, and turn off transaction log retention.

B.Take one manual backup per day, and turn off transaction log retention.

C.Turn on automated backup, and turn off transaction log retention.

D.Turn on automated backup, and turn on transaction log retention.

Question 44

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

A.Use Cloud Spanner in a regional configuration.

B.Use high availability (HA) Cloud SQL with multiple zones.

C.Use Cloud SQL with cross-region replicas.

D.Use zonal Cloud SQL without high availability (HA).

Question 45

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

Latest Upload: 200PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 290Nokia.4A0-113.v2026-05-01.q69; 246EC-COUNCIL.312-49v11.v2026-04-30.q214; 226Microsoft.MB-820.v2026-04-30.q101; 204Salesforce.MC-202.v2026-04-30.q57; 203BICSI.INSTC_V8.v2026-04-29.q53; 332NMLS.MLO.v2026-04-28.q82; 241NCARB.Project-Management.v2026-04-28.q27; 454EMC.D-AV-DY-23.v2026-04-27.q184; 1107ServiceNow.CSA.v2026-04-27.q483

Question 41

Question 42

Question 43

Question 44

Question 45

Download PDF File