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

Question 16

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

A.Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.

B.Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.

C.Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.

D.Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.

Question 17

Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?

A.Use Cloud SQL for data storage.

B.Use Cloud Spanner for data storage.

C.Use Memorystore for data storage.

D.Use Bigtable for data storage.

Question 18

You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?

A.Set up different organizations for each database type, and apply policy constraints at the organization level.

B.Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.

C.Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.

D.Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

Question 19

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.

Question 20

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA.
You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

A.Use granular instance sizing in Cloud Spanner and Autoscaler.

B.Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

C.Use interleaving to co-locate parent and child rows.

D.Manually scale down the number of nodes after the peak period has passed.

Other Version: 335Google.Professional-Cloud-Database-Engineer.v2026-06-22.q177

Latest Upload: 173NAHQ.CPHQ.v2026-09-03.q481; 113SAP.C-S4CPB-2602.v2026-09-02.q7; 109Cisco.700-805.v2026-09-02.q86; 161MSSC.CLT-4.0.v2026-09-02.q43; 126Fitness.NCSF-CPT.v2026-09-02.q18; 174Google.Generative-AI-Leader.v2026-09-02.q77; 139PECB.ISO-14001-Lead-Auditor.v2026-09-01.q39; 126Google.GCP-DE.v2026-09-01.q27; 160Cisco.300-820.v2026-09-01.q105; 154Cisco.500-220.v2026-09-01.q72

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File