Free Professional-Cloud-Database-Engineer Braindumps Download Updated on Jan 25, 2026 with 144 Questions
Google Professional-Cloud-Database-Engineer Exam Practice Test Questions
NEW QUESTION # 41
You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?
- A. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
- B. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
- C. Use linear scaling to implement the Autoscaler-based architecture
- D. Use direct scaling to implement the Autoscaler-based architecture.
Answer: B
NEW QUESTION # 42
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
- A. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
- B. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
- C. Set up all read replicas in the same region as the primary instance with synchronous replication.
- D. Set up all read replicas in a different region using asynchronous replication.
Answer: B
Explanation:
This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1. This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1.
This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2. This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.
NEW QUESTION # 43
Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?
- A. Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
- B. Create an external replica, and use Cloud SQL to synchronize the data to the replica.
- C. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
- D. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
Answer: D
NEW QUESTION # 44
You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?
- A. Migrate to Google Kubernetes Engine (GKE)
- B. Migrate to Google Cloud VMware Engine
- C. Migrate to Compute Engine.
- D. Migrate to Bare Metal Solution for Oracle.
Answer: D
Explanation:
Oracle is neither licensed nor supported in GCE. The only platform which supports RAC and all existing Oracle features is BMS.
NEW QUESTION # 45
You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?
- A. Ensure that the service account has the Storage Admin role.
- B. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- C. Increase the amount of memory allocated to your instance.
- D. Close idle connections or restart the instance before beginning the import operation.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#troubleshooting
NEW QUESTION # 46
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)
- A. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
- B. Create additional read replicas, and partition your analytics users to use different read replicas.
- C. Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.
- D. Create secondary indexes on the replica.
- E. Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.
Answer: A,B
NEW QUESTION # 47
You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest data.
You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?
- A. Use a Cloud SQL federated query for the Sales Reporting application.
- B. Create two separate databases in the instance, and perform dual writes from the Order Management application.
- C. Create a read replica for the Sales Reporting application.
- D. Queue up all the requested reports in PubSub, and execute the reports at night.
Answer: C
NEW QUESTION # 48
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?
- A. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
- B. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
- C. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
- D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
Answer: C
NEW QUESTION # 49
You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?
- A. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
- B. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
- C. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
- D. Configure the primary, standby, and read replica instances in zone A, all in the same region.
Answer: C
NEW QUESTION # 50
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 SQL with cross-region replicas.
- B. Use Cloud Spanner in a regional configuration.
- C. Use high availability (HA) Cloud SQL with multiple zones.
- D. Use zonal Cloud SQL without high availability (HA).
Answer: A
NEW QUESTION # 51
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
- A. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
- B. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
- C. Move the physical database servers from on-premises to Google Cloud.
- D. Use a change data capture (CDC) migration strategy.
- E. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
Answer: D,E
Explanation:
https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer
NEW QUESTION # 52
Your organization has a ticketing system that needs an online marketing analytics and reporting application.
You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?
- A. BigQuery
- B. Cloud SQL
- C. Bigtable
- D. Cloud Spanner
Answer: A
NEW QUESTION # 53
You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?
- A. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
- B. Use Firestore, and rely on automatic serverless scaling.
- C. Use Bigtable, and add nodes as necessary to achieve the required throughput.
- D. Use Cloud SQL with read replicas for throughput.
Answer: C
Explanation:
https://cloud.google.com/memorystore/docs/redis/redis-overview
NEW QUESTION # 54
You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?
- A. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
- B. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
- C. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
- D. Configure the primary, standby, and read replica instances in zone A, all in the same region.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview
NEW QUESTION # 55
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. Turn on automated backup, and turn off transaction log retention.
- B. Turn on automated backup, and turn on transaction log retention.
- C. Take one manual backup per day, and turn off transaction log retention.
- D. Take no backups, and turn off transaction log retention.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
NEW QUESTION # 56
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?
- A. Isolate the data analysts and operations user groups to use different Bigtable instances.
- B. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
- C. Add more nodes to the Bigtable cluster.
- D. Use Key Visualizer for Bigtable.
Answer: D
Explanation:
https://cloud.google.com/bigtable/docs/performance#troubleshooting
NEW QUESTION # 57
Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?
- A. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
- B. Edit the instance to change the storage type from HDD to SSD.
- C. Create a read replica of the instance with SSDs, and perform a failover to the new instance
- D. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
Answer: A
Explanation:
https://stackoverflow.com/questions/72034607/can-i-change-storage-type-from-hdd-to-ssd-on-cloud-sql-after-creating-an-instanc
NEW QUESTION # 58
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
- A. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
- B. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
- C. Move the physical database servers from on-premises to Google Cloud.
- D. Use a change data capture (CDC) migration strategy.
- E. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
Answer: D,E
NEW QUESTION # 59
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
- A. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
- B. Create a clone database from a read replica database, and restore the clone in the same region.
- C. Create a clone database from a read replica database, and restore the clone into a different zone.
- D. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
Answer: D
NEW QUESTION # 60
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?
- A. Use Cloud SQL.
- B. Use Firestore.
- C. Use Cloud Spanner.
- D. Use Bigtable.
Answer: C
NEW QUESTION # 61
......
Updated Verified Professional-Cloud-Database-Engineer dumps Q&As - Pass Guarantee or Full Refund: https://pass4sure.testvalid.com/Professional-Cloud-Database-Engineer-valid-exam-test.html