Question No. 1

You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:

configure where data is stored

control where the encryption keys are stored

govern the access to data

What should you do?

AReplicate Cloud SQL databases across different zones.

BCreate a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.

CAllow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.

DUse features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.

Show Answer

Correct Answer: D

https://cloud.google.com/blog/products/identity-security/meet-data-residency-requirements-with-google-cloud

Question No. 2

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?

AWatch Query Insights for long running queries.

BWatch the Cloud SQL instance monitor for CPU utilization metrics.

CWatch the Cloud SQL recommenders for overprovisioned instances.

DWatch Cloud Trace for application requests that are failing.

Show Answer

Correct Answer: A

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

Question No. 3

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.)

AUse an external read replica to migrate the databases to Cloud SQL.

BUse a read replica to migrate the databases to Cloud SQL.

CUse Database Migration Service to migrate the databases to Cloud SQL.

DUse a cross-region read replica to migrate the databases to Cloud SQL.

EUse replication from an external server to migrate the databases to Cloud SQL.

Show Answer

Correct Answer: C, E

Question No. 4

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

ACreate one regional Cloud SQL instance with a read replica in another region.

BCreate one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

CCreate two read-write Cloud SQL instances in two different zones with a standby instance in another region.

DCreate two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

Show Answer

Correct Answer: B

This answer is correct because it meets the requirements of having an optimal and highly available environment with automatic failover.According to the Google Cloud documentation1, a regional Cloud SQL instance is an instance that has a primary server in one zone and a standby server in another zone within the same region. The primary and standby servers are kept in sync using synchronous replication, which ensures zero data loss and minimal downtime in case of a zonal outage or an instance failure.If the primary server becomes unavailable, Cloud SQL automatically fails over to the standby server, which becomes the new primary server1.

Question No. 5

You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

AConfigure the automated backups to use a regional Cloud Storage bucket as a custom location.

BUse the default configuration for the automated backups location.

CDisable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

DDisable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

Show Answer

Correct Answer: A

https://cloud.google.com/sql/docs/mysql/backup-recovery/backing-up#locationbackups You can use a custom location for on-demand and automatic backups. For a complete list of valid location values, see the Instance locations.

Free Google Professional-Cloud-Database-Engineer Exam Actual Questions

The questions for Professional-Cloud-Database-Engineer were last updated On Dec 18, 2024