Aug-2025 Get Totally Free Updates on Professional-Cloud-Database-Engineer Dumps PDF Questions
Prepare With Top Rated High-quality Professional-Cloud-Database-Engineer Dumps For Success in Professional-Cloud-Database-Engineer Exam
Earning the Google Professional-Cloud-Database-Engineer certification can help you advance your career in the field of cloud database management. Google Cloud Certified - Professional Cloud Database Engineer certification demonstrates that you have the skills and expertise required to design, develop, and maintain scalable and secure databases on the Google Cloud Platform. With this certification, you can enhance your job prospects and increase your earning potential. Additionally, you can gain recognition as a proficient database professional who can handle complex database management tasks on the cloud.
Google Professional-Cloud-Database-Engineer Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
NEW QUESTION # 18
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?
- A. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
- B. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
- C. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
- D. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
Answer: C
NEW QUESTION # 19
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. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
- B. Use linear scaling to implement the Autoscaler-based architecture
- C. Use direct scaling to implement the Autoscaler-based architecture.
- D. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
Answer: A
NEW QUESTION # 20
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted.
The test has concluded and you want to return to the pre-test configuration. What should you do?
- A. Bring DB-1 back online.
- B. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
- C. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
- D. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
Answer: B
Explanation:
If you need to have the primary instance in the zone that had the outage, you can do a failback. A failback performs the same steps as the failover, only in the opposite direction, to reroute traffic back to the original instance. To perform a failback, use the procedure in Initiating failover.https://cloud.google.com/sql/docs
/mysql/high-availability#failback
NEW QUESTION # 21
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 dat a. 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. Create two separate databases in the instance, and perform dual writes from the Order Management application.
- B. Create a read replica for the Sales Reporting application.
- C. Use a Cloud SQL federated query for the Sales Reporting application.
- D. Queue up all the requested reports in PubSub, and execute the reports at night.
Answer: C
NEW QUESTION # 22
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?
- A. For each application code, set up a common shared user account.
- B. For each application code, set up a dedicated user account.
- C. For the application server, set up a service account.
- D. For the application server, set up a common shared user account.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/sql-proxy#using-a-service-account
NEW QUESTION # 23
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?
- A. Use Database Migration Service to migrate your database.
- B. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
- C. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
- D. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
Answer: D
Explanation:
PgBouncer maintains a pool for connections for each database and user combination. PgBouncer either creates a new database connection for a client or reuses an existing connection for the same user and database.
+ PgBouncer is a simple PostgreSQLconnection pool that allows for several thousand connections at a time.
Using Kubernetes Engine to run a Helm Chart w/ PgBouncer based on the great article from futuretech- industries, we were able to set up an easily deployable system to get the most out of our CloudSQL DBs without breaking the bank.https://medium.com/google-cloud/increasing-cloud-sql-postgresql-max- connections-w-pgbouncer-kubernetes-engine-49b0b2894820#:~:text=That%20is%20where,breaking%20the%
20bank.
NEW QUESTION # 24
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 Bigtable.
- C. Use Firestore.
- D. Use Cloud Spanner.
Answer: D
NEW QUESTION # 25
You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?
- A. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
- B. Verify that the new replica is created automatically.
- C. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
- D. Start the original primary instance and resume replication.
Answer: B
Explanation:
Recovery Process: Once Zone-B becomes available again, Cloud SQL will initiate the recovery process for the impacted read replica. The recovery process involves the following steps: 1. Synchronization: Cloud SQL will compare the data in the recovered read replica with the primary instance in Zone-A. If there is any data divergence due to the unavailability period, Cloud SQL will synchronize the read replica with the primary instance to ensure data consistency. 2. Catch-up Replication: The recovered read replica will start catching up on the changes that occurred on the primary instance during its unavailability. It will apply the necessary updates from the primary instance's binary logs (binlogs) to bring the replica up to date. 3. Resuming Read Traffic: Once the synchronization and catch-up replication processes are complete, the read replica in Zone-B will resume its normal operation. It will be able to serve read traffic and stay updated with subsequent changes from the primary instance.
NEW QUESTION # 26
You want to migrate an existing on-premises application to Google Cloud. Your application supports semi- structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?
- A. Deploy the database using Cloud Spanner.
- B. Deploy the database using Cloud SQL.
- C. Deploy the database using Bigtable.
- D. Use BigQuery, and load data in batches.
Answer: D
Explanation:
Bigtable is a scalable, fully managed, and high-performance NoSQL database service that can handle semi- structured data and support real-time monitoring and analysis. Cloud SQL is a relational database service that does not support semi-structured data. BigQuery is a data warehouse service that is optimized for batch processing and analytics, not real-time monitoring. Cloud Spanner is a relational database service that supports semi-structured data with JSON data type, but it is more expensive and complex than Bigtable for this use case.
NEW QUESTION # 27
You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?
- A. Place the bulk of the read and write workloads closer to the default leader region.
- B. Keep the total CPU utilization under 45% in each region.
- C. Add more read-write replicas.
- D. Use staleness of at least 15 seconds.
Answer: C
NEW QUESTION # 28
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?
- A. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance.
Check the replication status usingpg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance. - B. Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .
- C. Restore the Cloud SQL instance from the automatic backups in region 3.
- D. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery
NEW QUESTION # 29
Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?
- A. Create migration job using Database Migration Service.
Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode.
Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete.
Update your application connections to the new instance. - B. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL.
Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination.
Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance. - C. Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window.
Move the files to Cloud Storage, and import each database into your Cloud SQL instance.
Continue to dump each database until all the databases are migrated.
Update your application connections to the new instance. - D. Create migration job using Database Migration Service.
Set the migration job type to One-time, and perform this migration during a maintenance window.
Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database.
Update your application connections to the new instance.
Answer: A
Explanation:
https://cloud.google.com/datastream/docs/overview.
NEW QUESTION # 30
You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?
- A. Use Cloud SQL instance monitoring.
- B. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- C. Use Cloud SQL logs.
- D. Use the SQL Server Always On Availability Group dashboard.
Answer: D
Explanation:
Note, you cannot create a read replica in Cloud SQL for SQL Server unless you use an Enterprise Edition. Which is also a requirement for configuring SQL Server AG. That's not a coincidence. That's how Cloud SQL for SQL Server creates SQL Server read replicas. To find out about the replication, use the AG Dashboard in SSMS. https://cloud.google.com/sql/docs/sqlserver/replication/manage-replicas#promote-replica
NEW QUESTION # 31
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?
- A. Create the database with customer-managed encryption keys.
- B. Create the database persistent disk with Google-managed encryption keys.
- C. Create the database persistent disk with customer-managed encryption keys.
- D. Create the database with Google-managed encryption keys.
Answer: C
NEW QUESTION # 32
You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?
- A. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- B. Enable the Cloud SQL Admin API.
- C. Ensure that you are using an external (public) IP address interface.
- D. Check whether your service account has cloudsql.instances.connect permission.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#troubleshooting C because in docs it says "Make sure to enable the Cloud SQL Admin API. If it is not, you see output like Error 403: Access Not Configured in your Cloud SQL
NEW QUESTION # 33
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over.
What should you do? (Choose two.)
- A. Use replication from an external server to migrate the databases to Cloud SQL.
- B. Use a cross-region read replica to migrate the databases to Cloud SQL.
- C. Use Database Migration Service to migrate the databases to Cloud SQL.
- D. Use an external read replica to migrate the databases to Cloud SQL.
- E. Use a read replica to migrate the databases to Cloud SQL.
Answer: A,C
NEW QUESTION # 34
Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)
- A. Promote high-cardinality attributes in multi-attribute primary keys.
- B. Use an auto-incrementing value as the primary key.
- C. Promote low-cardinality attributes in multi-attribute primary keys.
- D. Normalize the data model.
- E. Use bit-reverse sequential value as the primary key.
Answer: A,E
Explanation:
https://cloud.google.com/spanner/docs/schema-design D because high cardinality means you have more unique values in the collumn. That's a good thing for a hot-spotting issue. E because Spanner specifically has this feature to reduce hot spotting. Basically, it generates unique values https://cloud.google.com/spanner/docs/schema-design#bit_reverse_primary_key D) Promote high-cardinality attributes in multi-attribute primary keys.
This is a correct answer because promoting high-cardinality attributes in multi-attribute primary keys can help avoid hotspots in Cloud Spanner. High-cardinality attributes are those that have many distinct values, such as UUIDs, email addresses, or timestamps1. By placing high-cardinality attributes first in the primary key, you can ensure that the rows are distributed more evenly across the key space, and avoid having too many requests sent to the same server2.
E) Use bit-reverse sequential value as the primary key.
This is a correct answer because using bit-reverse sequential value as the primary key can help avoid hotspots in Cloud Spanner. Bit-reverse sequential value is a technique that reverses the bits of a monotonically increasing value, such as a timestamp or an auto-incrementing ID1. By reversing the bits, you can create a pseudo-random value that spreads the writes across the key space, and avoid having all the inserts occurring at the end of the table2.
NEW QUESTION # 35
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. 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.
- B. 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
- 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 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.
Answer: A
NEW QUESTION # 36
Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?
- A. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
- B. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
- C. Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.
- D. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
Answer: A
Explanation:
Binary Logging enabled, with that you can identify the point of time the data was good and recover from that point time. https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#perform_the_point-in-time_recovery_using_binary_log_positions
NEW QUESTION # 37
Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)
- A. Promote high-cardinality attributes in multi-attribute primary keys.
- B. Use bit-reverse sequential value as the primary key.
- C. Promote low-cardinality attributes in multi-attribute primary keys.
- D. Normalize the data model.
- E. Use an auto-incrementing value as the primary key.
Answer: A,E
NEW QUESTION # 38
Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?
- A. Ask existing users to set their Google password to match their corporate password.
- B. Use workload identity federation to impersonate a service account.
- C. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
- D. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
Answer: B
Explanation:
Updating passwords represents user disruption. Eliminate B. Eliminate C for the same reason. D doesn't make sense, leaves A. From Google's documentation, "Traditionally, applications running outside Google Cloud can use service account keys to access Google Cloud resources. However, service account keys are powerful credentials, and can present a security risk if they are not managed correctly. With identity federation, you can use Identity and Access Management (IAM) to grant external identities IAM roles, including the ability to impersonate service accounts. This approach eliminates the maintenance and security burden associated with service account keys." https://cloud.google.com/iam/docs/workload-identity-federation
NEW QUESTION # 39
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?
- A. Set up bring your own IP (BYOIP) in your VPC.
- B. Set up a Cloud NAT gateway on the Compute Engine VM.
- C. Setup a static external IP address in your VPC network.
- D. Set up Cloud NAT service.
Answer: B
NEW QUESTION # 40
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 secondary indexes on the replica.
- C. Create additional read replicas, and partition your analytics users to use different read replicas.
- D. 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.
- E. 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.
Answer: C,E
Explanation:
Replication lag and slow report performance. E is eliminated because using BigQuery would mean changes to the current reports. Report slowness could be the result of poor indexing or just too much read load (or both!).
Since excessive load is mentioned in the question, creating additional read replicas and spreading the analytics workload around makes B correct and eliminates A as a way to speed up reporting. That leaves the replication problem. Cloud SQL enables single threaded replication by default, so it stands to reason enabling parallel replication would help the lag. To do that you disable replication on the replica (not the primary), set flags on the replica and optionally set flags on the primary instance to optimize performance for parallel replication.
That makes C correct and D incorrect.https://cloud.google.com/sql/docs/mysql/replication/manage- replicas#configuring-parallel-replication
NEW QUESTION # 41
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 # 42
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. Manually scale down the number of nodes after the peak period has passed.
- B. Use granular instance sizing in Cloud Spanner and Autoscaler.
- C. Use interleaving to co-locate parent and child rows.
- D. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
Answer: B
Explanation:
Granular instance is available in Public Preview. With this feature, you can run workloads on Spanner at as low as 1/10th the cost of regular instances, https://cloud.google.com/blog/products/databases/get-more-out-of-spanner-with-granular-instance-sizing
NEW QUESTION # 43
......
The Professional-Cloud-Database-Engineer Exam is intended for individuals who have experience working with databases on the Google Cloud Platform. Professional-Cloud-Database-Engineer exam covers a wide range of topics, including database design, data modeling, data warehousing, data migration, database security, and database optimization. It also covers topics related to managing databases in a cloud environment, such as scalability, availability, and disaster recovery.
Get 100% Success with Latest Google Cloud Certified Professional-Cloud-Database-Engineer Exam Dumps: https://www.examdumpsvce.com/Professional-Cloud-Database-Engineer-valid-exam-dumps.html
Professional-Cloud-Database-Engineer Free Certification Exam Easy to Download PDF Format 2025: https://drive.google.com/open?id=11ic0dubZaK_1ckrvGfjPcoyx9qCUYF-R
