PCD Manage a Solution that Can Span Multiple Database Systems — All Questions With Answers

Question 1mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 2mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 3easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 4mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 5hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 6mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 7easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 8hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 9mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 10mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 11easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 12mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 13mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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)

Question 14hardmulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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)

Question 15mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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)

Question 16mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 17easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 18mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 19hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 20mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 21hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 22easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 23mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 24mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 25hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 26easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 27mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 28mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 29hardmulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 30mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 31mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 32mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 33hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 34easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 35mediummultiple choice

Read the full network assurance explanation →

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?

Question 36hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 37easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 38mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 39hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 40mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 41easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 42mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 43mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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)

Question 44hardmulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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)

Question 45mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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)

Question 46mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 47mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 48mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 49hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 50easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 51mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 52hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 53mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 54easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 55hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 56mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 57easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 58mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 59hardmulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 60mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 61easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 62mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 63hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 64mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 65hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 66mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 67mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 68easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 69hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 70mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 71mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 72easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 73mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 74hardmulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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)

Question 75mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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)

Question 76mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 77hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 78easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 79mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 80easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 81mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 82hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 83easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 84mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 85mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 86hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 87easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 88mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 89hardmulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 90mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 91easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 92mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 93hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 94mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 95easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 96mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 97hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 98easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 99mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 100mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 101hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 102easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 103mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 104mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 105hardmulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 106easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 107mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 108hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 109mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 110easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 111mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 112hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 113mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 114easymultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 115mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 116hardmultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 117mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 118mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 119hardmulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 120mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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

Question 121mediummultiple choice

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 122mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 123easymulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 124hardmulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 125mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 126mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 127easymulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 128hardmulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 129easymulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?

Question 130mediummulti select

Read the full Manage a Solution that Can Span Multiple Database Systems explanation →

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?