Enhance Your Career With Available Preparation Guide for Professional-Cloud-Database-Engineer Exam
Get Special Discount Offer of Professional-Cloud-Database-Engineer Certification Exam Sample Questions and Answers
Google Professional-Cloud-Database-Engineer Exam is a certification exam that is designed to test the skills and knowledge of professionals who are responsible for managing and administering databases on the Google Cloud Platform. Professional-Cloud-Database-Engineer exam is part of the Google Cloud Certified program, which is a professional certification program offered by Google for individuals who want to demonstrate their expertise in Google Cloud technologies.
NEW QUESTION # 33
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?
- A. Run the cron job on a Compute Engine instance to continue the export.
- B. Set up Cloud Composer, and create a task to export the table daily.
- C. Create a streaming Datatlow job to export the table.
- D. Use Cloud Scheduler and Cloud Functions to run the daily export.
Answer: B
NEW QUESTION # 34
You are migrating your critical production database from Amazon RDS for MySQL to Cloud SQL for MySQL by using Google Cloud's Database Migration Service. You want to keep disruption to your production database to a minimum and, at the same time, optimize migration performance.
What should you do-
- A. Upgrade the Amazon RDS for MySQL primary instance to an instance with more vCPUs and memory, and then run Google Cloud's Database Migration Service.
- B. Create a single Database Migration Service migration job with initial Load Parallelism configured to Maximum on the Amazon RDS for MySQL primary instance.
- C. Create a single Database Migration Service migration job with initial load parallelism configured to maximum on the source Amazon RDS for MySQL read replica.
- D. Create and start multiple Database Migration Service jobs to migrate your database to the target Cloud SQL for MySQL instance.
Answer: C
Explanation:
By pointing your single Database Migration Service job at an Amazon-RDS read replica and cranking initial-load parallelism to its maximum, you offload heavy full-load reads from production and ingest data faster into Cloud-SQL. This approach minimizes impact on your live primary instance while maximizing throughput during the initial load.
NEW QUESTION # 35
Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?
- A. Normalize the database to the third normal form.
- B. Create another schema to load older data.
- C. Compress the data using a different compression algorithm.
- D. Manually or automatically increase the storage capacity.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen
NEW QUESTION # 36
You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?
- A. Set your production instance's maintenance window to non-business hours.
- B. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
- C. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
- D. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
Answer: A
NEW QUESTION # 37
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. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
- C. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
- D. Use workload identity federation to impersonate a service account.
Answer: B
NEW QUESTION # 38
Your company is launching a gaming application that uses a Firestore database. You need to identify an easy-to-manage and cost-effective solution to automate the scheduling of Firestore data exports. What should you do-
- A. Use the Firebase Admin SDK to programmatically schedule and manage exports.
- B. Use Cloud Scheduler to trigger a Cloud Function that executes the Firestore export process.
- C. Use Dataflow to create a custom pipeline to extract data from Firestore, transform it into the desired format, and load it into a Cloud Storage bucket at regular intervals.
- D. Create a new Compute Engine, and set up a cron Job to run the gcloud firestore export command.
Answer: B
Explanation:
The simplest, lowest-ops way is to have Cloud-Scheduler kick off a Cloud-Function that calls the Firestore Admin API's export endpoint on a schedule. This keeps everything serverless, you only pay for Scheduler and Function invocations, and there's no VM or heavy custom pipeline to manage.
NEW QUESTION # 39
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
- A. Use Cloud SQL for MySQL external replica.
- B. Use the mysqldump utility and binary logs.
- C. Use external server replication.
- D. Use Data Migration Service.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/replication/external-server
NEW QUESTION # 40
You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?
- A. Use Migrate for Compute Engine to complete the migration.
- B. Export the data from the existing database, and load the data into a new Cloud SQL database.
- C. Use Datastream to complete the migration.
- D. Use Database Migration Service to complete the migration.
Answer: D
Explanation:
https://www.cloudskillsboost.google/focuses/22792?parent=catalog
NEW QUESTION # 41
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?
- A. Use Cloud Spanner.
- B. Use Cloud SQL for MySQL
- C. Use Bigtable.
- D. Use Firestore.
Answer: A
NEW QUESTION # 42
Your application stores session documents in Firestore and queries them by steps, sessionDuration, and energyBurned. After a 30 day test period, latency is acceptable but costs are high. Which Firestore change would reduce cost while preserving performance and availability?
- A. Add Cloud Memorystore cache
- B. Use batched writes for lower cost
- C. Trim Firestore indexes to only required ones
- D. Denormalize documents
Answer: D
Explanation:
Firestore automatically creates single field indexes for most fields which means each document write updates multiple index entries and drives up write and storage costs. By trimming indexes to only the ones required by your queries on steps, sessionDuration and energyBurned you reduce index write amplification and index storage while preserving the performance of the queries you care about. This is a configuration change that does not reduce availability because Firestore remains fully managed and you keep the essential indexes for your filters and sort orders.
You can delete unused composite indexes and add single field index exemptions for attributes that are not part of your supported query patterns. Monitor index usage and keep only the minimal set that powers production queries so you sustain acceptable latency while lowering cost.
NEW QUESTION # 43
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-centrallregion. You need to set up and test disaster recovery (DR) with zero data loss in the us-west1region. What should you do-
- A. Create a cross-region read replica, version 8.0.37, in the us-west1region. Designate it as the failover DR replica, and test switchover by using the gcloud switchovercommand.
- B. Create a cross-region read replica, version 8.0.34, in the us-west1region. Test switchover by using the gcloud promote-replica with failovercommand.
- C. Create a cross-region read replica version 8.0.34, in the us-west1region. Designate it as the failover DR replica, and test switchover by using the gcloud switchovercommand.
- D. Use advanced DR by setting up a cascading read replica in the us-west1region, and designate it as the failover DR replica. Test switchover by using the gcloud switchovercommand.
Answer: C
Explanation:
You need to use Cloud SQL's Advanced DR feature (available on Enterprise-Plus) to get true zero-data-loss drills and failovers. That means:
1. Create a direct cross-region read replica in us-west1 using the same MySQL major-&-minor version (8.0.34) as your primary (zero data-loss switchover requires identical versions and Enterprise-Plus)
2. Designate that replica as your DR replica (the "failover DR replica" in the docs).
3. Test DR by running the built-in switchover, e.g.: gcloud sql instances switchover DR_REPLICA_NAMEwhich reverses roles with zero data loss
NEW QUESTION # 44
Your company is planning to migrate their 5 TB on-premises MySQL database to Cloud SQL for MySQL. You need a Google-recommended approach for schema and data migration. You must keep downtime to a minimum while ensuring continuous data replication.
What should you do?
- A. Manually export the data from the on-premises database CSV format, and import this data into a new Cloud SQL instance.
- B. Use Dataflow to set up a custom ETL pipeline to extract data from the on-premises database, and load the data into Cloud SQL.
- C. Use the mysqldumputility to create a backup of the on-premises database, and restore that backup into a new Cloud SQL instance.
- D. Use Database Migration Service to migrate data from the on-premises database to Cloud SQL, then promote the Cloud SQL instance as the primary after migration is complete.
Answer: D
Explanation:
Database Migration Service is the Google-recommended approach for migrating MySQL to Cloud SQL with minimal downtime because it supports an initial load followed by continuous replication (CDC) until cutover, after which you promote Cloud SQL to be the primary.
NEW QUESTION # 45
You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?
- A. Write a utility to scan application logs.
- B. Shut down and restart each application.
- C. Write a utility to scan database query logs.
- D. Use query tags to add application-centric database monitoring.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags
NEW QUESTION # 46
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 # 47
During a migration from a monolith to microservices on Google Cloud, which database strategy minimizes downtime while preserving the option to adopt service specific data stores later?
- A. Refactor into microservices while all services keep using the single database for now
- B. Add a data access layer service that proxies all database calls
- C. Migrate to Cloud Spanner now and split schemas by service
- D. Create one database per service and cut over all services in one release
Answer: A
Explanation:
This approach allows teams to migrate incrementally. You can preserve existing transactions and consistency guarantees while extracting services. As each service stabilizes you can introduce service owned tables or new data stores and migrate data with techniques such as change data capture or controlled backfills. This sequence reduces operational risk since you avoid changing application architecture and database architecture at the same time.
NEW QUESTION # 48
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-central1-b.
Create a read replica in us-east1-b. - 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-west1-b.
Create a read replica in us-east1-c. - D. 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.
Answer: A
NEW QUESTION # 49
Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?
- A. Watch the Cloud SQL instance monitor for CPU utilization metrics.
- B. Watch the Cloud SQL recommenders for overprovisioned instances.
- C. Watch Query Insights for long running queries.
- D. Watch Cloud Trace for application requests that are failing.
Answer: C
Explanation:
Cloud Trace doesn't support Cloud SQL. Eliminate D. Cloud SQL recommenders for overprovisioned instances would tell you about Cloud SQL instances which are too largefor their workload. Eliminate C.
Monitoring CPU utilization wouldn't tell you why microservice calls are failing. Eliminate B. SQLcommenter integrates with Query Insights. So A is the best answer. https://cloud.google.com/blog/topics/developers- practitioners/introducing-sqlcommenter-open-source-orm-auto-instrumentation-library
NEW QUESTION # 50
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 Spanner.
- B. Use Cloud SQL.
- C. Use Bigtable.
- D. Use Firestore.
Answer: A
Explanation:
99,999% availability and global - it's either Spanner or Firestore, but 'transactional' eliminates Firestore
NEW QUESTION # 51
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. Use direct scaling to implement the Autoscaler-based architecture.
- C. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
- D. Use linear scaling to implement the Autoscaler-based architecture
Answer: C
NEW QUESTION # 52
......
Updated Professional-Cloud-Database-Engineer Dumps Questions Are Available For Passing Google Exam: https://www.pass4leader.com/Google/Professional-Cloud-Database-Engineer-exam.html
New Professional-Cloud-Database-Engineer Dumps For Preparing Google Cloud Certified Certified Google Exam Well: https://drive.google.com/open?id=1OMIZ8eRX069Km0S6gitcJBlHtQ7Xi1JX