Download Professional Cloud Database Engineer.Professional-Cloud-Database-Engineer.ExamTopics.2026-04-09.174q.tqb
| Vendor: | |
| Exam Code: | Professional-Cloud-Database-Engineer |
| Exam Name: | Professional Cloud Database Engineer |
| Date: | Apr 09, 2026 |
| File Size: | 726 KB |
How to open TQB files?
Files with TQB (Taurus Question Bank) extension can be opened by Taurus Exam Studio.
Purchase
Coupon: TAURUSSIM_20OFF
Discount: 20%
Demo Questions
Question 1
Your company has implemented a multi-regional, highly available (HA) PostgreSQL database cluster on Google Cloud by using Cloud SQL and regional persistent disks. You need to assess the effectiveness of your disaster recovery plan and validate the system's ability to recover from a regional outage. What should you do?
- Promote the cross-region replica and verify that the application can still access the database.
- Initiate a failover test to the HA standby instance and verify that the application can still access the database.
- Create a backup of the database and restore it to a new Cloud SQL instance in a different region to test the backup and restore process.
- Conduct a chaos engineering experiment by randomly terminating virtual machines in the primary region and observing the system's behavior.
Correct answer: A
Question 2
Your organization runs a high-volume, low-latency application on Bigtable. You need to reduce costs without compromising performance. What should you do?
- Reduce replication factor across clusters.
- Consolidate multiple small clusters into a single large cluster.
- Analyze application access patterns to strategically redesign the schema and adjust the node count.
- Switch to a lower-performance storage type for all clusters.
Correct answer: C
Question 3
You have a Cloud SQL for MySQL Enterprise instance with four read replicas. Your next scheduled maintenance event is scheduled tomorrow at 6 PM. Your security team identifies an important security vulnerability. You are notified by your management at 8 PM today to update your primary instance and all four read replicas during approved business downtime today at 11 PM. What should you do?
- Reschedule the upcoming scheduled maintenance to happen today at 11 PM.
- Perform self-service maintenance on the selected read replicas.
- Perform self-service maintenance on the primary instance during scheduled business downtime.
- Reschedule the upcoming scheduled maintenance of the primary instance to apply updates immediately.
Correct answer: C
Question 4
You are developing a Python application that will connect to AlloyDB for PostgreSQL as the backend datastore. Your organization’s security requirements do not allow the use of usernames and passwords for database authentication. How should you develop your application?
- Use any PostgreSQL-compatible Python client. Connect to the AlloyDB cluster by using Identity-Aware Proxy (IAP).
- Use the AlloyDB Python connector. Use automated IAM authentication for connectivity.
- Use the AlloyDB Python connector. Enforce SSL connectivity to AlloyDB by using the gcloud alloydb instance update command with the --ssl-mode=ENCRYPTED_ONLY option.
- Use any PostgreSQL-compatible Python client. Use a service account name and credential as the username and password respectively during connection.
Correct answer: B
Question 5
Your company’s rapidly growing ecommerce application uses Cloud SQL for MySQL. Performance issues are surfacing during peak traffic periods. You need to ensure that the database can handle the load while minimizing downtime. What should you do?
- Use read replicas for query offloading, configure automatic failover, and test failover procedures regularly.
- Vertically scale the primary instance by significantly increasing compute resources, such as vCPUs and memory.
- Increase storage size on the existing instance and implement client-side caching for frequently accessed data.
- Migrate to a Cloud SQL for PostgreSQL database for better performance during high load.
Correct answer: A
Question 6
You are a DBA at a retail company. The production databases are running in Cloud SQL for MySQL Enterprise Plus edition, version 8.0.34, in the us-centrall region. You need to set up and test disaster recovery (DR) with zero data loss in the us-west1 region. What should you do?
- Use advanced DR by setting up a cascading read replica in the us-west1 region, and designate it as the failover DR replica. Test switchover by using the gcloud switchover command.
- Create a cross-region read replica, version 8.0.37, in the us-west1 region. Designate it as the failover DR replica, and test switchover by using the gcloud switchover command.
- Create a cross-region read replica version 8.0.34, in the us-west1 region. Designate it as the failover DR replica, and test switchover by using the gcloud switchover command.
- Create a cross-region read replica, version 8.0.34, in the us-west1 region. Test switchover by using the gcloud promote-replica with failover command.
Correct answer: C
Question 7
Your organization deploys a high-volume, low-latency sensor data ingestion system. Resilience is crucial, and the workload is expected to grow significantly over time. You need to design a database tier on Google Cloud to ensure faster performance and high availability, while following Google-recommended practices. What should you do?
- Deploy multiple Bigtable clusters, shard data manually across them, and set up the application logic for fault tolerance.
- Deploy a single-zone Bigtable cluster and optimize the application code for maximum write throughput.
- Deploy a single-region Bigtable instance and increase the nodes to maximize data durability.
- Provision a multi-zone Bigtable cluster, configure replication, perform an application stress-test, and set up performance monitoring.
Correct answer: D
Question 8
You want to migrate an on-premises MySQL database to Cloud SQL. The on-premises database currently has 16 cores and 64 GB of RAM and averages 75% CPU utilization to support an application with over 100.000 tables. You need to specify the most cost-effective machine size you need when migrating to Cloud SQL for MySQL. What should you do?
- Select a Cloud SQL for MySQL database with a machine configuration of 12 cores and 48 GB of RAM.
- Select a Cloud SQL for MySQL database with a machine configuration of 16 cores and 64 GB of RAM.
- Select a Cloud SQL for MySQL database with a machine configuration of 32 cores and 256 GB of RAM.
- Select a Cloud SQL for MySQL database with a machine configuration of 64 cores and 768 GB of RAM.
Correct answer: B
Question 9
You are migrating your on-premises PostgreSQL database to Spanner. You need to identify a solution for handling existing integer-based table primary keys. You want minimal changes to the applications while also following Google-recommended practices. What should you do?
- Use application generated sequential integer values as primary keys.
- Update default primary key values to max(primary_key) + 1.
- Use a UUID function that generates UUID Version 4 values as primary keys.
- Generate values by using BIT_REVERSED_POSITIVE sequences.
Correct answer: D
Question 10
Your company is rapidly expanding its user base across North America, nearly doubling in the last 6 months. This expansion causes a substantial increase in query volume on your mission-critical Cloud SQL database. This has led to noticeable performance issues and slower query response times. You suspect that your Cloud SQL instance may not be able to handle the incremental load. You need to identify the root cause of this performance bottleneck and ensure that your database can scale with your growing user base. What should you do?
- Migrate the database to Spanner.
- Evaluate the application connection pooling configuration settings.
- Review Cloud SQL System Insights for the instance, and analyze CPU, memory, and storage utilization metrics.
- Create two Cloud SQL instances, and split the workload between them.
Correct answer: C
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX FILES
Use ProfExam Simulator to open VCEX files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!