Manage a Solution that Can Span Multiple Database Systems

An e-commerce company uses Cloud SQL for MySQL for transactional data and BigQuery for analytics. They need to replicate order data from Cloud SQL to BigQuery in near real-time with minimal latency. Which Google Cloud service should they use?

A company is migrating an on-premises Oracle database to Cloud SQL for PostgreSQL. They need to assess the compatibility of the existing schema and identify objects that need conversion. Which tool should they use?

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 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 company uses Cloud Spanner for a globally distributed application. They need to capture all row-level changes (inserts, updates, deletes) and publish them to Pub/Sub for downstream processing. Which Spanner feature should they use?

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 startup needs a multi-model database architecture: relational for user profiles, document store for product catalog, and a key-value cache for sessions. Which approach is this called?

A company uses Datastream to replicate data from an on-premises MySQL database to BigQuery. They notice that the destination BigQuery table has a large number of rows that are duplicates with different timestamps. What is the most likely cause?

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 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 company wants to perform cross-cloud analytics, querying data stored in both Google Cloud BigQuery and Amazon S3. Which BigQuery feature enables this?

A company is migrating from MySQL to Cloud SQL MySQL using Database Migration Service with continuous CDC. They want to test the migrated database with production traffic before cutting over, while still keeping the source as primary. What should they do?

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)

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)

A company is migrating a PostgreSQL database to AlloyDB using Database Migration Service. They want to ensure high availability during the migration with minimal risk. Which TWO practices should they follow? (Choose 2)

A company wants to migrate an on-premises Oracle database to Cloud SQL for PostgreSQL with minimal downtime. They plan to use Database Migration Service (DMS) with continuous migration. What must be configured on the source Oracle database to enable change data capture (CDC)?

A data engineering team needs to replicate data from a PostgreSQL database to BigQuery in near real-time for analytics. Which Google Cloud service is most suitable for this task with minimal setup?

An e-commerce platform uses Cloud Spanner for order processing and BigQuery for analytics. The team needs to capture all changes in the Spanner 'Orders' table and stream them to Pub/Sub for downstream processing. Which Spanner feature should be used?

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 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?

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 company uses Memorystore for Redis as a cache in front of Cloud Spanner. They want to ensure cache updates happen asynchronously when Spanner data changes. Which pattern is most appropriate?

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 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 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 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 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 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?

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?

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?

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?

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 company uses Cloud SQL for PostgreSQL as its primary database. They want to query this data from BigQuery for analytics without moving the data. They also need to ensure that BigQuery queries see the most recent data (within seconds of changes). Which approach is most suitable?

A startup is building an application that requires strong consistency and horizontal scalability across multiple regions. They need a fully managed relational database that supports both SQL queries and ACID transactions. Which database service should they choose?

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 media company uses Cloud SQL for MySQL for its user data and needs to export daily snapshots to BigQuery for reporting. The reporting must reflect data as of midnight UTC. Which approach is most cost-effective and efficient?

A data engineer needs to perform complex transformations on streaming data as it moves from Cloud Pub/Sub to Cloud Bigtable. Which service should they use for this purpose?

A company wants to query data residing in Amazon S3 using BigQuery without copying the data. They also need to join this data with other tables in BigQuery. Which BigQuery feature should they use?

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 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?

You need to perform a one-time historical data migration from an on-premises MySQL database to Cloud SQL for MySQL. The database is 500 GB, and you can afford several hours of downtime. Which migration method is most straightforward?

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

An e-commerce platform uses Cloud Spanner for transactions and Cloud Bigtable for session state and recommendations. They want to synchronize customer profile changes from Spanner to Bigtable in near real-time. Which three components should they use? (Choose 3)

A company uses Cloud SQL for MySQL and wants to set up cross-region disaster recovery with automated failover. Which two steps are required? (Choose 2)

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 financial services company uses Cloud SQL for MySQL for transactional data. They need to analyze this data in BigQuery without moving data or impacting transactional performance. Which approach should they use?

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 company uses Cloud Spanner for a globally distributed application. They need to capture all data changes from a critical Spanner table and stream them to Pub/Sub in real-time for downstream processing. Which approach meets this requirement?

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?

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 company uses Cloud Bigtable for real-time user sessions. They need to back up Bigtable data to another region for disaster recovery, with the ability to restore to a specific point in time within the last week. Which backup strategy should they choose?

A team needs to replicate changes from an on-premises Oracle database to BigQuery in near real-time. They want to use Google's serverless CDC solution. Which service should they use?

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?

An organization is migrating a MySQL database to Cloud SQL for MySQL using Database Migration Service. The migration job is in the 'Full dump + CDC' phase. After a successful full dump, the CDC phase is replicating changes. To complete the migration with minimal downtime, what should the engineer do?

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 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 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?

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?

A company needs to query data across Cloud SQL (MySQL) and Bigtable using BigQuery without moving the data. Which TWO configurations are required?

A company wants to use a combination of relational, document, and time-series databases to meet different workload requirements. What is this architectural pattern called?

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?

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?

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 financial services company is implementing a distributed transaction across multiple Cloud Spanner instances in different regions. They require strict ACID compliance. What is the best approach?

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 company wants to use BigQuery to query data stored in AWS S3 without copying it to Google Cloud. Which Google Cloud feature should they use?

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

You need to migrate an Oracle database to Cloud SQL for PostgreSQL. The schema must be converted using Oracle to PostgreSQL migration tools. Which tool should you use to automate schema conversion?

You need to back up a Cloud Spanner database and store it in a different region for disaster recovery. The backup should be a full database export. What is the recommended method?

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?

Which service provides serverless change data capture (CDC) from MySQL and PostgreSQL to BigQuery or Cloud Storage without writing code?

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

A company is using Datastream to replicate data from an on-premises PostgreSQL database to BigQuery. They encounter high latency in replication. Which THREE steps should they take to improve performance? (Select 3)

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)

A company uses Cloud SQL MySQL for transactional workloads, BigQuery for analytics, and wants to stream real-time changes from Cloud SQL to BigQuery with minimal latency and no custom code. Which approach is most appropriate?

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 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 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?

An organisation needs to run SQL queries across data stored in Cloud SQL MySQL and Cloud Storage (CSV files) without moving the data. They want to use BigQuery as the query engine. Which feature should they use?

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 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?

An e-commerce platform uses Cloud SQL MySQL for orders and Bigtable for session history. To provide a unified customer view, they need to join order data with recent session activity. Which approach minimises data movement while achieving low-latency queries?

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 company wants to implement polyglot persistence: an RDBMS for transactions, a NoSQL database for session storage, and a data warehouse for analytics. Which combination of Google Cloud databases best suits this architecture?

A company is migrating an Oracle database to Cloud SQL for PostgreSQL using Ora2Pg. They need to convert stored procedures and functions. After conversion, they find that some PL/SQL code is not working. What is the most likely reason?

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 company needs to synchronise data from an on-premises Oracle database to BigQuery in near real-time. They also need to perform complex transformations on the data before loading into BigQuery. Which two services should they use together? (Choose two.)

A company is designing a cross-database solution with eventual consistency. They need to update data in Cloud SQL (orders) and Bigtable (inventory) as part of a single business transaction. Which two patterns can help maintain eventual consistency? (Choose two.)

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

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?

An e-commerce platform uses Cloud SQL for MySQL for transactional data and wants to run complex analytical queries on that data without affecting production performance. The analytics queries often join with data from Google Cloud Storage. What is the MOST cost-effective and performant approach?

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 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 company wants to analyse data across Google Cloud and Amazon Web Services without moving the data. They need to query live data in Amazon S3 and Google Cloud Storage from BigQuery. Which feature should they use?

A financial services company uses a polyglot persistence architecture: Cloud SQL for MySQL for transactions, Cloud Bigtable for real-time risk calculations, and BigQuery for historical analytics. They need to move data from Bigtable to BigQuery every hour for reporting, with transformations. Which approach is MOST cost-effective and maintainable?

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 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?

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 company uses Cloud Spanner for its global ordering system and needs to stream order changes to a Pub/Sub topic for real-time inventory updates. They also need to archive old orders to BigQuery for historical analysis. What is the simplest architecture to achieve both goals?

A company is migrating a 5 TB SQL Server database to Cloud SQL for SQL Server using Database Migration Service (DMS). After the full dump phase, the continuous replication (CDC) phase starts. The team notices that the source database transaction log is growing rapidly and the CDC phase is failing intermittently with 'log space' errors. What should they do?

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 company is designing a polyglot persistence architecture for an e-commerce platform. They need to store product catalog (relational), session data (low-latency key-value), and analytics data (large-scale SQL queries). Which TWO Google Cloud databases should they use? (Choose two.)

A company is using Datastream to continuously replicate data from an on-premises MySQL database to BigQuery. They notice that some schema changes (e.g., adding a column) on the source are not being propagated. Which TWO actions should they take to ensure schema changes are captured? (Choose two.)

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

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

An e-commerce application uses Cloud SQL for transactional data and Cloud Bigtable for user session logs. A new requirement demands real-time analytics that joins order data with session behavior. The team wants to avoid moving data into a separate data warehouse. Which approach should they take?

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

An organization is using Cloud Spanner for a global application. They need to capture all data changes (inserts, updates, deletes) in a Spanner table and stream them to Pub/Sub for downstream processing. Which feature should they use?

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 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 data engineer needs to run complex transformations on streaming data from Pub/Sub and then write the results to both BigQuery and Cloud Bigtable. Which Google Cloud service is best suited for this task?

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

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 company wants to run analytics queries on Cloud SQL data without impacting the transactional workload. They need to query the Cloud SQL database directly from BigQuery. Which BigQuery feature should they use?

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

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

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

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 retail company uses Cloud SQL for transactional data, Cloud Bigtable for real-time inventory updates, and BigQuery for analytics. They want to build a real-time dashboard that shows current inventory levels across all stores, updated within seconds of a transaction. The dashboard will query Bigtable for the latest inventory count. Which TWO services should they use to stream transactions from Cloud SQL to Bigtable?

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?

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?

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?

A company uses Cloud Bigtable for a time-series application. They need to create a backup that can be restored to a different cluster in a different region for disaster recovery. Which THREE statements about Bigtable backups are correct?

A company needs to synchronize sales transactions from an on-premises Oracle database to BigQuery for near-real-time analytics. They want a serverless solution that requires minimal operational overhead. Which TWO services should they consider?

A global gaming company uses Cloud Spanner for player profiles and leaderboards. They want to replicate leaderboard changes to a secondary Cloud Spanner instance in another region for disaster recovery, with minimal latency. They need to ensure that all writes are eventually consistent across instances. Which THREE approaches should they consider?

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?

A company is using Cloud SQL for MySQL with automated backups enabled. They need to ensure they can recover to any point in time within the last 7 days. The database experiences high write throughput. Which TWO settings should they configure?