PCDE Manage a solution that can span multiple database technologies Practice Test 11 — 15 Questions

Question 1

A company is migrating on-premises PostgreSQL databases to Cloud SQL. They need to minimize downtime and ensure data consistency. Which THREE steps should they follow? (Choose 3)

Accepted Answer

Use Database Migration Service to set up continuous replication from the on-premises database.. A typical migration uses Database Migration Service (DMS) with continuous replication for minimal downtime. Setting up replication and then promoting the Cloud SQL instance is standard.

Answer

Export the on-premises database to a dump file and import it into Cloud SQL.

Answer

Manually sync data using a custom script with pg_dump and pg_restore.

Question 2

A company is using Cloud Bigtable and wants to set up monitoring and alerting for replication lag between clusters. Which TWO metrics should they use? (Choose 2)

Accepted Answer

cloudbigtable.googleapis.com/cluster/replication_lag. `replication_lag` directly measures the time difference between the primary cluster and a replica cluster in Cloud Bigtable, which is the key metric for monitoring replication delay. Option D is also correct because `replication_delay` is another metric that tracks the same concept, often reported in seconds, and is used to alert when replicas fall behind. Both metrics are essential for ensuring data consistency and timely failover in multi-cluster Bigtable deployments.

Answer

cloudbigtable.googleapis.com/cluster/disk_usage

Answer

cloudbigtable.googleapis.com/cluster/cpu_load

Answer

cloudbigtable.googleapis.com/cluster/operations_count

Question 3

A company runs an e-commerce platform on Cloud SQL for PostgreSQL. They need to perform point-in-time recovery (PITR) to recover from a user error that occurred 30 minutes ago. Which configuration is required to enable PITR?

Accepted Answer

Enable automated backups and configure a retention of 1-7 days; PITR uses WAL archiving automatically.

Answer

Enable binary logging and set a backup retention of 1-7 days.

Answer

Set up cross-region backup replicas and configure a retention of 1-7 days.

Answer

Enable PITR by setting the 'pitr_enabled' flag to true in the database flags.

Question 4

A Cloud Spanner database is experiencing increased read traffic. You need to add an index to improve query performance without downtime. What is the correct approach?

Accepted Answer

Use the CREATE INDEX statement. Spanner creates indexes online without blocking writes or reads.

Answer

Export the database, create the index in a new instance, then import.

Answer

Use the ALTER TABLE statement to add the index as a constraint.

Answer

Create a secondary index using the 'CREATE INDEX WITH OFFLINE' option to avoid blocking.

Question 5

You are monitoring Cloud Bigtable replication lag. Which metric should you use to determine if replicas are up to date, and what consistency level is typical for Bigtable replication?

Accepted Answer

Use 'replication_lag' metric; consistency is eventually consistent.

Answer

Use 'cluster_lag' metric; consistency is read-your-writes consistent.

Answer

Use 'replica_lag' metric; consistency is strongly consistent.

Answer

Use 'replication_lag' metric; consistency is strongly consistent.

Question 6

A Memorystore for Redis instance is running out of memory. The application uses Redis as a cache with key expiration. You want to prevent data loss for keys that have not reached their TTL. Which eviction policy should you configure?

Accepted Answer

volatile-lru

Answer

noeviction

Answer

volatile-ttl

Answer

allkeys-lru

Question 7

A company has a Firestore database in Native mode. They need to run a query that filters on two fields (status and date) and orders by date. The query is slow and returns an error that a matching index is missing. What must the engineer do to resolve this?

Accepted Answer

Create a composite index on status and date in the Firebase Console or using gcloud.. Firestore requires a composite index on both the equality filter field (status) and the order field (date) when a query uses equality filters on one field and an order on another. Without this composite index, the query cannot be executed efficiently and returns an error. Creating the composite index via the Firebase Console or gcloud CLI resolves the issue.

Answer

Enable single-field indexes for both fields; Firestore will automatically use them.

Answer

Rewrite the query using 'IN' clauses to avoid the need for a composite index.

Answer

Change the database to Datastore mode, which does not require indexes.

Question 8

Your Cloud SQL for MySQL instance is running low on storage. You need to increase the storage size without downtime. What should you do?

Accepted Answer

Edit the instance and increase the storage size; it will be applied online.. Cloud SQL for MySQL supports online storage increases. When you edit the instance and increase the storage allocation, the operation is applied without requiring a restart or causing downtime. The underlying infrastructure uses live migration and dynamic volume expansion to make the additional capacity available immediately while the instance continues serving traffic.

Answer

You cannot increase storage online; you must create a new instance.

Answer

Create a clone of the instance with larger storage and switch traffic.

Answer

Enable automatic storage increase and it will happen automatically.

Question 9

A team is designing a disaster recovery strategy for Cloud SQL. They need to be able to recover the database in a different region with a Recovery Point Objective (RPO) of less than 30 minutes. What should they configure?

Accepted Answer

Create a cross-region read replica and promote it to standalone during a disaster.

Answer

Use on-demand backups every 30 minutes and store them in a multi-regional bucket.

Answer

Enable binary logging and configure a cross-region replica for PITR.

Answer

Create automated backups with a retention of 7 days and restore to a new instance in the desired region.

Question 10

Your Memorystore for Redis instance needs to survive a zonal failure with minimal data loss. Which feature should you use?

Accepted Answer

Use a Standard tier instance with replication across zones within the same region.. A Standard tier Memorystore for Redis instance with replication across zones provides automatic failover to a replica in a different zone, ensuring high availability and minimal data loss during a zonal failure. The Standard tier uses synchronous replication within the region, so data written to the primary is replicated to the cross-zone replica before acknowledging the write, which minimizes data loss to only in-flight transactions that were not yet committed.

Answer

Use a Basic tier instance and schedule periodic exports to Cloud Storage.

Answer

Enable persistence with RDB snapshots stored in Cloud Storage.

Answer

Create a cross-region replica (read replica in another region).

Question 11

You are building a global application that requires strong consistency across regions. The application needs to support SQL queries and horizontal scaling. Which database service should you choose?

Accepted Answer

Cloud Spanner

Answer

Cloud SQL with cross-region replicas

Answer

Cloud Bigtable

Answer

Firestore

Question 12

Which TWO actions are required to set up point-in-time recovery (PITR) for Cloud SQL for MySQL? (Choose 2)

Accepted Answer

Enable binary logging.

Answer

Set the 'log_bin' flag to ON in the database flags.

Answer

Create a read replica in a different region.

Answer

Configure a cross-region backup replica.

Question 13

Which TWO statements about Cloud Spanner schema changes are correct? (Choose 2)

Accepted Answer

Schema changes are applied asynchronously and may take minutes to hours to complete.

Answer

Schema changes require the instance to be restarted.

Answer

You can only add columns, not drop them.

Answer

Creating a secondary index requires taking the table offline.

Question 14

Which THREE metrics should you set up alerts for to proactively monitor the health of a Cloud SQL for MySQL instance? (Choose 3)

Accepted Answer

Replication lag (for instances with replicas). Replication lag (for instances with replicas) is critical because high lag can cause stale reads and data inconsistency. CPU utilization above 80% indicates resource exhaustion, leading to performance degradation. Disk usage must be monitored to prevent storage full conditions that can cause instance downtime. These three metrics directly reflect instance health, whereas queries per second and network throughput are more related to workload performance, not health.

Answer

Number of queries per second

Answer

Network throughput

Question 15

A Memorystore for Redis instance needs to be scaled to handle increased traffic. Which TWO methods can you use? (Choose 2)

Accepted Answer

Vertically scale by changing the tier to a larger machine type.

Answer

Increase the maxmemory parameter.

Answer

Change the eviction policy to allkeys-lru.

Answer

Add read replicas in the same zone.