Knowledge + Practice

CCNA Pcd Multi Database Questions

75 of 130 questions · Page 1/2 · Pcd Multi Database topic · Answers revealed

Practice these questions Exam hub All questions

1

MCQmedium

A company runs an e-commerce application with a relational database (PostgreSQL) for orders and inventory. They need to store clickstream data for real-time personalization, with a flexible schema and sub-second read latency. Which database best suits the clickstream workload?

A.Firestore

B.BigQuery

C.Cloud Spanner

D.Cloud Bigtable

AnswerA

Firestore is a flexible, scalable NoSQL document database with real-time capabilities and sub-second latency, ideal for clickstream personalization.

Practice this question →

2

MCQmedium

A company wants to use BigQuery Omni to query data stored in Amazon S3. They have set up a BigQuery Omni connection. Which querying method should they use?

A.Create an external table referencing the S3 data

B.Use Cloud Storage Transfer Service

C.Use the BigQuery Data Transfer Service to copy data

D.Use the bq load command to load data into BigQuery

AnswerA

External tables allow querying without moving data into BigQuery storage.

Why this answer

BigQuery Omni uses external tables stored in S3 (or Azure Blob). You create an external table that points to the S3 location, then query it with standard SQL.

Practice this question →

3

MCQmedium

A company wants to replicate data from an on-premises Oracle database to BigQuery for analytics. They need serverless, near-real-time CDC with minimal operational overhead. Which service should they use?

A.Cloud Data Fusion with Oracle plugin

B.Cloud Composer with scheduled jobs

C.Datastream

D.Dataflow with a Java transformation

AnswerC

Datastream provides serverless CDC from Oracle to BigQuery.

Why this answer

Datastream is a serverless, fully managed change data capture (CDC) and replication service that streams data from Oracle (and other sources) into BigQuery with near-real-time latency. It uses log-based CDC (Oracle Redo Logs) to capture changes without impacting source performance, and it handles schema mapping and data transformation automatically, minimizing operational overhead.

Exam trap

The trap here is that candidates often confuse Datastream with Dataflow, assuming that any streaming CDC must use Dataflow, but Datastream is the purpose-built, serverless service for database-to-BigQuery replication with minimal overhead, while Dataflow is a general-purpose processing engine that requires custom CDC implementation.

How to eliminate wrong answers

Option A is wrong because Cloud Data Fusion is a batch-oriented ETL/ELT service that requires manual pipeline configuration and does not provide native, serverless, near-real-time CDC from Oracle to BigQuery; its Oracle plugin is for batch reads, not continuous log-based streaming. Option B is wrong because Cloud Composer is a managed Apache Airflow service for orchestrating scheduled batch jobs, not a real-time CDC solution; it would introduce latency and operational overhead for near-real-time replication. Option D is wrong because Dataflow with a Java transformation is a powerful stream/batch processing engine but requires custom code to implement CDC logic (e.g., reading Oracle logs) and is not a turnkey, serverless CDC service; it adds development and maintenance overhead compared to Datastream.

Practice this question →

4

MCQmedium

A company has an application using Cloud SQL MySQL and wants to add a caching layer. They also need the cache to persist data across restarts. Which Memorystore tier should they choose?

A.Memorystore for Redis Basic tier

B.Memorystore for Redis Standard tier

C.Memorystore for Memcached

D.Cloud Bigtable

AnswerB

Standard tier provides replication and persistence.

Why this answer

Memorystore for Redis Standard tier is the correct choice because it provides replication (a replica node) and automatic failover, which enables data persistence across restarts. Unlike the Basic tier, which is a single node with no persistence guarantees, the Standard tier uses append-only file (AOF) persistence to ensure data survives node restarts. This meets the requirement for a caching layer that persists data across restarts.

Exam trap

Cisco often tests the distinction between Memorystore tiers by making candidates assume that any Redis tier provides persistence, when in fact only the Standard tier (with replication) guarantees data survival across restarts.

How to eliminate wrong answers

Option A is wrong because Memorystore for Redis Basic tier is a single-node deployment with no replication or persistence, so data is lost on restart. Option C is wrong because Memorystore for Memcached is a pure cache with no persistence capabilities; it is designed for ephemeral data and loses all data on restart. Option D is wrong because Cloud Bigtable is a fully managed NoSQL wide-column database, not a caching layer, and is overkill for a simple cache; it also does not provide the low-latency, in-memory caching semantics required.

Practice this question →

5

MCQeasy

A company is migrating an on-premises PostgreSQL database to Cloud SQL for PostgreSQL. They need to minimize downtime and ensure continuous replication during the cutover. Which Google Cloud service should they use to achieve continuous change data capture (CDC)?

A.Cloud Data Fusion

B.Database Migration Service (DMS)

C.Dataproc

D.Cloud Memorystore

AnswerB

DMS provides continuous migration with CDC from PostgreSQL to Cloud SQL PostgreSQL.

Why this answer

Database Migration Service (DMS) supports continuous change data capture (CDC) for PostgreSQL migrations to Cloud SQL by using PostgreSQL's native logical replication. This allows DMS to replicate ongoing changes from the source to the target with minimal downtime, enabling a near-zero-downtime cutover by simply promoting the Cloud SQL instance as the new primary.

Exam trap

The trap here is that candidates may confuse Cloud Data Fusion's ETL capabilities with database replication, not realizing that DMS is the only Google Cloud service purpose-built for live database migrations with CDC support.

How to eliminate wrong answers

Option A is wrong because Cloud Data Fusion is a data integration and ETL service, not a database migration tool; it does not provide continuous CDC for PostgreSQL to Cloud SQL. Option C is wrong because Dataproc is a managed Spark and Hadoop service for big data processing, not designed for database replication or CDC. Option D is wrong because Cloud Memorystore is a managed Redis/Memcached in-memory cache service, which cannot perform CDC or replicate PostgreSQL data.

Practice this question →

6

MCQmedium

An online gaming company uses Cloud SQL for MySQL for player data and wants to synchronise some of that data to a BigQuery dataset daily for analytics. The data transformations are complex (e.g., aggregations, joins with other sources). Which service should they use to build this pipeline?

A.Datastream with BigQuery as destination

B.Dataflow pipeline using JDBC source and BigQuery sink

C.BigQuery Data Transfer Service for Cloud SQL

D.Cloud Functions triggered by Cloud Scheduler

AnswerB

Dataflow can read from Cloud SQL via JDBC, perform complex transformations, and write to BigQuery.

Why this answer

Option B is correct because Dataflow provides a fully managed, serverless execution environment for Apache Beam pipelines, which can read from Cloud SQL via a JDBC source, perform complex transformations (aggregations, joins with other sources) in a distributed manner, and write the results to BigQuery as a sink. This directly addresses the requirement for complex, daily transformations that are beyond the capabilities of simpler services.

Exam trap

The trap here is that candidates often confuse Datastream's CDC replication (which is for continuous, near-real-time sync without transformations) with the need for a batch ETL pipeline that requires complex transformations, leading them to incorrectly choose Option A.

How to eliminate wrong answers

Option A is wrong because Datastream is designed for continuous, change data capture (CDC) replication to BigQuery, not for executing complex batch transformations like aggregations and joins with other sources. Option C is wrong because BigQuery Data Transfer Service for Cloud SQL only supports one-time or scheduled full table snapshots without any built-in transformation capabilities, so it cannot handle complex aggregations or joins. Option D is wrong because Cloud Functions have a maximum execution timeout of 9 minutes and limited memory, making them unsuitable for processing large volumes of data or performing complex, long-running transformations.

Practice this question →

7

MCQmedium

An organization plans to adopt polyglot persistence: Cloud SQL for transactions, Cloud Bigtable for time-series, and BigQuery for analytics. They need to ensure data consistency when updating both Cloud SQL and Bigtable in a single business transaction. What approach should they use?

A.Use Cloud Spanner for all data to avoid cross-database consistency issues.

B.Implement a saga pattern where each database operation is a local transaction, with compensating actions for failures.

C.Use a two-phase commit protocol across Cloud SQL and Bigtable.

D.Write to Cloud SQL first, then use Cloud Functions to asynchronously write to Bigtable with retries.

AnswerB

The saga pattern is the recommended approach for distributed transactions across polyglot stores; each step has a compensating action to maintain eventual consistency.

Practice this question →

8

MCQeasy

Which Google Cloud database is best suited for high-throughput, low-latency caching to reduce load on a primary database?

A.Cloud SQL

B.Firestore

C.Memorystore

D.Cloud Bigtable

AnswerC

Memorystore provides managed Redis/Memcached for caching.

Why this answer

Memorystore (managed Redis/Memcached) is the caching layer, providing sub-millisecond access times.

Practice this question →

9

MCQeasy

A developer needs to implement caching for a Cloud SQL database to reduce read latency for frequently accessed data. Which Google Cloud service should they use?

A.Cloud Spanner

B.Memorystore for Redis

C.Cloud CDN

D.Cloud Bigtable

AnswerB

Memorystore for Redis is a fully managed in-memory cache that can be used to cache frequent reads from Cloud SQL.

Practice this question →

10

MCQeasy

A financial services company needs to maintain a backup of their Bigtable instance in a different geographic region. They want to restore the backup quickly in case of a regional failure. What should they do?

A.Set up a hot standby Bigtable cluster in another region using replication.

B.Use Cloud SQL cross-region backup copy feature.

C.Create a Bigtable backup and restore it to a cluster in another region.

D.Export the Bigtable data to Cloud Storage and import it into a new cluster.

AnswerC

Bigtable backups are cluster-specific and can be restored to any cluster in the same project, enabling cross-region recovery.

Why this answer

Bigtable backups are designed for exactly this use case: they are full, consistent copies of the table schema and data that can be restored to a different cluster in another region. This approach provides a fast, managed restore without the overhead of maintaining a hot standby or the complexity of export/import pipelines. Option C directly uses the Bigtable backup and restore feature, which is the recommended method for cross-region disaster recovery.

Exam trap

Cisco often tests the distinction between replication (which is intra-region or within an instance) and backup/restore (which is cross-region), leading candidates to mistakenly choose replication as a cross-region solution when it is not supported for that purpose in Bigtable.

How to eliminate wrong answers

Option A is wrong because Bigtable does not support active-active replication across regions; it offers replication only within a single cluster or between clusters in the same instance, not as a hot standby for regional failover. Option B is wrong because Cloud SQL is a different database service (relational) and has no relevance to Bigtable; the question specifically asks about Bigtable, not Cloud SQL. Option D is wrong because exporting to Cloud Storage and importing is a manual, slower process that involves intermediate storage and additional steps, whereas a direct backup and restore is faster and more reliable for quick recovery.

Practice this question →

11

MCQmedium

A company is migrating an Oracle database to AlloyDB for PostgreSQL using Database Migration Service. They have completed a full dump and are now in the CDC phase. They want to test the target database with minimal risk. What should they do?

A.Promote the continuous migration replica to a standalone instance

B.Stop the migration job and promote the replica

C.Create a snapshot of the target instance

D.Use Cloud SQL Auth Proxy to connect

AnswerA

Promotion converts the target to a standalone instance for testing. You can later set up a new migration job to catch up.

Why this answer

Database Migration Service allows creating a connection profile and a migration job. During the CDC phase, you can promote the replica to make the target database writable for testing. After testing, you can resume migration by re-creating the job.

Practice this question →

12

MCQhard

A company uses Cloud SQL for MySQL with automated backups enabled. They want to perform point-in-time recovery (PITR) to recover from an accidental data deletion that occurred 10 minutes ago. What must be configured for PITR to work?

A.Increase the binlog retention period

B.Enable the slow query log

C.Enable automated backups only

D.Create a cross-region replica

AnswerA

The default binlog retention is 7 days, but if the user wants PITR, they must ensure binlog retention covers the desired time window. However, the question says 'must be configured' — the key is that binlog is required. But since binlog is default, the hard part is that the user might have disabled it. Actually, the correct answer is that binlog must be enabled. But given the options, 'Enable binary logging' is not listed. Let's adjust.

Why this answer

PITR in Cloud SQL for MySQL requires binary logging (binlog) to be enabled, which is enabled by default when automated backups are on. The binlog retention period determines how far back PITR can go.

Practice this question →

13

MCQeasy

A company wants to perform cross-cloud analytics, querying data stored in both Google Cloud BigQuery and Amazon S3. Which BigQuery feature enables this?

A.Cloud Data Fusion

B.BigQuery Data Transfer Service

C.BigQuery federated queries

D.BigQuery Omni

AnswerD

BigQuery Omni supports cross-cloud queries.

Why this answer

BigQuery Omni allows querying data across clouds (AWS and Azure) using BigQuery, without moving data.

Practice this question →

14

MCQeasy

A company wants to back up their Cloud Spanner database for disaster recovery. They need a backup that can be restored in a different region. Which backup method should they use?

A.Use Bigtable managed backups

B.Use Cloud SQL export

C.Use gcloud spanner operations backup

D.Use Spanner export to GCS

AnswerD

Spanner export creates a full backup in Avro format in GCS, which can be restored cross-region.

Why this answer

Cloud Spanner supports full database exports to GCS in Avro format. These exports can be restored to any Spanner instance, including in a different region. There are no incremental backups; only full exports.

Practice this question →

15

Multi-Selecthard

An e-commerce platform uses Cloud Spanner for order management and Bigtable for product recommendations. They need to replicate order changes to the Bigtable cluster in real-time for updating recommendations. The team must ensure that all order updates are captured and delivered exactly once, in order, to the Bigtable pipeline. Which THREE components should they use?

Select 3 answers

A.Cloud Spanner Change Streams

B.Cloud Tasks

C.Dataflow

D.Pub/Sub

E.Cloud Functions

AnswersA, C, D

Change streams capture all mutations in a Spanner table and can be sent to Pub/Sub.

Why this answer

Spanner change streams capture all data changes (inserts, updates, deletes) and can publish to Pub/Sub. Dataflow can consume these messages and write to Bigtable with exactly-once processing. Pub/Sub provides ordered delivery when using message ordering.

Cloud Tasks is not suitable for high-throughput streaming. Cloud Functions would be too slow and less reliable for exactly-once. BigQuery is not needed.

Practice this question →

16

Multi-Selectmedium

A company wants to query data across Cloud SQL (MySQL) and BigQuery using federated queries. They want to avoid data movement. Which TWO components must be set up?

Select 2 answers

A.External table in BigQuery

B.Cloud SQL instance

C.Cloud Storage bucket

D.BigQuery connection

E.Dataflow pipeline

AnswersA, D

Allows querying the Cloud SQL data from BigQuery.

Why this answer

A BigQuery connection (external data source) is required to link to Cloud SQL. An external table in BigQuery references the Cloud SQL table for querying. A Cloud SQL instance is the source, but the connection and external table are the components set up in BigQuery.

Practice this question →

17

Multi-Selectmedium

A company uses Cloud Spanner for a global database and needs to export a full backup to GCS for long-term archival and compliance. Which THREE statements are true about Cloud Spanner backups? (Choose 3 options.)

Select 3 answers

A.Backups can be created on demand or via a scheduled policy

B.Incremental backups are supported to reduce storage costs

C.Backups are automatically replicated across regions

D.Backups are stored in Avro format in Cloud Storage

E.Backups can be restored to a different Spanner instance

AnswersA, D, E

Spanner supports both on-demand and scheduled backups.

Why this answer

Option A is correct because Cloud Spanner supports both on-demand backups (created manually via the console, gcloud CLI, or API) and scheduled backup policies that automate backup creation at defined intervals. This flexibility allows administrators to meet compliance requirements without manual intervention.

Exam trap

Cisco often tests the misconception that Cloud Spanner supports incremental backups (like many relational databases) or that backups are automatically geo-replicated, when in fact backups are full and stored only in the instance's location unless explicitly copied.

Practice this question →

18

MCQmedium

A company is migrating from on-premises SQL Server to Cloud SQL SQL Server using Database Migration Service (DMS). During the continuous migration phase, they notice that the replication lag is increasing. What is the most likely cause?

A.The DMS migration job is not using a source read replica.

B.The target Cloud SQL instance is not using Premium tier.

C.Large transactions on the source database are causing CDC to fall behind.

D.The source database has a low transaction log retention period.

AnswerC

Large transactions generate many log records that can overwhelm CDC replication, increasing lag.

Why this answer

Option C is correct because Database Migration Service (DMS) uses Change Data Capture (CDC) to replicate ongoing changes from the source SQL Server to the target Cloud SQL instance. Large transactions on the source database generate a high volume of log records that the CDC reader must process sequentially. If the transaction volume exceeds the throughput capacity of the DMS replication slot, the lag between the source and target increases, causing the replication lag to grow.

Exam trap

Cisco often tests the misconception that replication lag is caused by target-side performance issues (like tier or read replicas), when in fact the bottleneck is almost always the source-side CDC capture rate, especially during large transactions.

How to eliminate wrong answers

Option A is wrong because DMS does not require a source read replica for CDC-based continuous migration; it reads directly from the source transaction log. Option B is wrong because the Cloud SQL tier (Premium vs. Standard) affects instance availability and performance features, but replication lag during DMS migration is primarily limited by the CDC processing rate, not the target tier.

Option D is wrong because a low transaction log retention period would cause log truncation before DMS can read it, leading to data loss or migration failure, not an increasing replication lag.

Practice this question →

19

MCQmedium

A company uses Cloud Bigtable for time-series data. They want to enable disaster recovery with the ability to fail over to another region in minutes. What feature should they enable?

A.Export tables to Cloud Storage and import into another Bigtable instance.

B.Enable Bigtable replication across regions.

C.Configure Bigtable backups and restore in another region.

D.Use BigQuery federated queries to access Bigtable data from another region.

AnswerB

Replication provides near real-time data availability in another region for rapid failover.

Why this answer

Bigtable replication allows you to have multiple clusters in different regions, with automatic replication of data. You can fail over by redirecting traffic to the other cluster. This meets the RTO of minutes.

Practice this question →

20

MCQmedium

A company needs to back up their Cloud Bigtable instance for disaster recovery across regions. They want to restore to a different cluster in a different region. What should they use?

A.Use Bigtable managed backups and restore to a different cluster

B.Export tables to Avro in GCS and import in another region

C.Use gcloud bigtable instances create with replication

D.Use Cloud Scheduler to copy tables via Dataflow

AnswerA

Managed backups support cross-cluster and cross-region restore.

Why this answer

Bigtable managed backups are cluster-level backups that can be restored to a different cluster, including cross-region, provided the restore is to an instance in the same project.

Practice this question →

21

MCQmedium

Your team needs to query data across Cloud SQL (MySQL), Cloud Storage (CSV files), and Bigtable using a single SQL query without moving any data. Which Google Cloud feature enables this?

A.BigQuery Omni

B.Cloud Spanner federated queries

C.Datastream

D.BigQuery federated queries

AnswerD

Federated queries in BigQuery allow querying external data sources without loading.

Why this answer

BigQuery federated queries allow querying data in Cloud SQL, Cloud Storage, Bigtable, and other sources externally via the EXTERNAL_QUERY or table definitions.

Practice this question →

22

MCQeasy

A developer needs to query data from Cloud Spanner and Bigtable together in a single SQL statement without moving data. Which Google Cloud feature allows this?

A.Spanner change streams

B.BigQuery Omni

C.Cloud SQL external tables

D.Federated queries

AnswerD

BigQuery federated queries can query Cloud Spanner, Bigtable, and Cloud SQL directly.

Why this answer

BigQuery federated queries allow querying external data sources like Cloud Spanner and Bigtable directly from BigQuery using SQL, without importing data.

Practice this question →

23

MCQmedium

A global e-commerce company uses Cloud Spanner for transactional data. They need to stream real-time order changes to a BigQuery table for analytics. Which approach meets the requirement with minimal latency and operational overhead?

A.Create a Cloud Function that queries Spanner every minute and writes new records to BigQuery.

B.Use Cloud Scheduler to run a daily export of Spanner table to Cloud Storage, then load into BigQuery.

C.Use Spanner change streams to capture changes, publish to Pub/Sub, and use Dataflow to write to BigQuery.

D.Configure a Datastream stream from Spanner to BigQuery.

AnswerC

Spanner change streams + Pub/Sub + Dataflow is the correct architecture for real-time streaming of Spanner changes to BigQuery.

Why this answer

Cloud Spanner change streams capture incremental changes (inserts, updates, deletes) and can be read via Pub/Sub. A Dataflow pipeline can then write these changes to BigQuery in near real-time. This is the recommended pattern for streaming Spanner changes to BigQuery.

Practice this question →

24

MCQmedium

A company is migrating an on-premises PostgreSQL database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). They need to minimize downtime and keep the on-premises database available for reads during migration. The migration plan includes a full dump followed by continuous change data capture (CDC). Which method should they use to validate the migrated data before cutting over?

A.Run the migration job a second time in parallel and compare the data manually.

B.Stop the Database Migration Service job and promote the source Cloud SQL instance.

C.Promote the Cloud SQL replica to a standalone instance for testing; if the data is correct, stop the on-premises database and update the application connection string.

D.Modify the promoted replica's database flags to match the source and then run a consistency check.

AnswerC

Promoting the replica allows you to test the migrated data without affecting the source. You can continue CDC replication until cutover.

Why this answer

Option C is correct because promoting the Cloud SQL read replica to a standalone instance allows you to validate the migrated data in isolation without affecting the ongoing CDC replication. This method minimizes downtime by keeping the on-premises database available for reads and only cutting over after verification, which aligns with the requirement for a low-downtime migration using Database Migration Service.

Exam trap

Cisco often tests the misconception that you must stop the DMS job or modify database flags before validation, when in fact promoting the replica is the standard low-downtime validation step that preserves CDC continuity until cutover.

How to eliminate wrong answers

Option A is wrong because running a second migration job in parallel would double the load on the source database and CDC stream, risking performance degradation and data inconsistency, and manual comparison is error-prone and not a validated method for DMS. Option B is wrong because stopping the DMS job and promoting the source Cloud SQL instance would interrupt CDC and potentially lose unapplied changes, and the source Cloud SQL instance is not the target; the promoted replica is the target for validation. Option D is wrong because modifying database flags on the promoted replica is unnecessary for validation and could introduce configuration drift; consistency checks are typically run after promotion using tools like pg_dump or pg_checksums, not by altering flags.

Practice this question →

25

MCQhard

A financial services company is architecting a multi-database solution. They need strong consistency across Cloud Spanner and Cloud SQL for a critical transaction flow. However, two-phase commit (2PC) across heterogeneous databases is not supported. Which pattern should they adopt to maintain data integrity?

A.Use Cloud Spanner change streams to sync data to Cloud SQL

B.Eventual consistency with conflict resolution

C.Migrate all data to Cloud Spanner to avoid cross-database transactions

D.Saga pattern with orchestration and compensating transactions

AnswerD

Saga pattern coordinates distributed transactions and provides consistency via compensations.

Why this answer

The Saga pattern with orchestration and compensating transactions is correct because it maintains data integrity across heterogeneous databases like Cloud Spanner and Cloud SQL without relying on distributed transactions (2PC). In this pattern, each local transaction commits independently, and if a subsequent transaction fails, a compensating transaction is executed to undo the previous committed changes, ensuring eventual consistency and business-level rollback.

Exam trap

The trap here is that candidates assume change streams or eventual consistency can substitute for strong consistency, but Cisco tests the understanding that only a saga with compensating transactions can provide business-level atomicity across unsupported heterogeneous databases.

How to eliminate wrong answers

Option A is wrong because Cloud Spanner change streams are designed for real-time replication and analytics, not for maintaining strong transactional consistency across heterogeneous databases; they introduce latency and cannot guarantee atomicity across Cloud Spanner and Cloud SQL. Option B is wrong because eventual consistency with conflict resolution does not meet the requirement for strong consistency in a critical transaction flow; it allows temporary data divergence that could violate business rules. Option C is wrong because migrating all data to Cloud Spanner avoids the cross-database problem but is not a pattern for managing a multi-database solution; the question explicitly asks for a pattern to adopt while keeping both databases.

Practice this question →

26

Multi-Selectmedium

A company needs to migrate an on-premises PostgreSQL database to Cloud SQL for PostgreSQL with near-zero downtime. Which TWO features of Database Migration Service (DMS) should they use?

Select 2 answers

A.Dataflow templates

B.Connection profiles

C.Continuous migration with CDC

D.Full dump only

E.One-time migration

AnswersB, C

Required to define source and target for the migration job.

Why this answer

Continuous migration with CDC allows near-zero downtime by capturing ongoing changes after the initial dump. Connection profiles define source and target endpoints. A one-time dump would cause downtime.

Continuous migration includes CDC.

Practice this question →

27

MCQmedium

A retail company uses Cloud Spanner as its global transactional database. They need to capture all data changes (inserts, updates, deletes) from specific tables and stream them to a Pub/Sub topic for real-time downstream processing. What Google Cloud feature should they use?

A.Create a Dataflow pipeline that reads from Spanner using JDBC

B.Use Cloud Functions to poll the Spanner tables for changes every minute

C.Enable Cloud Spanner change streams on the tables and configure them to write to Pub/Sub

D.Export the Spanner tables to Avro files in GCS and use BigQuery Change Data Capture

AnswerC

Change streams capture all DML changes and can be set up to stream to Pub/Sub for downstream use.

Why this answer

Option C is correct because Cloud Spanner change streams provide a native, fully managed, and low-latency mechanism to capture row-level changes (inserts, updates, deletes) from Spanner tables. These change streams can be directly configured to write to a Pub/Sub topic via a Dataflow template or a custom pipeline, enabling real-time streaming without polling or external tools.

Exam trap

Cisco often tests the distinction between batch export/import methods (like Avro exports or JDBC reads) and native streaming change data capture (like Spanner change streams), leading candidates to choose familiar but incorrect batch-oriented options.

How to eliminate wrong answers

Option A is wrong because using a Dataflow pipeline with JDBC to read from Spanner is a batch-oriented approach that does not capture real-time change data; it would require periodic full or incremental scans, which is inefficient and not a streaming solution. Option B is wrong because polling Spanner tables every minute with Cloud Functions introduces latency, is not real-time, and can cause excessive read load on Spanner, violating the requirement for continuous change capture. Option D is wrong because exporting Spanner tables to Avro files in GCS is a batch export operation, not a streaming change data capture mechanism; BigQuery Change Data Capture (CDC) applies to BigQuery tables, not to streaming Spanner changes into Pub/Sub.

Practice this question →

28

MCQmedium

You are designing a polyglot persistence architecture for an IoT platform. Device telemetry is stored in Cloud Bigtable for ingestion and low-latency queries. When a device registers a high-priority alert, you need to trigger an email notification. What is the recommended approach to decouple the alert processing from Bigtable?

A.Use the Bigtable change streams feature (currently in preview) to push alerts to Pub/Sub, then a Cloud Function sends the email.

B.Enable Bigtable replication and set up a trigger in the replica.

C.Write a Dataflow pipeline that reads from Bigtable and writes to Cloud Storage.

D.Create a scheduled Cloud Function that polls Bigtable every minute for new alerts.

AnswerA

Bigtable change streams (preview) allow streaming changes to Pub/Sub for real-time processing.

Why this answer

Bigtable does not have built-in change data capture. A common pattern is to write an application that, upon detecting an alert, publishes a message to Pub/Sub. A Cloud Function subscribed to that topic can then send the email.

This decouples processing from the database.

Practice this question →

29

MCQmedium

An organization is migrating an on-premises PostgreSQL database to Cloud SQL. They need minimal downtime and want to use Database Migration Service (DMS) with continuous change data capture (CDC). What is the correct sequence of steps?

A.Create connection profile → start migration job with full dump → CDC phase → promote replica

B.Create connection profile → start full dump → promote to primary

C.Start CDC directly without full dump → promote replica

D.Promote replica immediately after creating connection profile

AnswerA

Correct order for continuous migration with DMS.

Why this answer

DMS first creates a connection profile, then starts a migration job performing a full dump, then transitions to CDC, and finally promotes the replica to complete the cutover.

Practice this question →

30

Multi-Selectmedium

Which TWO Google Cloud services can be used to build a data pipeline that transforms and moves data between different databases? (Select 2)

Select 2 answers

A.Dataflow

B.Cloud Scheduler

C.Dataproc

D.Memorystore

E.Cloud SQL Proxy

AnswersA, C

Dataflow can perform complex transformations between databases.

Why this answer

Dataflow is a serverless, fully managed service for executing Apache Beam pipelines, which can read from and write to various databases (e.g., Cloud Spanner, BigQuery, Cloud SQL) while performing transformations in a unified streaming or batch model. It is specifically designed for data movement and transformation between different data sources and sinks, making it a correct choice for building a data pipeline that transforms and moves data between databases.

Exam trap

Cisco often tests the distinction between services that are purely for connectivity or scheduling (Cloud Scheduler, Cloud SQL Proxy) versus actual data processing engines (Dataflow, Dataproc), and candidates mistakenly select Cloud SQL Proxy thinking it moves data because it 'connects' databases.

Practice this question →

31

Multi-Selectmedium

A company is designing a polyglot persistence architecture. They need to store (1) customer profiles with complex relationships and ACID transactions, (2) high-volume time-series IoT sensor data, and (3) interactive analytics dashboards. Which TWO Google Cloud databases should they choose for these workloads? (Choose 2 options.)

Select 2 answers

A.BigQuery

B.Cloud SQL

C.Cloud Bigtable

D.Firestore

E.Cloud Memorystore

AnswersB, C

Cloud SQL provides ACID transactions for relational data.

Why this answer

Cloud SQL (or Spanner) for relational ACID, Bigtable for time-series, BigQuery for analytics. The question asks for two, but three are mentioned; the best pair for the first two requirements is Cloud SQL and Bigtable. However, since it asks for TWO, we select Cloud SQL for transactions and Bigtable for time-series.

Practice this question →

32

MCQmedium

A financial services company is migrating a critical PostgreSQL database to AlloyDB using Database Migration Service (DMS). They want to minimize downtime by using continuous change data capture (CDC). After the initial full dump, what phase must be completed before promoting the replica to primary?

A.Perform a final manual sync

B.Take a new full dump

C.Delete all existing data in AlloyDB

D.Complete the CDC phase

AnswerD

CDC phase must complete and the replica must be up-to-date before promotion.

Why this answer

DMS provides a CDC phase that continuously replicates changes from the source to the destination. Only after the replica catches up and the application can be stopped can you promote the replica. The full dump is the first step, then CDC ensures consistency.

Practice this question →

33

MCQeasy

A company needs to store petabytes of time-series IoT sensor data and query it with single-digit millisecond latency at millions of reads per second. The data has a simple key-value structure with timestamps. Which Google Cloud database is MOST appropriate?

A.Cloud Bigtable

B.Cloud Spanner

C.Firestore

D.BigQuery

AnswerA

Bigtable is the correct choice: wide-column NoSQL, designed for time-series and IoT workloads, single-digit ms latency, and scales to millions of QPS with additional nodes.

Why this answer

Cloud Bigtable is a fully managed, scalable NoSQL database designed for large analytical and operational workloads, handling petabytes of data with consistent single-digit millisecond latency at high throughput. Its key-value and wide-column architecture, combined with native time-series optimization via row key design (e.g., inverted timestamps), makes it the ideal choice for IoT sensor data requiring millions of reads per second.

Exam trap

Cisco often tests the misconception that Cloud Spanner is the universal solution for any high-throughput database need, but candidates must recognize that Spanner's relational model and global consistency overhead make it unsuitable for simple key-value time-series workloads at petabyte scale with millions of reads per second.

How to eliminate wrong answers

Option B (Cloud Spanner) is wrong because it is a globally distributed relational database with strong consistency and SQL support, optimized for transactional workloads rather than high-throughput time-series key-value access; its latency and cost profile are not suited for millions of reads per second on petabyte-scale IoT data. Option C (Firestore) is wrong because it is a mobile and web document database with limited throughput (up to 10,000 writes/second per database) and is not designed for petabyte-scale time-series data or single-digit millisecond latency at millions of reads per second. Option D (BigQuery) is wrong because it is a serverless data warehouse optimized for analytical SQL queries on large datasets, not for real-time key-value lookups with single-digit millisecond latency; it typically incurs seconds of latency for interactive queries.

Practice this question →

34

MCQmedium

A company uses Cloud Bigtable for time-series data and wants backups that can be restored in a different region for disaster recovery. Which backup method meets this requirement?

A.Use Bigtable managed backups, which are stored in the same region and can be restored to any cluster

B.Export tables to Avro files in GCS, then import in the new region

C.Enable replication between Bigtable clusters

D.Use BigQuery federated queries to export data to GCS

AnswerA

Managed backups can be restored to a different region via cross-cluster restore.

Why this answer

Bigtable managed backups are cluster-level and support cross-cluster restore, including to a different region.

Practice this question →

35

Multi-Selecthard

A company is migrating a PostgreSQL database to AlloyDB using Database Migration Service. They need to ensure the migration has minimal downtime and can be tested before cutover. Which THREE steps should they include in their migration plan?

Select 3 answers

A.Create a migration job with 'Full dump + CDC' to enable continuous replication.

B.Enable logical replication on the source PostgreSQL database.

C.Test the migration by promoting a replica in a non-production environment before final cutover.

D.Create a connection profile for the source PostgreSQL database.

E.Use pg_dump to take a manual backup and restore it to AlloyDB before setting up DMS.

AnswersA, B, D

Full dump + CDC provides continuous replication for minimal downtime.

Practice this question →

36

MCQmedium

A retail company wants to run analytics queries across their Cloud SQL PostgreSQL database and BigQuery without moving data. They need to join sales data from Cloud SQL with customer demographics in BigQuery. Which approach should they use?

A.Use BigQuery Omni to query Cloud SQL

B.Create a BigQuery external table linked to Cloud SQL

C.Use Datastream to replicate Cloud SQL to BigQuery

D.Export Cloud SQL data to GCS and load into BigQuery

AnswerB

BigQuery federated queries allow external tables for Cloud SQL.

Why this answer

BigQuery federated queries can create an external table that references Cloud SQL PostgreSQL. This allows querying Cloud SQL data directly from BigQuery and joining with BigQuery tables.

Practice this question →

37

Multi-Selecthard

A company uses Datastream to replicate changes from an on-premises Oracle database to BigQuery. They need to also send the same change events to a custom application for real-time processing. Which TWO actions should they take? (Choose 2)

Select 2 answers

A.Configure Datastream to write to a Pub/Sub topic

B.Use Datastream to write to Cloud Bigtable

C.Set up a Cloud Function to read from BigQuery and forward to the application

D.Use Dataflow to read from GCS and publish to Pub/Sub

E.Create a Pub/Sub subscription for the application to consume

AnswersA, E

Datastream can publish CDC events directly to Pub/Sub.

Why this answer

Datastream can write to Pub/Sub, which then can be consumed by the application. Alternatively, Datastream can write to GCS (Avro/JSON) and then Pub/Sub or Dataflow can be used. The direct approach is to stream to Pub/Sub.

Practice this question →

38

MCQmedium

You need to continuously replicate change data from an on-premises Oracle database to BigQuery for real-time analytics. Which Google Cloud service is designed specifically for this purpose?

A.Database Migration Service (DMS)

B.Cloud Dataproc

C.Datastream

D.Dataflow

AnswerC

Datastream is built for serverless CDC to BigQuery and other targets.

Why this answer

Datastream is a Google Cloud serverless change data capture (CDC) and replication service specifically designed to continuously replicate data from sources like Oracle databases to BigQuery. It handles schema drift, supports log-based CDC, and provides low-latency streaming, making it the correct choice for real-time analytics.

Exam trap

The trap here is that candidates often confuse Dataflow's general-purpose stream processing capabilities with Datastream's purpose-built CDC replication, leading them to choose Dataflow when the question explicitly asks for a service 'designed specifically for this purpose.'

How to eliminate wrong answers

Option A is wrong because Database Migration Service (DMS) is designed for one-time or bulk migrations, not continuous replication of change data for real-time analytics. Option B is wrong because Cloud Dataproc is a managed Spark/Hadoop service for batch and stream processing, not a purpose-built CDC replication tool for Oracle to BigQuery. Option D is wrong because Dataflow is a unified stream and batch processing service that can be used for CDC but requires custom pipeline development and is not a dedicated, out-of-the-box replication service like Datastream.

Practice this question →

39

Multi-Selecteasy

A company wants to query data across Cloud SQL, Cloud Spanner, and Bigtable without moving data. They need a solution that supports standard SQL and integrates with their existing business intelligence tools. Which TWO Google Cloud capabilities should they use?

Select 2 answers

A.BigQuery Omni

B.BigQuery federated queries

C.Datastream

D.Dataflow

E.Cloud SQL cross-database queries

AnswersA, B

BigQuery Omni supports federated queries across AWS S3 and Azure Blob Storage, but for GCP databases, standard federated queries suffice. However, Omni is a valid answer if considering cross-cloud.

Why this answer

BigQuery federated queries allow querying Cloud SQL, Cloud Spanner, and Bigtable directly using SQL without data movement. BigQuery Omni extends this to multicloud environments. Cloud SQL cross-database queries are limited to within Cloud SQL.

Dataflow would require moving data. Cloud Composer is for orchestration.

Practice this question →

40

Multi-Selecthard

A company uses Cloud Spanner for a globally distributed application. They need to capture all changes from a Spanner table and send them to a BigQuery dataset for real-time analytics. Which THREE Google Cloud services or features should they use?

Select 3 answers

A.Dataflow

B.Spanner change streams

C.Datastream

D.Cloud Functions

E.BigQuery

AnswersA, B, E

Processes change stream data and writes to BigQuery.

Why this answer

Spanner change streams capture row-level changes. Dataflow can read from change streams and write to BigQuery. Pub/Sub can be an intermediary but is not required; Dataflow can directly write to BigQuery.

However, the typical architecture uses Pub/Sub for decoupling. The question expects the three core components: change streams, Dataflow, and BigQuery.

Practice this question →

41

MCQhard

A company has a globally distributed application using Cloud Spanner. They need to backup the database for compliance purposes and restore it in a different region if needed. Which backup method should they use?

A.Use Bigtable managed backups for Spanner.

B.Use Cloud SQL automated backups and cross-region copy.

C.Export the Spanner database to Cloud Storage in Avro format using the console or gcloud.

D.Use Spanner incremental backups to save only changes since the last full backup.

AnswerC

Spanner's built-in export creates a full backup in Avro format in GCS, which can be imported into another region.

Why this answer

Cloud Spanner does not support native managed backups or incremental backups. The correct method to create a backup for compliance and cross-region restore is to export the database to Cloud Storage in Avro format using the console or gcloud. This export can then be imported into a new Spanner instance in a different region, meeting the disaster recovery requirement.

Exam trap

The trap here is that candidates confuse Cloud Spanner with other managed database services like Cloud SQL or Bigtable, assuming they share backup features such as automated backups, cross-region replication, or incremental backups, when in fact Spanner only supports full database exports to Avro in Cloud Storage.

How to eliminate wrong answers

Option A is wrong because Bigtable managed backups are for Cloud Bigtable, not Cloud Spanner; these are entirely different database services with incompatible backup formats. Option B is wrong because Cloud SQL automated backups and cross-region copy apply to Cloud SQL (MySQL, PostgreSQL, SQL Server), not to Cloud Spanner, which has its own export/import mechanism. Option D is wrong because Cloud Spanner does not support incremental backups; it only supports full database exports via the console, gcloud, or client libraries.

Practice this question →

42

MCQmedium

A company has an Oracle database and wants to migrate to Cloud SQL for PostgreSQL using Database Migration Service. They set up a connection profile and a continuous migration job. After the initial load, the CDC phase begins. Suddenly, the source database has a schema change (adding a column). What happens?

A.The CDC phase continues to replicate DML but may fail if the column is required

B.The migration job automatically skips the new column

C.The migration job pauses and asks for manual intervention

D.The schema change is automatically replicated to Cloud SQL

AnswerA

DMS replicates DML, but if the DDL adds a NOT NULL column, DML may fail. Manual remediation is needed.

Why this answer

DMS does not automatically replicate DDL changes. The column would be added to the source but not to the destination, potentially causing the CDC to fail due to data type mismatches.

Practice this question →

43

Multi-Selecthard

A company is migrating an Oracle database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). During the full dump phase, the migration fails with an error stating that the source database user does not have sufficient privileges. Which THREE privileges are required for the DMS user on the Oracle source? (Choose three.)

Select 3 answers

A.CREATE SESSION

B.EXECUTE on DBMS_FLASHBACK

C.CREATE TABLE

D.SELECT on V$LOG, V$LOGFILE, V$DATABASE

E.SELECT ANY TABLE

AnswersB, D, E

Required for consistent snapshot export.

Why this answer

Option B is correct because Database Migration Service (DMS) for Oracle to Cloud SQL for PostgreSQL uses Oracle Flashback technology to capture consistent change data during the migration. The DMS user must have the EXECUTE privilege on the DBMS_FLASHBACK package to enable Flashback Query operations, which are essential for reading the source database in a transactionally consistent state without blocking writes.

Exam trap

Cisco often tests the misconception that only SELECT ANY TABLE and basic session privileges are sufficient, but candidates forget that DMS requires specific system view access and the DBMS_FLASHBACK package execution privilege for consistent snapshot and CDC operations.

Practice this question →

44

MCQeasy

A company needs to perform complex transformations and join data from Cloud SQL, Cloud Storage, and Pub/Sub to load into BigQuery. Which Google Cloud service is designed for this ETL/ELT workload?

A.Cloud Functions

B.Cloud Run

C.Dataproc

D.Dataflow

AnswerD

Dataflow is a fully managed, serverless service for stream and batch data processing, ideal for complex ETL across databases, storage, and streaming.

Practice this question →

45

MCQhard

An organization has Cloud Bigtable for real-time ad serving and BigQuery for analytics. They want to synchronize data changes from Bigtable to BigQuery every hour with a Dataflow pipeline. However, they notice that some updates are missed. What is the most likely cause?

A.The Dataflow pipeline reads from Bigtable using a snapshot read

B.Bigtable does not support change data capture natively

C.The Bigtable table has no primary key

D.The Dataflow pipeline is using the wrong sink

AnswerB

Without change streams, Dataflow cannot see intermediate updates; only the latest state is visible.

Why this answer

Bigtable does not have built-in change data capture (CDC) like some databases. Dataflow can read Bigtable snapshots but not incremental changes unless using Dataflow's streaming insert, which is not native. The common approach is to use Bigtable replication or export, but missed updates often occur because Bigtable does not log changes.

A custom solution using Cloud Bigtable change streams (beta) or using a separate logging table is needed.

Practice this question →

46

MCQhard

A company is migrating an on-premises PostgreSQL database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). During the continuous migration phase, the source database has high write throughput, and the DMS job is falling behind. The replication lag is increasing over time. What should the engineer do to reduce lag?

A.Change the source database to use synchronous replication with DMS

B.Reduce the maximum WAL size (max_wal_size) on the source to generate smaller logs

C.Increase the wal_keep_segments parameter on the source and enable parallel apply on the destination Cloud SQL instance

D.Increase the maintenance_work_mem parameter on the source database

AnswerC

Higher wal_keep_segments retains more WAL for DMS to read; parallel apply speeds up replication on the destination.

Why this answer

Option C is correct because increasing wal_keep_segments on the source ensures that more WAL segments are retained, preventing DMS from failing to fetch required logs due to premature cleanup. Enabling parallel apply on the Cloud SQL destination allows multiple transactions to be applied concurrently, reducing the time needed to catch up with the source's high write throughput.

Exam trap

The trap here is that candidates may confuse WAL-related parameters (max_wal_size vs. wal_keep_segments) or assume that increasing maintenance memory or changing replication mode can fix replication lag, when the real solution involves retaining more WAL on the source and applying changes faster on the destination.

How to eliminate wrong answers

Option A is wrong because DMS uses logical replication, not synchronous replication; changing to synchronous replication would require modifying the source's replication mode, which is not supported by DMS and would increase latency on the source. Option B is wrong because reducing max_wal_size would cause more frequent WAL segment switches and potential premature removal of segments, worsening replication lag rather than reducing it. Option D is wrong because maintenance_work_mem affects maintenance operations like VACUUM and index creation, not replication throughput or WAL handling.

Practice this question →

47

MCQhard

You are designing a cross-database solution where Cloud Spanner is the source of truth for transactional data. You need to stream all changes from Spanner to BigQuery for near-real-time analytics. Which approach should you use?

A.Enable Spanner change streams and read directly via Dataflow into BigQuery

B.Set up a trigger in Spanner to call a Cloud Function that inserts into BigQuery

C.Configure Datastream to connect to Spanner and replicate to BigQuery

D.Use Cloud Scheduler to periodically query Spanner for new rows and insert into BigQuery

AnswerA

Spanner change streams are designed to expose changes; Dataflow can stream them into BigQuery.

Why this answer

Spanner change streams capture row-level changes and can be routed through Pub/Sub to a Dataflow pipeline that writes to BigQuery.

Practice this question →

48

Multi-Selectmedium

A company is designing a polyglot persistence architecture. They need to use Cloud SQL for transactions, Bigtable for real-time analytics, and BigQuery for reporting. They also need to keep data across these systems eventually consistent. Which TWO approaches should they use?

Select 2 answers

A.Implement a saga pattern with compensating transactions for each write.

B.Use two-phase commit across all databases.

C.Use Cloud Spanner as a single database to avoid polyglot complexity.

D.Write to all three databases in a single transaction using distributed transactions.

E.Write to Cloud SQL and use Datastream to replicate changes to Bigtable and BigQuery.

AnswersA, E

Saga pattern is a standard approach for eventual consistency across polyglot stores.

Practice this question →

49

MCQmedium

You need to migrate an on-premises MySQL 5.7 database (2 TB) to Cloud SQL for MySQL with minimal downtime. Database Migration Service (DMS) is chosen. What is the correct sequence of steps to ensure a successful continuous migration?

A.Set up a connection profile for the source, create a DMS migration job (full dump + CDC), monitor the initial dump, then promote the replica to complete migration.

B.Use mysqldump to export the database, import to Cloud SQL, then set up DMS for CDC only.

C.Create a DMS continuous migration job directly without a connection profile.

D.First promote the Cloud SQL replica, then create the connection profile.

AnswerA

This is the correct sequence for DMS continuous migration.

Why this answer

DMS continuous migration first performs a full dump (initial snapshot), then switches to CDC to replicate ongoing changes. After the initial dump, you validate the replica and promote it to make it the primary. The correct order: create connection profile for source, create migration job with full dump + CDC, monitor initial dump, then promote when ready.

Practice this question →

50

MCQhard

You are migrating an on-premises Oracle database to Cloud SQL for PostgreSQL. You need to assess the migration feasibility and convert the schema. Which tools should you use?

A.Use mysqldump to export and import to PostgreSQL.

B.Use Ora2Pg for schema conversion and DMS for data migration.

C.Use pg_dump to export the Oracle database and import into Cloud SQL.

D.Use DMS directly with Oracle source; it automatically converts schema.

AnswerB

Ora2Pg converts Oracle schema to PostgreSQL; DMS performs the data migration with CDC.

Why this answer

Ora2Pg is an open-source tool that converts Oracle schema to PostgreSQL. Database Migration Service (DMS) supports migration from Oracle to Cloud SQL for PostgreSQL. For assessment, you can use tools like Oracle Migration Toolkit or Ora2Pg's assessment mode.

Practice this question →

51

MCQhard

A team is using Datastream to replicate from MySQL to BigQuery. They notice that the BigQuery table is missing some updates that occurred in the source. Which is the most likely cause?

A.BigQuery does not support streaming inserts from Datastream

B.The Datastream connection profile uses read replicas that are lagging

C.The source MySQL binary log retention period is too short, causing log truncation before Datastream reads the changes

D.Cloud SQL does not support MySQL

AnswerC

If binlogs are purged before Datastream processes them, updates are lost.

Why this answer

Datastream uses transaction logs and may skip events if the source binary logs are not retained long enough, or if there is a schema mismatch.

Practice this question →

52

MCQmedium

A corporation needs to back up its Cloud Spanner database for disaster recovery. They require the ability to restore to a specific point in time within the last 7 days. What backup strategy should they implement?

A.Use Cloud Scheduler to run incremental backups daily.

B.Enable cross-region replicas and restore from the replica.

C.Export the database to Cloud Storage every hour using Dataflow.

D.Use Spanner's built-in point-in-time recovery (PITR) which retains versions for 7 days.

AnswerD

Spanner PITR allows you to query or restore data as of any time within the retention window (1-7 days).

Why this answer

Cloud Spanner supports full database backups exported to Avro in Cloud Storage. Incremental backups are not supported natively; point-in-time recovery is achieved via versioning (up to 7 days) but backups are full. For granular recovery, you can use the built-in versioning or schedule frequent exports.

Practice this question →

53

MCQmedium

A company uses Cloud Spanner for its global financial application. They want to capture all changes to a Spanner table and stream them to Pub/Sub for downstream processing by a Dataflow pipeline. What is the recommended approach?

A.Configure Pub/Sub Lite to directly connect to Spanner change streams.

B.Use a Cloud Function to query the Spanner table every minute and publish changes to Pub/Sub.

C.Create a Spanner change stream and use Dataflow to read from the change stream and publish to Pub/Sub.

D.Enable Cloud SQL change data capture on the Spanner table and push changes to Pub/Sub.

AnswerC

This is the recommended architecture: Spanner change streams feed into Dataflow, which can write to Pub/Sub.

Why this answer

Option C is correct because Spanner change streams are the native, built-in mechanism for capturing row-level changes in Cloud Spanner. Dataflow can directly read from a Spanner change stream using the Spanner change streams connector, and then publish the changes to Pub/Sub for downstream processing. This approach is fully managed, scalable, and avoids the latency and consistency issues of polling or external CDC tools.

Exam trap

Cisco often tests the distinction between native Spanner change streams and external CDC tools; the trap here is assuming that Cloud SQL's CDC feature can be applied to Spanner, or that a simple polling function is sufficient for reliable change capture.

How to eliminate wrong answers

Option A is wrong because Pub/Sub Lite does not have a direct integration with Spanner change streams; it is a separate messaging service and cannot connect to Spanner change streams without an intermediary like Dataflow. Option B is wrong because polling the Spanner table every minute with a Cloud Function is inefficient, introduces latency, and cannot reliably capture all changes (e.g., deletes or in-flight transactions) without complex logic. Option D is wrong because Cloud SQL change data capture is a feature of Cloud SQL (MySQL/PostgreSQL), not Cloud Spanner; Spanner uses its own change stream API, not CDC from Cloud SQL.

Practice this question →

54

MCQeasy

A company wants to run analytical queries across data stored in Cloud SQL (MySQL), Cloud Storage (Parquet files), and Bigtable without moving any data. Which BigQuery feature enables this?

A.BigQuery Omni

B.Cloud Data Fusion

C.BigQuery BI Engine

D.Federated queries using external tables

AnswerD

BigQuery federated queries allow querying Cloud SQL, Cloud Storage, and Bigtable directly using external tables without data movement.

Practice this question →

55

MCQmedium

A company uses a polyglot persistence architecture: Cloud SQL for transactions, Bigtable for real-time analytics, and BigQuery for reporting. They need to synchronize data from Cloud SQL to Bigtable in near real-time. Which combination of services should they use?

A.Dataflow + Cloud SQL

B.Cloud Pub/Sub + Cloud Functions

C.Datastream + Dataflow

D.Cloud Functions + BigQuery

AnswerC

Datastream captures CDC and sends to Pub/Sub; Dataflow processes and writes to Bigtable.

Why this answer

Datastream can capture CDC from Cloud SQL (MySQL/PostgreSQL) and publish to Pub/Sub. Dataflow can then read from Pub/Sub and write to Bigtable. This provides near real-time sync.

Practice this question →

56

MCQhard

A company is migrating a 2 TB Oracle database to AlloyDB for PostgreSQL using Oracle to PostgreSQL migration tool (Ora2Pg). The migration must have minimal downtime. The team plans to use a two-phase approach: first a full dump, then incremental CDC. However, Ora2Pg does not natively support CDC. How should they achieve near-zero downtime migration?

A.Use Database Migration Service (DMS) with Oracle as source and AlloyDB as destination

B.Use Dataflow to stream Oracle changes from Pub/Sub to AlloyDB

C.Use Ora2Pg for the full dump, then manually capture Oracle redo logs and apply them to AlloyDB

D.Export Oracle data to CSV, load into AlloyDB, then use a custom script with cron to apply changes

AnswerA

DMS supports Oracle (via CDC) to AlloyDB, providing full dump + continuous replication for near-zero downtime.

Why this answer

Database Migration Service (DMS) supports continuous change data capture (CDC) from Oracle to AlloyDB for PostgreSQL, enabling near-zero downtime migration. Unlike Ora2Pg, which only handles full dump and restore, DMS uses Oracle LogMiner or binary logs to capture incremental changes and apply them to AlloyDB in near real-time, making it the correct choice for a two-phase migration with minimal downtime.

Exam trap

Cisco often tests the misconception that Ora2Pg can be extended with manual CDC scripts or that Dataflow is a simpler alternative, but the trap here is that DMS is the only Google Cloud managed service that natively supports Oracle-to-AlloyDB CDC without requiring custom development or external tools.

How to eliminate wrong answers

Option B is wrong because Dataflow streaming from Pub/Sub requires a custom CDC pipeline (e.g., Debezium) to capture Oracle changes, which adds complexity and latency, and is not a native or recommended approach for direct Oracle-to-AlloyDB migration. Option C is wrong because manually capturing and applying Oracle redo logs to AlloyDB is impractical and error-prone; redo logs are Oracle-specific binary files that cannot be directly applied to PostgreSQL without complex transformation and replay logic. Option D is wrong because exporting to CSV and using cron scripts for incremental changes cannot achieve near-zero downtime; cron-based batch updates introduce significant lag and risk data inconsistency, and CSV export does not support CDC.

Practice this question →

57

MCQmedium

A financial services company needs to query data across Cloud SQL (PostgreSQL) and BigQuery without moving data. They want to use federated queries from BigQuery to access Cloud SQL tables. What must be created in BigQuery to enable this?

A.A BigQuery view

B.An external table

C.A Cloud SQL instance connection

D.A BigQuery dataset

AnswerB

An external table in BigQuery references data in Cloud SQL and allows querying via EXTERNAL_QUERY.

Why this answer

BigQuery federated queries for Cloud SQL require creating an external table or using the EXTERNAL_QUERY function. An external data source connection is needed, but the question asks specifically what must be created in BigQuery.

Practice this question →

58

MCQeasy

A data engineer needs to run a complex transformation pipeline between Cloud SQL and BigQuery, including joining data from both sources. The pipeline should run on a schedule and handle large volumes efficiently. Which service should they use?

A.Dataflow

B.Cloud Functions

C.Cloud Run

D.Datastream

AnswerA

Dataflow is ideal for complex data transformation pipelines with support for batch and streaming, scheduling, and multiple data sources.

Why this answer

Dataflow is the correct choice because it is a fully managed, serverless service for executing Apache Beam pipelines, which can handle complex transformations (e.g., joining data from Cloud SQL and BigQuery) at scale. It supports scheduled execution via Cloud Scheduler or built-in triggers, and its auto-scaling and exactly-once processing semantics ensure efficient handling of large volumes without manual infrastructure management.

Exam trap

Cisco often tests the distinction between data movement services (Datastream) and data processing services (Dataflow), so the trap here is that candidates mistake Datastream's CDC replication for a transformation pipeline, overlooking that it cannot perform complex joins or scheduled batch transformations.

How to eliminate wrong answers

Option B (Cloud Functions) is wrong because it is designed for lightweight, event-driven, short-lived functions (max 9 minutes timeout) and cannot handle complex, long-running ETL pipelines or large-volume joins between Cloud SQL and BigQuery. Option C (Cloud Run) is wrong because it is a containerized compute platform for stateless HTTP requests, not optimized for stateful, long-running data pipelines; it lacks native support for Apache Beam or distributed data processing across multiple sources. Option D (Datastream) is wrong because it is a serverless change data capture (CDC) and replication service for streaming data into BigQuery, not a transformation engine; it cannot perform complex joins or transformations between Cloud SQL and BigQuery.

Practice this question →

59

MCQeasy

A company needs to back up a Cloud Bigtable instance daily and be able to restore it to a different region in case of a regional outage. What is the recommended approach?

A.Use Cloud Scheduler to trigger a Dataflow job that exports the Bigtable table to Avro files in GCS, then import in another region

B.Use Bigtable replication with a multi-cluster routing policy

C.Create a Bigtable managed backup of the cluster and restore it to a cluster in the desired region

D.Export the table using the HBase shell to a Cloud Storage bucket and import it in the new region

AnswerC

Bigtable managed backups allow easy cross-cluster restore, including to different regions.

Why this answer

Option C is correct because Bigtable managed backups are the recommended approach for disaster recovery across regions. They allow you to create a consistent backup of a Bigtable cluster and restore it to a different cluster in another region, ensuring data durability and recoverability in case of a regional outage. This method is fully managed, does not require custom code, and preserves the table schema and data integrity.

Exam trap

Cisco often tests the distinction between replication (for high availability and low-latency reads) and managed backups (for point-in-time recovery and cross-region disaster recovery), leading candidates to choose replication when the requirement explicitly calls for a backup that can be restored independently.

How to eliminate wrong answers

Option A is wrong because exporting Bigtable tables via Dataflow to Avro files in GCS and then importing in another region is more complex, slower, and not the recommended approach for disaster recovery; it is typically used for data migration or analytics, not for automated daily backups with regional failover. Option B is wrong because Bigtable replication with a multi-cluster routing policy provides high availability and low-latency reads across regions but does not create a point-in-time backup that can be restored independently; it replicates live data, which could propagate corruption or accidental deletions. Option D is wrong because exporting a table using the HBase shell to a Cloud Storage bucket is a manual, ad-hoc process that lacks automation, consistency guarantees, and is not designed for production-grade daily backups; it also requires custom scripting and does not leverage Bigtable's native backup features.

Practice this question →

60

MCQeasy

A team is using Cloud SQL for MySQL and wants to recover the database to a specific point in time within the last 7 days. They have automated backups enabled. Which feature must be configured to enable point-in-time recovery (PITR)?

A.Use Database Migration Service for continuous replication

B.Configure cross-region replication

C.Enable binary logging and set a suitable binlog retention period

D.Enable automated backups only

AnswerC

PITR uses binlogs to replay transactions after the last full backup.

Why this answer

PITR for Cloud SQL MySQL requires binary log (binlog) retention to be set appropriately.

Practice this question →

61

MCQmedium

A company uses Cloud SQL for PostgreSQL and wants to set up point-in-time recovery (PITR) with a recovery window of 7 days. They have automated backups enabled. What additional configuration is required to achieve PITR?

A.Create an on-demand backup every hour for the last 7 days.

B.Set up a cross-region backup copy with a retention of 7 days.

C.Configure the backup retention period to 7 days and ensure automatic backup is enabled.

D.Enable binlog replication on the instance.

AnswerC

Cloud SQL for PostgreSQL PITR uses automated backups and WAL logs retained according to the backup retention setting.

Why this answer

Point-in-time recovery (PITR) in Cloud SQL for PostgreSQL relies on write-ahead log (WAL) archiving, which is automatically enabled when automated backups are turned on. To retain the WAL logs needed to replay transactions to any point within the recovery window, you must set the backup retention period to at least 7 days. Option C correctly combines a 7-day backup retention with automated backups, which is the only additional configuration required beyond the default automated backup setting.

Exam trap

Cisco often tests the misconception that PITR requires a separate feature like binlog or extra on-demand backups, when in fact for PostgreSQL it is simply a matter of configuring the backup retention period to match the desired recovery window.

How to eliminate wrong answers

Option A is wrong because on-demand backups are full snapshots, not incremental logs; they do not provide the continuous transaction log replay needed for PITR, and creating them every hour is unnecessary and costly. Option B is wrong because cross-region backup copies are for disaster recovery and do not affect the retention of WAL logs in the source region; PITR requires local WAL retention, not a replicated copy. Option D is wrong because binlog replication is a MySQL/MariaDB feature; PostgreSQL uses WAL (write-ahead log) for replication and PITR, not binlogs.

Practice this question →

62

Multi-Selecteasy

A company is designing a polyglot persistence architecture for a social media platform. They need to store user profiles (relational), posts (document), and activity logs (time-series). Which THREE Google Cloud databases should they choose for these respective workloads?

Select 3 answers

A.Cloud SQL

B.Cloud Storage

C.Cloud Bigtable

D.Memorystore

E.Firestore

AnswersA, C, E

Cloud SQL is a relational database suitable for user profiles with ACID transactions.

Why this answer

Cloud SQL (or Spanner) for relational user profiles, Firestore for document posts, and Bigtable for time-series activity logs. Memorystore is a cache, not persistent. Cloud Storage is object storage.

Practice this question →

63

Multi-Selecthard

A company is migrating a SQL Server database to Cloud SQL for SQL Server using Database Migration Service (DMS). They have created a continuous migration job with CDC. They need to test the migrated data before promotion without affecting the source. Which TWO actions should they take? (Choose 2 options.)

Select 2 answers

A.Use a separate DMS job to a different Cloud SQL instance for testing

B.Create a clone of the Cloud SQL instance (from the DMS target) and test on the clone

C.Stop the DMS job, test on the target, then resume

D.Test directly on the DMS target instance without promotion; changes won't affect source

E.Promote the DMS job to make the Cloud SQL instance the primary, then re-create the job for production

AnswersA, B

This keeps the production migration untouched.

Why this answer

To test without impacting source, they can create a clone of the Cloud SQL instance (or use a different instance) and promote the clone, but DMS does not support cloning directly. The recommended approach is to set up a separate DMS job to a different target instance for testing, or use the existing job and promote a test instance after taking a snapshot. However, the most practical options are: (1) Create a clone of the Cloud SQL instance from the DMS target, and (2) Use a separate DMS job to a test target.

Among the options, 'Create a clone of the Cloud SQL instance from the DMS job' and 'Promote the DMS job to a test instance' are valid. But given DMS limitations, the typical answer is to use a separate DMS job or clone. I'll pick the two that align with GCP documentation: Create a clone of the Cloud SQL instance (from the target) and promote the DMS job to a separate instance (though DMS doesn't support multiple targets).

Let's refine: 'Create a clone of the Cloud SQL instance and run a DMS job to that clone' is not an option. The best answers are: 'Use a separate DMS job to a different Cloud SQL instance for testing' and 'Promote the DMS job to a test instance, then re-create the job for production' — but promoting is one-time. I'll choose: B and D.

Practice this question →

64

MCQmedium

An organization has data in Amazon S3 that they want to query from BigQuery without moving it. Which BigQuery feature should they use?

A.Cloud Storage transfer service to copy data to GCS first

B.BigQuery federated queries with AWS Glue

C.BigQuery Omni

D.Bigtable federation

AnswerC

BigQuery Omni enables cross-cloud queries on AWS and Azure.

Why this answer

BigQuery Omni allows querying data across clouds, including Amazon S3, without moving the data.

Practice this question →

65

MCQhard

A company is migrating an on-premises Oracle database to AlloyDB for PostgreSQL. They need to minimize downtime and ensure data consistency. They plan to use Database Migration Service (DMS). Which migration job type and configuration should they use?

A.Use a continuous migration job with CDC only, skipping the initial dump.

B.Use a batch migration job that exports Oracle data to CSV files and loads them into AlloyDB.

C.Use a one-time full dump migration job and then manually import the dump into AlloyDB.

D.Use a continuous migration job that performs an initial full dump followed by CDC replication.

AnswerD

Continuous migration with CDC minimises downtime and ensures consistency.

Why this answer

Option D is correct because Database Migration Service (DMS) continuous migration jobs perform an initial full dump to establish a baseline, then use Change Data Capture (CDC) to replicate ongoing changes from the source Oracle database to AlloyDB for PostgreSQL. This approach minimizes downtime by allowing the target to stay synchronized with the source until a cutover, ensuring data consistency without requiring a separate manual import step.

Exam trap

The trap here is that candidates may confuse 'continuous migration' with 'CDC-only' (Option A), not realizing that DMS requires an initial full load to establish the baseline before CDC can begin, or they may incorrectly assume a batch or manual import approach (Options B and C) is suitable for minimizing downtime and ensuring consistency.

How to eliminate wrong answers

Option A is wrong because skipping the initial dump means no baseline data is migrated, leaving the target empty; CDC can only replicate changes after a full snapshot, so this would not achieve a working migration. Option B is wrong because batch migration jobs that export to CSV files are not supported by DMS for Oracle-to-AlloyDB migrations; DMS uses native replication protocols (e.g., Oracle LogMiner or XStream) for CDC, not file-based exports, and this approach would introduce significant downtime and inconsistency. Option C is wrong because a one-time full dump migration job lacks CDC replication, meaning any changes made to the source after the dump would be lost, leading to data inconsistency and requiring manual catch-up, which increases downtime.

Practice this question →

66

MCQhard

A company is migrating a 5 TB Oracle database to AlloyDB for PostgreSQL. They need to validate the migration with a test replica without impacting the source. After testing, they plan to promote the replica to become the primary. Which migration strategy should they use?

A.Use Ora2Pg to migrate the schema, then perform a manual bulk data export/import

B.Use Database Migration Service to create a continuous migration job with a full dump and CDC, then test the replica and promote it

C.Use Datastream to replicate to AlloyDB, then promote the target

D.Use Cloud Data Fusion to create an ETL pipeline from Oracle to AlloyDB

AnswerB

DMS supports Oracle to AlloyDB migration with continuous sync and promotion.

Why this answer

Database Migration Service (DMS) with a continuous migration job using a full dump and Change Data Capture (CDC) is the correct choice because it allows you to create a fully synchronized test replica of the 5 TB Oracle database in AlloyDB for PostgreSQL without impacting the source. After validating the replica, you can promote it to become the primary with minimal downtime, as CDC ensures near-real-time consistency.

Exam trap

The trap here is that candidates confuse Datastream (a CDC streaming tool) with Database Migration Service, but Datastream cannot perform the initial full dump or promote a replica to primary in AlloyDB, making it unsuitable for this end-to-end migration scenario.

How to eliminate wrong answers

Option A is wrong because Ora2Pg is a schema conversion tool that does not provide continuous replication or CDC, and manual bulk data export/import would require downtime and cannot create a live test replica that can be promoted without re-syncing. Option C is wrong because Datastream is designed for streaming change data capture to BigQuery, Cloud Storage, or Pub/Sub, not for direct replication to AlloyDB, and it lacks the ability to perform a full dump and promote a replica within AlloyDB. Option D is wrong because Cloud Data Fusion is an ETL tool for batch data integration and transformation, not a database migration service; it cannot perform continuous replication with CDC or promote a replica to primary.

Practice this question →

67

Multi-Selectmedium

An application uses Cloud SQL MySQL for OLTP and wants to run analytics queries without impacting performance. Which TWO approaches can achieve this? (Select 2)

Select 2 answers

A.Use BigQuery federated queries to query Cloud SQL directly

B.Use Cloud Spanner for OLTP instead

C.Create a Cloud SQL read replica and run analytics on it

D.Use BigQuery Omni

E.Enable Cloud SQL automatic storage increase

AnswersA, C

Federated queries allow analytics without data movement.

Why this answer

Option A is correct because BigQuery federated queries allow you to query Cloud SQL MySQL in real time using BigQuery's SQL engine, without moving data. This enables analytics on live OLTP data while offloading the query processing to BigQuery, thus avoiding performance impact on the Cloud SQL instance. Option C is correct because a Cloud SQL read replica is a separate read-only copy of the primary instance; running analytics queries on the replica prevents resource contention with OLTP write operations.

Exam trap

Cisco often tests the misconception that any BigQuery feature (like Omni) can query Cloud SQL, or that Cloud Spanner is a suitable analytics target, when the correct approaches are limited to read replicas and federated queries for direct, non-disruptive analytics.

Practice this question →

68

Multi-Selectmedium

A company uses Cloud SQL for PostgreSQL and wants to set up a disaster recovery solution with cross-region backup copies. They also need point-in-time recovery (PITR) in the primary region. Which three steps should they take? (Choose three.)

Select 3 answers

A.Configure the backup retention period to your required PITR window.

B.Promote a read replica in the secondary region for migration.

C.Enable automated backups on the Cloud SQL instance.

D.Enable cross-region backup copy in the Cloud SQL settings.

E.Create an on-demand backup every hour for the last 7 days.

AnswersA, C, D

Retention period determines how far back PITR can go.

Why this answer

Option A is correct because the backup retention period in Cloud SQL directly determines the maximum window for point-in-time recovery (PITR). PITR relies on transaction logs retained alongside automated backups; setting the retention period to cover your required PITR window ensures you can restore to any point within that timeframe.

Exam trap

Cisco often tests the distinction between automated backups (which enable PITR) and on-demand backups (which do not support PITR), leading candidates to incorrectly select frequent on-demand backups as a solution for point-in-time recovery.

Practice this question →

69

Multi-Selectmedium

A financial services company is migrating an Oracle database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). They have completed the full dump and CDC is ongoing. The migration team now needs to perform a cutover with minimal downtime. Which TWO actions should they take?

Select 2 answers

A.Stop the Database Migration Service job before promotion.

B.Modify the source connection profile to point to the Cloud SQL instance.

C.Start a second migration job to the same Cloud SQL instance.

D.Promote the Cloud SQL for PostgreSQL replica.

E.Stop all writes to the source Oracle database.

AnswersD, E

Promotion converts the Cloud SQL replica into a standalone primary instance that applications can connect to.

Why this answer

Option D is correct because promoting the Cloud SQL for PostgreSQL replica is the standard cutover step in a DMS migration: it converts the continuous replication target into a standalone, writable database. This action finalizes the migration with minimal downtime because the replica has been kept in sync via CDC from the source Oracle database.

Exam trap

Cisco often tests the misconception that stopping the DMS job is required before promotion, but in reality the job must remain active to complete the final replication of in-flight transactions, and stopping it prematurely would cause data loss.

Practice this question →

70

Multi-Selectmedium

A company is building a polyglot persistence architecture. They need to choose the correct Google Cloud databases for the following requirements: (1) ACID transactions for financial orders, (2) high-throughput time-series sensor data, and (3) real-time session cache. Which THREE databases should they choose? (Choose 3)

Select 3 answers

A.Memorystore

B.Cloud Spanner

C.Cloud SQL

D.Cloud Bigtable

E.Firestore

AnswersA, B, D

Memorystore (Redis) is ideal for session caching.

Why this answer

Cloud Spanner provides ACID transactions globally, Bigtable for time-series, and Memorystore for caching. Firestore is document-oriented, not ideal for time-series.

Practice this question →

71

MCQmedium

A company uses Cloud Spanner for global transaction processing. They need to export a full database backup to GCS in a portable format for long-term archival. Which method should they use?

A.Use gcloud beta spanner databases export command to export to GCS in CSV format.

B.Use Dataflow to read the Spanner database and write to GCS in JSON format.

C.Use Cloud Spanner backups (built-in) which export to GCS in Avro format.

D.Use Cloud SQL export to GCS.

AnswerC

Cloud Spanner's managed backup feature exports the entire database to GCS in Avro files, which is portable.

Practice this question →

72

MCQhard

A company uses Cloud SQL for PostgreSQL with a cross-region replica for disaster recovery. They need to perform a regional failover with minimal data loss. What configuration is required?

A.Use Database Migration Service instead

B.Promote the cross-region replica to a primary instance

C.Take a manual backup of the primary and restore to the replica

D.Enable synchronous replication

AnswerB

Promotion makes the replica a standalone instance, and data up to the promotion point is preserved.

Why this answer

Cloud SQL cross-region replicas use asynchronous replication, so some data loss is possible. To minimize loss, ensure that the replication lag is low and that automated backups are taken frequently. However, the key is to promote the replica to a standalone instance, which will stop replication and make it writable.

Practice this question →

73

MCQmedium

A company needs to migrate a self-managed PostgreSQL database (version 12) to Cloud SQL for PostgreSQL with minimal downtime. They plan to use Database Migration Service (DMS). What is the correct set of steps?

A.Create a DMS connection profile for the source; create a migration job with 'Full dump + CDC'; configure source for logical replication; promote destination when ready.

B.Create a DMS connection profile for the source; create a migration job with 'Full dump' only; promote the destination after dump completes.

C.Create a DMS connection profile for the source; set up Cloud SQL for PostgreSQL; use pg_dump and pg_restore manually.

D.Create a DMS connection profile for the source; create a migration job with 'CDC' only; no initial dump is needed.

AnswerA

DMS continuous migration uses full dump then CDC (logical replication) to keep source and destination in sync with minimal downtime.

Practice this question →

74

Multi-Selectmedium

A financial services company is migrating from Oracle to Cloud SQL for PostgreSQL. They need to ensure data consistency during the migration and minimize downtime. Which two actions should they take? (Choose 2)

Select 2 answers

A.Manually convert the Oracle schema to PostgreSQL using DDL statements.

B.Use DMS preview job to test migration before executing the full job.

C.Use Database Migration Service with continuous migration (CDC) to replicate ongoing changes.

D.Perform a full export using Oracle Data Pump and import directly into Cloud SQL.

E.Create connection profiles for both source and target databases in DMS.

AnswersC, E

CDC ensures near-zero downtime by replicating changes after the initial dump.

Why this answer

DMS continuous migration with CDC ensures minimal downtime by replicating changes. Connection profiles are necessary to configure source and target. Testing with DMS preview jobs is not a standard feature; DMS provides test jobs.

Manual schema conversion is not recommended; use Ora2Pg.

Practice this question →

75

MCQeasy

A company uses Cloud Spanner for its global transactional database and needs to create a consistent backup that can be restored to a different region. What is the recommended approach?

A.Use the Cloud Console to take a managed backup of the Spanner instance

B.Create a read replica in the target region and promote it

C.Export the Spanner database to Avro files in Cloud Storage using gcloud spanner databases export

D.Use Cloud Spanner's incremental backup feature to capture daily changes

AnswerC

The export command creates a consistent snapshot as Avro files in GCS, which can be imported into another instance.

Why this answer

Option C is correct because exporting a Cloud Spanner database to Avro files in Cloud Storage using the gcloud spanner databases export command creates a full, consistent snapshot that can be restored to any region. This approach ensures transactional consistency across all tables and supports cross-region restoration, which is required when the backup must be available in a different region than the source.

Exam trap

Cisco often tests the misconception that managed backups or read replicas can be used for cross-region restoration, but Cloud Spanner requires explicit export/import to move backups between regions.

How to eliminate wrong answers

Option A is wrong because Cloud Console managed backups are regionally scoped and cannot be directly restored to a different region; they are tied to the instance's regional or multi-regional configuration. Option B is wrong because Cloud Spanner does not support read replicas that can be promoted to a primary instance; Spanner uses a single writable instance with built-in replication, not a replica promotion model. Option D is wrong because Cloud Spanner does not have an incremental backup feature; backups are always full consistent snapshots, and incremental backups are not supported.

Practice this question →

Page 1 of 2 · 130 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Pcd Multi Database questions.

Start 20-question session

CCNA Pcd Multi Database Questions — Page 1 of 2 | Courseiva