PCDE Practice Test 3 — 10 Questions

Question 1

A company is designing a mobile application backend that requires real-time synchronization across users and offline support. Which Google Cloud database service is most suitable?

Accepted Answer

Firestore. Firestore is designed for real-time sync, offline support, and mobile/web applications. It provides real-time listeners and offline data persistence.

Answer

Bigtable

Answer

Cloud SQL

Answer

Cloud Spanner

Question 2

A company has a Cloud SQL for PostgreSQL instance with a read replica in another region. They want to perform disaster recovery testing without affecting the primary. What should they do?

Accepted Answer

Promote the read replica to a standalone instance and use it for testing.. Promoting the read replica to a standalone instance detaches it from the primary, creating an independent writable Cloud SQL instance. This allows you to perform disaster recovery testing (e.g., failover validation, data integrity checks) without any impact on the primary instance, as the replica no longer replicates changes from the primary.

Answer

Use the replica as a failover target; testing is not allowed.

Answer

Enable point-in-time recovery on the replica and restore to a new instance.

Answer

Create a clone of the primary instance and test on that.

Question 3

A company wants to store and analyze data with BigQuery. They have customers in Europe and need to comply with GDPR data residency requirements. What should they do to ensure data stays within the European Union?

Accepted Answer

Create the dataset with the location set to 'EU'.. BigQuery enforces data residency at the dataset level. When you create a dataset with the location set to 'EU', all tables, views, and data within that dataset are physically stored in a Google Cloud region within the European Union. This ensures compliance with GDPR data residency requirements, as data will not be moved or replicated outside the EU without explicit user action.

Answer

Use the default dataset location and rely on BigQuery's automatic compliance.

Answer

Set the query job location to 'EU' for all queries.

Answer

Choose a dataset location of 'us-central1' for performance.

Question 4

A team is migrating an on-premises PostgreSQL database to Cloud SQL using DMS. They want the migration job to continuously replicate changes after the initial dump. Which type of migration job should they create?

Accepted Answer

Continuous migration job. DMS offers 'one-time' for single dump and 'continuous' for ongoing CDC. Continuous jobs replicate changes after dump.

Answer

One-time migration job

Answer

Scheduled export job

Answer

Bulk load job

Question 5

An engineer is migrating a 20 TB PostgreSQL database to AlloyDB using DMS continuous migration. The full dump phase is taking longer than expected. Which THREE factors could affect the duration of the full dump phase? (Choose THREE.)

Accepted Answer

The number of tables and indexes on the source.. Full dump time depends on data volume, network bandwidth, CPU/memory of the source, and configuration (e.g., parallel workers).

Answer

The version of the source PostgreSQL database.

Answer

The choice of SSL or non-SSL connection.

Question 6

An engineer needs to connect Database Migration Service to a source MySQL database that has only a private IP address. The Cloud SQL destination is also private. What is the recommended method for DMS to connect to the source?

Accepted Answer

Use VPC peering or Cloud SQL Auth Proxy. For private IP sources, VPC peering or Cloud SQL Auth Proxy can be used. Auth Proxy is recommended for secure connectivity without public IP exposure.

Answer

Use a Cloud VPN tunnel with static IP

Answer

Use Cloud NAT to provide outbound connectivity

Answer

Use the source database's public IP with IP allowlisting

Question 7

A team needs to migrate a large Teradata data warehouse to BigQuery. They want to automatically convert Teradata DDL and BTEQ scripts to BigQuery-compatible SQL. Which Google Cloud service should they use?

Accepted Answer

Schema Conversion Tool (SCTS). Schema Conversion Tool (SCTS) is designed for heterogeneous migrations, converting DDL and scripts from sources like Teradata to BigQuery.

Answer

BigQuery Data Transfer Service

Answer

Database Migration Service (DMS)

Answer

Cloud Dataflow

Question 8

An organization needs to design a disaster recovery plan for Cloud SQL for PostgreSQL with an RPO of 10 seconds and an RTO of 5 minutes. Which TWO solutions meet these requirements? (Choose 2)

Accepted Answer

Cloud SQL cross-region read replica with manual promotion.. Cloud SQL HA provides near-zero RPO and RTO under 60 seconds within the same region. Cross-region read replicas can achieve RPO of seconds if replication lag is low, and manual promotion takes minutes.

Answer

Export the database to Cloud Storage and import in another region.

Answer

Cloud SQL point-in-time recovery from backups.

Answer

Use Cloud SQL automated backups with cross-region copy.

Question 9

A company is migrating their on-premises MySQL database to Cloud SQL. The database is 500 GB and they have a 1 Gbps network connection. They want to minimize downtime. Which THREE steps should they take?

Accepted Answer

Perform a test migration to validate the process.. Performing a test migration validates the entire process, including schema compatibility, data integrity, and application connectivity, before the actual cutover. This reduces the risk of unexpected failures during the production migration, which is critical for minimizing downtime. A test migration also helps estimate the time required for the final cutover and allows for tuning of the Database Migration Service settings.

Answer

Export the database to a SQL file and import after the cutover.

Answer

Schedule a maintenance window for the cutover.

Question 10

What is the maximum backup retention period for Cloud Spanner backups?

Accepted Answer

365 days. Cloud Spanner allows backups to be retained for up to 365 days.

Answer

730 days

Answer

90 days

Answer

30 days