Question 1

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?

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

BSet up different organizations for each database type, and apply policy constraints at the organization level.

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

DSet up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

Answer : D

Question 2

You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?

ADeploy the database using Cloud SQL.

BUse BigQuery, and load data in batches.

CC.Deploy the database using Bigtable.

DDeploy the database using Cloud Spanner.

Answer : C

Bigtable is a scalable, fully managed, and high-performance NoSQL database service that can handle semi-structured data and support real-time monitoring and analysis. Cloud SQL is a relational database service that does not support semi-structured dat

a. BigQuery is a data warehouse service that is optimized for batch processing and analytics, not real-time monitoring. Cloud Spanner is a relational database service that supports semi-structured data with JSON data type, but it is more expensive and complex than Bigtable for this use case.

Question 3

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

AUse Identity and Access Management (IAM) authentication.

BUse Managed Active Directory authentication.

CUse Cloud SQL federated queries.

DUse PostgreSQL database's built-in authentication.

Answer : A

https://cloud.google.com/sql/docs/postgres/authentication

Question 4

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?

AUse Cloud SQL instance monitoring.

BUse the Cloud Monitoring dashboard with available metrics from Cloud SQL.

CUse Cloud SQL logs.

DUse the SQL Server Always On Availability Group dashboard.

Answer : D

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

Question 5

You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project. What should you do to configure the networks?

ACreate a new VPC network in each project, and use VPC Network Peering to connect the two together.

BCreate a Shared VPC that both the application VMs and Cloud SQL instances will use.

CUse the default networks, and leverage Cloud VPN to connect the two together.

DPlace both the application VMs and the Cloud SQL instances in the default network of each project.

Answer : B

https://groups.google.com/g/google-cloud-sql-discuss/c/M5G5_HPXytY?pli=1

Free Practice Questions for Google Professional Cloud Database Engineer Exam

Question 1

Question 2

Question 3

Question 4

Question 5