Most Recent Google Professional-Cloud-Database-Engineer Exam Questions & Answers

Prepare for the Google Professional Cloud Database Engineer exam with our extensive collection of questions and answers. These practice Q&A are updated according to the latest syllabus, providing you with the tools needed to review and test your knowledge.

QA4Exam focus on the latest syllabus and exam objectives, our practice Q&A are designed to help you identify key topics and solidify your understanding. By focusing on the core curriculum, These Questions & Answers helps you cover all the essential topics, ensuring you're well-prepared for every section of the exam. Each question comes with a detailed explanation, offering valuable insights and helping you to learn from your mistakes. Whether you're looking to assess your progress or dive deeper into complex topics, our updated Q&A will provide the support you need to confidently approach the Google Professional-Cloud-Database-Engineer exam and achieve success.

The questions for Professional-Cloud-Database-Engineer were last updated on Jan 19, 2025.

Viewing page 1 out of 26 pages.
Viewing questions 1-5 out of 132 questions

Get All 132 Questions & Answers

Question No. 1

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?

AUse Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.

BUse PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.

CUse HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.

DUse the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.

Show Answer

Correct Answer: B

https://severalnines.com/blog/how-achieve-postgresql-high-availability-pgbouncer/

https://cloud.google.com/blog/products/databases/using-haproxy-to-scale-read-only-workloads-on-cloud-sql-for-postgresql

This answer is correct because PgBouncer is a lightweight connection pooler for PostgreSQL that can help you distribute read requests between the Cloud SQL primary and read replica instances1.PgBouncer can also improve performance and scalability by reducing the overhead of creating new connections and reusing existing ones1.You can install PgBouncer on a Compute Engine instance and configure it to connect to the Cloud SQL instances using private IP addresses or the Cloud SQL Auth proxy2.

Question No. 2

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?

AIncrease the number of processing units.

BModify the database schema, and add additional indexes.

CShard data required by the application into multiple instances.

DDecrease the number of processing units.

Show Answer

Correct Answer: A

In case of high CPU utilization like, mentioned in question, refer: https://cloud.google.com/spanner/docs/identify-latency-point#:~:text=Check%20the%20CPU%20utilization%20of%20the%20instance.%20If%20the%20CPU%20utilization%20of%20the%20instance%20is%20above%20the%20recommended%20level%2C%20you%20should%20manually%20add%20more%20nodes%2C%20or%20set%20up%20auto%20scaling. 'Check the CPU utilization of the instance. If the CPU utilization of the instance is above the recommended level, you should manually add more nodes, or set up auto scaling.' Indexes and schema are reviewed post identifying query with slow performance. Refer : https://cloud.google.com/spanner/docs/troubleshooting-performance-regressions#review-schema

Question No. 3

You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?

AShut down and restart each application.

BWrite a utility to scan database query logs.

CWrite a utility to scan application logs.

DUse query tags to add application-centric database monitoring.

Show Answer

Correct Answer: D

https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags

Question No. 4

You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:

Can read tables, views, and DDL

Can write rows to the tables

Can add columns and indexes

Cannot drop the database

What should you do?

AAssign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.

BAssign the Cloud Spanner Database Admin role.

CAssign the Cloud Spanner Database User role.

DAssign the Cloud Spanner Admin role.

Show Answer

Correct Answer: C

https://cloud.google.com/spanner/docs/iam#spanner.databaseUser

Question No. 5

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

ADeploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.

BDeploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.

CDeploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.

DDeploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.

Show Answer

Correct Answer: A

https://cloud.google.com/sql/docs/mysql/quotas#table_limit

Unlock All Questions for Google Professional-Cloud-Database-Engineer Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 132 Questions & Answers