Free Dec-2025 Professional-Cloud-Database-Engineer Certification Sample Questions certification Exam [Q57-Q71]

この記事を評価する

Free Dec-2025 Professional-Cloud-Database-Engineer Certification Sample Questions certification Exam

Certification Topics of Professional-Cloud-Database-Engineer Exam PDF Recently Updated Questions

Google Professional-Cloud-Database-Engineer certification exam is designed to test the knowledge and skills of individuals who want to become certified database engineers. Google Cloud Certified – Professional Cloud Database Engineer certification is offered by Google Cloud and is intended for individuals who have experience in designing, building, and maintaining databases on the Google Cloud Platform.

Achieving the Google Professional-Cloud-Database-Engineer certification demonstrates to employers and clients that you have the knowledge and skills needed to design, develop, and manage cloud-based database solutions using Google Cloud. It can also open up new career opportunities and increase earning potential.

質問57
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?

Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.

Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.

Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.

Create an external replica, and use Cloud SQL to synchronize the data to the replica.

https://cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external

質問58
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?

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.

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.

Set up all read replicas in a different region using asynchronous replication.

Set up all read replicas in the same region as the primary instance with synchronous replication.

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.

質問59
Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?

Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.

Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
Schedule downtime to run each Cloud Data Fusion pipeline.
Verify that the migration was successful.
Re-point the applications to the Cloud SQL for MySQL instance.

Pause the on-premises applications.
Use the mysqldump utility to dump the database content in compressed format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

https://cloud.google.com/database-migration/docs/mysql/configure-source-database To migrate the database while preserving transactions and minimizing downtime, you should use Database Migration Service. This service will allow you to migrate the database in a way that is transparent to your users and applications. It will also allow you to test the migration before you make it live, so that you can be sure that everything will work as expected.

質問60
You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

View Cloud SQL operations to view historical query information.

White a Logs Explorer query to identify database queries with high execution times.

Review application logs to identify database calls.

Use the Query Insights dashboard to identify high execution times.

A Cloud SQL instance configured for HA is also called a regional instance and has a primary and secondary zone within the configured region. Within a regional instance, the configuration is made up of a primary instance and a standby instance. Through synchronous replication to each zone’s persistent disk, all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed. In the event of an instance or zone failure, the standby instance becomes the new primary instance. Users are then rerouted to the new primary instance. This process is called a failover.

質問61
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

Use Bigtable.

Use Firestore.

Use Cloud SQL for MySQL

Use Cloud Spanner.

Spanner covers the SLA

質問62
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?

Create a VM in Compute Engine, and run a cron job.

Create a Cloud Composer instance, and create a directed acyclic graph (DAG).

Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.

Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.

質問63
You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?

Use Firestore.

Use Cloud SQL with an external (public) IP address.

Use an in-app embedded database.

Use Cloud Spanner.

https://firebase.google.com/docs/firestore

質問64
You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

Reuse the existing service account that populates this database.

Create a new service account, and grant it the Cloud Spanner Database Admin role.

Create a new service account, and grant it the Cloud Spanner Database Reader role.

Create a new service account, and grant it the spanner.databases.select permission.

https://cloud.google.com/iam/docs/overview

質問65
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?

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.

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.

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.

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.

https://cloud.google.com/datastream/docs/overview.

質問66
You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

Use Cloud Spanner in a regional configuration.

Use Cloud Spanner in a multi-region configuration.

Use Cloud SQL with cross-region replicas.

Use highly available Cloud SQL with multiple zones.

https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-
bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform

質問67
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?

Migrate the Oracle databases to Cloud Spanner.

Migrate the Oracle databases to Compute Engine.

Migrate the Oracle databases to Cloud SQL.

Migrate the Oracle databases to Bare Metal Solution for Oracle.

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.

質問68
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?

Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.

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.

Use Memorystore to handle your low-latency requirements and for real-time analytics.

Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.

質問69
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.

Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

質問70
Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard.
You need to recommend the optimal storage type for this read-intensive database. What should you do?

Recommend solid-state drives (SSD).

Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.

Recommend hard disk drives (HDD).

Recommend mixed storage types.

if you plan to store extensive historical data for a large number of remote-sensing devices and then use the data to generate daily reports, the cost savings for HDD storage might justify the performance tradeoff. On the other hand, if you plan to use the data to display a real-time dashboard, it probably would not make sense to use HDD storage-reads would be much more frequent in this case, and reads that are not scans are much slower with HDD storage.

質問71
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?

Setup a static external IP address in your VPC network.

Set up bring your own IP (BYOIP) in your VPC.

Set up a Cloud NAT gateway on the Compute Engine VM.

Set up Cloud NAT service.

https://cloud.google.com/bare-metal/docs/bms-setup?hl=en#bms-access-internet-vm-nat The docs specifically says “Setting up a NAT gateway on a Compute Engine VM” is the way to give BMS internet access.

ローディング …