2026 Professional-Cloud-Database-Engineer dumps review - Professional Quiz Study Materials
Professional-Cloud-Database-Engineer Test Prep Training Practice Exam Questions Practice Tests
Google Cloud Certified - Professional Cloud Database Engineer exam is a computer-based test that consists of multiple-choice and multiple-select questions. Professional-Cloud-Database-Engineer exam duration is two hours, and the passing score is 70%. Professional-Cloud-Database-Engineer exam can be taken online or at a testing center.
NEW QUESTION # 39
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 persistent disk with customer-managed encryption keys.
- B. Create the database with Google-managed encryption keys.
- C. Create the database with customer-managed encryption keys.
- D. Create the database persistent disk with Google-managed encryption keys.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/postgres/configure-cmek#createcmekinstance
NEW QUESTION # 40
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, standby, and read replica instances in zone A, all in the same region.
- D. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview
NEW QUESTION # 41
Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?
- A. Use Memorystore to handle your low-latency requirements and for real-time analytics.
- B. Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.
- C. Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.
- D. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
Answer: D
Explanation:
Start with the lowest tier and smallest size and then grow your instance as needed. Memorystore provides automated scaling using APIs, and optimized node placement across zones for redundancy. Memorystore for Memcached can support clusters as large as 5 TB, enabling millions of QPS at very low latency
NEW QUESTION # 42
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?
- A. Assign the Cloud Spanner Database Admin role.
- B. Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
- C. Assign the Cloud Spanner Admin role.
- D. Assign the Cloud Spanner Database User role.
Answer: D
NEW QUESTION # 43
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
- A. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
- B. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
- C. Migrate applications and Oracle databases to Compute Engine.
- D. Migrate applications to Cloud SQL.
Answer: B
Explanation:
https://cloud.google.com/blog/products/databases/migrate-databases-to-google-cloud-vmware-engine-gcve
NEW QUESTION # 44
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?
- A. Use Logs Explorer to analyze log data.
- B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
- C. Use Error Reporting to count, analyze, and aggregate the data.
- D. Use Cloud Debugger to inspect the state of an application.
Answer: B
NEW QUESTION # 45
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 the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- B. Use the SQL Server Always On Availability Group dashboard.
- C. Use Cloud SQL logs.
- D. Use Cloud SQL instance monitoring.
Answer: B
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 # 46
Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?
- A. Increase the number of CPUs for your instance.
- B. Increase the storage size for the instance.
- C. Use Cloud Spanner instead of Cloud SQL.
- D. Use many smaller Cloud SQL instances.
Answer: C
NEW QUESTION # 47
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. Use Key Visualizer for Bigtable.
- B. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
- C. Add more nodes to the Bigtable cluster.
- D. Isolate the data analysts and operations user groups to use different Bigtable instances.
Answer: A
Explanation:
https://cloud.google.com/bigtable/docs/performance#troubleshooting
NEW QUESTION # 48
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. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
- C. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
- D. Create an external replica, and use Cloud SQL to synchronize the data to the replica.
Answer: B
NEW QUESTION # 49
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 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.
- C. 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.
- D. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
Answer: D
NEW QUESTION # 50
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?
- A. Modify the database schema, and add additional indexes.
- B. Shard data required by the application into multiple instances.
- C. Decrease the number of processing units.
- D. Increase the number of processing units.
Answer: D
NEW QUESTION # 51
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
- A. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
- B. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
- C. Migrate applications and Oracle databases to Compute Engine.
- D. Migrate applications to Cloud SQL.
Answer: B
NEW QUESTION # 52
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. Use a change data capture (CDC) migration strategy.
- 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. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
- E. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
Answer: A,E
NEW QUESTION # 53
Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?
- A. Migrate the Oracle databases to Cloud SQL.
- B. Migrate the Oracle databases to Compute Engine.
- C. Migrate the Oracle databases to Cloud Spanner.
- D. Migrate the Oracle databases to Bare Metal Solution for Oracle.
Answer: A
NEW QUESTION # 54
Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?
- A. Migrate the Oracle databases to Cloud SQL.
- B. Migrate the Oracle databases to Bare Metal Solution for Oracle.
- C. Migrate the Oracle databases to Compute Engine.
- D. Migrate the Oracle databases to Cloud Spanner.
Answer: B
Explanation:
This answer is correct because Bare Metal Solution for Oracle is a service that provides dedicated physical servers and networking infrastructure for running Oracle databases on Google Cloud1. Bare Metal Solution for Oracle supports Oracle RAC, which is a cluster database that provides high availability, scalability, and performance for Oracle workloads2. By using Bare Metal Solution for Oracle, you can migrate your Oracle databases with minimal to no changes to the applications, and you can leverage the native Google Cloud services and interconnectivity1.
NEW QUESTION # 55
You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS.
You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?
- A. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
- B. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
- C. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
- D. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
Answer: D
Explanation:
Given that Google SSD performance is related to the size of the disk in an order of 30 IOPS for each GB, ti would require at least 833 GB to handle 25000 IOPS, the only answer that exceeds this value is C.
https://cloud.google.com/compute/docs/disks/performance
NEW QUESTION # 56
Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?
- A. Use the native export and import functionality of the source database.
- B. Create a database on Google Cloud, and use database links to perform the migration.
- C. Create a database on Google Cloud, and use Dataflow for database migration.
- D. Use Database Migration Service.
Answer: D
Explanation:
Simplify migrations to the cloud. Available now for MySQL and PostgreSQL, with SQL Server and Oracle migrations in preview.
* Migrate to Cloud SQL and AlloyDB for PostgreSQL from on-premises, Google Cloud, or other clouds
* Replicate data continuously for minimal downtime migrations
* Serverless and easy to set up
NEW QUESTION # 57
Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?
- A. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east-b.
Create a read replica in us-east1-c. - B. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east1-b.
Create a read replica in us-central1-b. - C. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-central1-b.
Create a read replica in us-east1-b. - D. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-west1-b.
Create a read replica in us-east1-c.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/sqlserver/intro-to-cloud-sql-disaster-recovery
NEW QUESTION # 58
You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.
You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?
- A. Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.
- B. Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.
- C. Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.
- D. Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.
Answer: C
NEW QUESTION # 59
......
Exam Questions Answers Braindumps Professional-Cloud-Database-Engineer Exam Dumps PDF Questions: https://pass4sure.dumps4pdf.com/Professional-Cloud-Database-Engineer-valid-braindumps.html