support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Google
  4. PROFESSIONAL CLOUD DATABASE ENGINEER

Free PROFESSIONAL CLOUD DATABASE ENGINEER Exam Braindumps
Professional Cloud Database Engineer Questions 61–65 (page: 14)

Updated On: 10-Feb-2026
Page 14 of 28
PDF with 197 Questions

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?

  1. Create a clone database from a read replica database, and restore the clone in the same region.
  2. Create a clone database from a read replica database, and restore the clone into a different zone.
  3. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
  4. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.

Answer(s): C

Explanation:

Using import/export from last week is slow for large scale databases and will restore database from last week.



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?

  1. Create the database with Google-managed encryption keys.
  2. Create the database with customer-managed encryption keys.
  3. Create the database persistent disk with Google-managed encryption keys.
  4. Create the database persistent disk with customer-managed encryption keys.

Answer(s): B

Explanation:

https://cloud.google.com/sql/docs/postgres/configure-cmek#createcmekinstance



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?

  1. Export the data from the existing instance, and import the data into a new instance with solid- state drives (SSDs).
  2. Edit the instance to change the storage type from HDD to SSD.
  3. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
  4. Create a read replica of the instance with SSDs, and perform a failover to the new instance

Answer(s): A

Explanation:

https://stackoverflow.com/questions/72034607/can-i-change-storage-type-from-hdd-to-ssd-on- cloud-sql-after-creating-an-instanc



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?

  1. Reuse the existing service account that populates this database.
  2. Create a new service account, and grant it the Cloud Spanner Database Admin role.
  3. Create a new service account, and grant it the Cloud Spanner Database Reader role.
  4. Create a new service account, and grant it the spanner.databases.select permission.

Answer(s): C

Explanation:

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



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?

  1. Watch Query Insights for long running queries.
  2. Watch the Cloud SQL instance monitor for CPU utilization metrics.
  3. Watch the Cloud SQL recommenders for overprovisioned instances.
  4. Watch Cloud Trace for application requests that are failing.

Answer(s): A

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 large for 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



  PDF
Viewing page 14 of 28
Viewing questions 66 - 70 out of 197 questions


Post your Comments and Discuss Google PROFESSIONAL CLOUD DATABASE ENGINEER exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!