A company is migrating an on-premises PostgreSQL 13 database to AlloyDB for PostgreSQL using DMS continuous migration. The source is configured with logical replication using the pglogical extension. During the initial sync, the migration job fails with the error 'could not open relation with OID xxxx'. What is the most likely cause?
A team is migrating a MySQL database to Cloud SQL using mysqldump for the initial snapshot. The source database uses InnoDB tables. Which mysqldump flags should be used to ensure a consistent snapshot without locking tables?
A team is migrating a 5 TB MySQL database to Cloud SQL using DMS. The full dump phase is taking longer than expected. They suspect network bandwidth is the bottleneck. Which action can they take to improve the dump speed within DMS?
A data analyst needs to load data from an on-premises Teradata system into BigQuery on a recurring daily schedule. Which Google Cloud service should they use?
A data team is migrating an Oracle database to Cloud SQL for PostgreSQL. They have used Ora2Pg to convert the schema. After conversion, they notice several issues with data type mappings. Which THREE Oracle-to-PostgreSQL mappings are correct? (Choose 3)
An organization is migrating an Oracle database to Cloud SQL for PostgreSQL using Ora2Pg. During testing, a stored procedure that uses Oracle's SYSDATE produces incorrect results. What is the correct approach to handle this conversion?
A company is using DMS to migrate a MySQL database to Cloud SQL with continuous replication. During the CDC phase, the replication lag is increasing and not catching up. The source database is heavily used for OLTP workloads. Which action would most likely reduce the replication lag?
An engineer is manually migrating a MySQL database to Cloud SQL using mysqldump and mysql import. They need to ensure the dump captures a consistent snapshot without locking InnoDB tables. Which mysqldump flags should they use?
An organization is migrating a MySQL database to Cloud SQL using DMS with continuous replication. After promoting the destination, they need a rollback plan. Which approach should they use to enable a quick rollback if issues arise?
During a cutover from MySQL to Cloud SQL, the team must minimize downtime. Which THREE steps are essential for a successful cutover with minimal data loss?
A team is migrating a MySQL database to Cloud SQL using DMS. They need to configure the source database for binary logging. Which TWO parameters must be set correctly?
During a MySQL to Cloud SQL migration using Database Migration Service, the full dump phase is taking much longer than expected. The source MySQL database is 500 GB and the Cloud SQL instance is of sufficient size. What is the most likely cause of the slow dump?
An engineer needs to connect Database Migration Service to a source MySQL database that has only a private IP address. The Cloud SQL destination is also private. What is the recommended method for DMS to connect to the source?
A company is migrating a 2 TB PostgreSQL database to AlloyDB using Database Migration Service. They need to minimize downtime. After the initial full dump, the CDC lag remains high for hours. What should the engineer check first?
A company needs to migrate a 5 TB Oracle database to Cloud SQL for PostgreSQL. They need to convert schemas and data, and also set up ongoing replication with minimal downtime. Which TWO services/tools should they use? (Choose TWO.)
A company is migrating a MySQL database to Cloud SQL using Database Migration Service (DMS). The source database is on-premises and uses InnoDB tables. The migration job is configured as continuous (CDC). After starting the job, the full dump phase completes successfully, but the CDC phase shows no replicated changes. What is the most likely cause?
An engineer is planning to migrate a PostgreSQL database to AlloyDB using Database Migration Service (DMS). The source database is version 13 and the target is AlloyDB. The migration must replicate ongoing changes with minimal downtime. Which source configuration is required to enable continuous change data capture (CDC) with DMS for PostgreSQL?
An organization is migrating a Teradata data warehouse to BigQuery. They need to convert existing Teradata DDL and BTEQ scripts to BigQuery SQL. Which Google Cloud service should they use for schema conversion?
A company is migrating a PostgreSQL database to Cloud SQL using DMS with continuous CDC. During cutover, the engineer checks DMS metrics and sees the replication lag is consistently 0 seconds. What is the next step to complete the migration?
An engineer needs to migrate a 500 GB MySQL database to Cloud SQL. The source is in a private network with no public IP. The Cloud SQL instance will also use a private IP. Which connectivity method should the engineer use for Database Migration Service?
During a MySQL to Cloud SQL migration using DMS, the migration job fails during the full dump phase with an error indicating 'Access denied for user'. The DMS connection profile to the source was created with a user that has only SELECT privileges. What additional privilege is required for the full dump?
A company is migrating an on-premises Oracle database to Cloud SQL for PostgreSQL. They have used Ora2Pg to convert the schema. Which of the following data type conversions is correct?
A team is migrating a 10 TB PostgreSQL database to AlloyDB using DMS with continuous CDC. The migration starts, but the CDC phase is falling behind, with lag increasing over time. The source is a busy production database with high write throughput. What is the most effective action to reduce lag?
A company is planning a migration from an on-premises SQL Server database to Cloud SQL for PostgreSQL. They need to convert both schema and data. Which two Google Cloud services should they consider? (Choose 2)
A team is migrating a MySQL database to Cloud SQL using DMS with continuous CDC. They want to minimize downtime during cutover. Which three actions should they take as part of the cutover plan? (Choose 3)
An organization is migrating a 500 GB Oracle database to Cloud SQL for PostgreSQL using DMS with continuous CDC. The migration is in progress, and the team needs to ensure that if the migration fails, they can roll back with minimal data loss. Which two pre-migration steps should they take? (Choose 2)
A team is migrating a self-managed PostgreSQL database to AlloyDB using DMS. They need to set up the source connection profile. The source database is in a different VPC network, and the team wants to avoid exposing it to the internet. Which connectivity option should they use?
A company is using mysqldump to migrate a MySQL database to Cloud SQL. The source database uses InnoDB tables and is running a production workload. They want to ensure a consistent snapshot without locking tables. Which mysqldump flags should they use?
A data engineer is migrating a Teradata data warehouse to BigQuery. They have a large number of BTEQ scripts that need to be converted. Which tool is designed to automate the conversion of Teradata DDL and BTEQ scripts to BigQuery-compatible SQL?
A team is planning a migration from PostgreSQL to Cloud SQL with minimal downtime. They have set up DMS continuous migration. At cutover time, they need to ensure no data loss. What should they verify before promoting the destination?
An organization is migrating a Redshift data warehouse to BigQuery using BigQuery Data Transfer Service. They have scheduled a recurring transfer. However, they notice that some columns are not being mapped correctly. What is the most likely cause?
After promoting a Cloud SQL destination in a DMS continuous migration, the application team updates the connection strings. However, they want a rollback plan in case issues arise. What should they keep running to allow a rollback?
A company is migrating from PostgreSQL to AlloyDB using DMS. They need to set up logical replication on the source. Which THREE components are required for PostgreSQL logical replication?
A company is migrating from an on-premises Teradata data warehouse to BigQuery using the Schema Conversion Tool (SCTS). Which of the following is correctly handled by SCTS?
A team is planning a one-time migration of a 500 GB MySQL database to Cloud SQL using Database Migration Service. They want to minimize the impact on the source database. Which mysqldump flags should they use when taking the initial snapshot?
An organization is performing a DMS continuous migration from PostgreSQL to Cloud SQL. The migration job is in the CDC phase. During a planned maintenance window, the source database is restarted. After restart, the DMS job continues to replicate but reports a lag. What is the impact of the restart on the migration?
A team is migrating an on-premises MySQL database to Cloud SQL using DMS with continuous CDC. The source database uses public IP. The DMS connection profile for the source requires IP allowlisting. Which IP addresses should be allowlisted?
A team is migrating a MySQL database to Cloud SQL using a manual approach (mysqldump + import) instead of DMS. They have limited bandwidth. Which TWO considerations should they take into account when choosing between DMS and manual migration? (Choose TWO.)
A company plans to migrate a MySQL database to Cloud SQL with minimal downtime. They use Database Migration Service with continuous CDC. After starting the migration, the initial full dump completes, and CDC replication begins. The application team needs to cut over during a maintenance window. What must the engineer do just before promoting the destination to ensure no data loss?
A team is migrating a PostgreSQL database to AlloyDB using Database Migration Service. They need to perform an initial one-time full dump without continuous replication. Which migration job type should they choose?
A company is migrating a Teradata data warehouse to BigQuery. They need to convert Teradata DDL and BTEQ scripts to BigQuery-compatible SQL. Which TWO services or tools should they use? (Choose 2 correct answers.)
An engineer is using Database Migration Service to migrate a MySQL database to Cloud SQL. They need to set up a source connection profile. Which TWO methods can the engineer use to allow DMS to connect to the source database? (Choose 2 correct answers.)
A company wants to migrate a self-managed PostgreSQL database to AlloyDB with minimal downtime. They plan to use Database Migration Service with continuous CDC. The source database is in a different region. Which THREE steps should they include in their cutover plan? (Choose 3 correct answers.)
An engineer is migrating a MySQL database to Cloud SQL using mysqldump. The source database uses InnoDB tables. Which TWO mysqldump options should the engineer use to perform a consistent online backup without locking tables? (Choose 2 correct answers.)
Your team is migrating a 4 TB on-premises PostgreSQL 13 database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). The migration must be a continuous migration with minimal downtime. During the initial full dump, DMS fails with the error 'replication slot is not active'. You have verified that the source database has the required extensions and that the DMS connection profile has the necessary privileges. What should you do to resolve this issue?
Your team is migrating a large on-premises PostgreSQL database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). The migration must be continuous and have minimal downtime. During the initial full dump, you notice that the database contains tables without primary keys, and DMS reports that these tables cannot be replicated. What should you do to allow the migration to proceed while maintaining data integrity?
Your team is migrating an on-premises PostgreSQL 14 database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). The database is 800 GB and must remain available for writes during the migration. After starting the migration job, you notice that the initial full dump is taking much longer than expected and the source is under heavy read load. You need to reduce the impact on the source and speed up the initial load without compromising data consistency. What should you do?
A media company runs a 4 TB PostgreSQL 13 database on-premises with a steady write load of about 2,000 transactions per second. They must move to Cloud SQL for PostgreSQL with less than five minutes of downtime. Network bandwidth between the data center and Google Cloud is 1 Gbps and the migration window is a single weekend. Which migration approach should they use?
A retail company is migrating an on-premises MongoDB 4.4 replica set to MongoDB Atlas on Google Cloud. They need to perform a minimal-downtime migration with continuous replication. Which TWO actions should they take? (Choose two.)
A financial services company is migrating a 5 TB on-premises SQL Server 2019 database to Cloud SQL for SQL Server. The database contains tables with foreign key constraints and triggers. They plan to use Database Migration Service (DMS) for a continuous migration with minimal downtime. During testing, they find that the initial dump fails due to foreign key violations. What should they do to ensure a successful migration?
An organization is migrating a large on-premises MySQL database to Cloud SQL for MySQL using Database Migration Service (DMS). They need to ensure that the migration is secure and that the data is encrypted both in transit and at rest. Which TWO configurations should they implement to meet these requirements? (Choose two.)
A healthcare analytics team is migrating a 5 TB on-premises Microsoft SQL Server 2019 database to Cloud SQL for SQL Server. The database has tables with foreign key relationships and uses the bulk-logged recovery model. They need to perform a one-time migration with minimal administrative overhead. Which approach should they use?
A financial services firm is moving a 6 TB Microsoft SQL Server 2019 database to Cloud SQL for SQL Server. The application cannot tolerate more than a ten-minute outage, and the source uses a full recovery model with transaction log backups every fifteen minutes. Which combination of steps should the engineer perform to guarantee the smallest possible cutover window?
A healthcare company is migrating an on-premises Oracle 19c database to Cloud SQL for PostgreSQL. They have a large number of PL/SQL stored procedures and want to minimize manual rewriting. They plan to use the Google Cloud Oracle to PostgreSQL migration tooling. Which tool should they use to automatically convert the PL/SQL code to PL/pgSQL?
A team is migrating an on-premises PostgreSQL 13 database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). The source database is 500 GB and has a high write workload. They want to minimize downtime and ensure data consistency. During the migration, they notice that the replication lag is increasing. Which action should they take to reduce replication lag while maintaining consistency?
A retail company is migrating a 1 TB on-premises MongoDB 4.4 replica set to MongoDB Atlas on Google Cloud. They want to minimize downtime and ensure that the destination is in sync before cutover. Which Google Cloud service should they use?
An e-commerce company is migrating its on-premises MySQL 5.7 database to Cloud SQL for MySQL 8.0 using Database Migration Service (DMS). They want to minimize downtime and ensure that the destination is continuously updated during the migration. After the initial dump, they notice that the replication lag is increasing steadily. The source database has a high volume of write transactions. What is the most likely cause of the increasing replication lag?
A team is migrating an on-premises MySQL database to Cloud SQL for MySQL using Database Migration Service (DMS). The source database has a table with a composite primary key consisting of three columns. During the migration, DMS fails to replicate changes to this table. What is the most likely cause of this failure?
A startup is migrating a small MongoDB 4.4 database from a single on-premises server to MongoDB Atlas on Google Cloud. The database is about 10 GB and has a low write rate. They want to minimize downtime and avoid managing servers. Which migration approach is most appropriate?
A media company is migrating a 10 TB on-premises Apache Cassandra cluster to Google Cloud. They require a fully managed, scalable database with minimal operational overhead and want to use a lift-and-shift approach with minimal schema changes. Which Google Cloud service should they choose?
A healthcare company is migrating an on-premises Oracle 19c database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). The database contains many tables with CLOB and BLOB columns. During the migration, they encounter errors related to large object (LOB) handling. They need to ensure that LOB data is migrated correctly. Which TWO actions should they take? (Choose two.)
Your team is migrating a sharded on-premises MongoDB 5.0 cluster to Firestore in Native mode. Some collections exceed 1 million documents, and the application performs frequent multi-document ACID transactions across two collections. You plan to use the Datastore mode bulk loader approach. Which TWO limitations must you account for in the target design? (Choose two.)
A team is migrating a 1 TB MySQL 8.0 database from on-premises to Cloud SQL for MySQL using Database Migration Service (DMS). They want to minimize downtime and ensure data consistency. The source database has a mix of InnoDB and MyISAM tables. Which TWO actions should they take before starting the migration? (Choose two.)
A retail company is migrating a 1.5 TB on-premises MongoDB 4.4 replica set to MongoDB Atlas on Google Cloud. Their security policy forbids granting the migration tool any write access to the source cluster, and they require an initial full copy plus continuous change stream capture with minimal source impact. Which migration approach should they use?
A team is migrating an on-premises Microsoft SQL Server database to Cloud SQL for SQL Server using Database Migration Service (DMS). They need to ensure that the migration captures all schema changes and data modifications during the migration. Which TWO steps must they perform to enable continuous replication? (Choose two.)
A retail company is migrating a 1 TB MySQL 8.0 database from on-premises to Cloud SQL for MySQL using Database Migration Service (DMS). They need to ensure that the migration captures all schema changes, including new tables and columns added during the migration. Which DMS feature should they enable?
You are migrating a 6 TB PostgreSQL 13 database to Cloud SQL for PostgreSQL 15 using Database Migration Service. The source has a table with a column of type json and several columns using the money type. The initial dump completed, but the CDC phase repeatedly fails on changes to that table. What is the most likely cause?
An organization is planning to migrate a small on-premises PostgreSQL database to Cloud SQL for PostgreSQL. They want to use the simplest possible method that requires minimal downtime and does not involve continuous replication. Which tool should they use to perform the migration?
An organization is migrating a 10 TB on-premises Oracle database to Cloud SQL for PostgreSQL. They have converted the schema using Ora2Pg and are now planning the data migration. The database has large tables with LOB columns. They want to minimize downtime and ensure data integrity. Which method should they use to migrate the data?
A media company is migrating a large on-premises Cassandra cluster to Google Cloud Bigtable. They need to migrate data efficiently and ensure that the schema is correctly mapped. Which TWO steps should they take? (Choose two.)
A team is migrating a 4 TB on-premises PostgreSQL 12 database to Cloud SQL for PostgreSQL 14 using Database Migration Service (DMS). The source has a high volume of write activity, and the team needs to minimize downtime. They have configured the source connection profile and the destination connection profile. What should they do next to start the migration with continuous replication?
A team is migrating an on-premises Microsoft SQL Server database to Cloud SQL for SQL Server using Database Migration Service (DMS). The source database is 1 TB and has a high transaction rate. They want to minimize downtime and have configured the source and destination connection profiles. Which migration type should they choose in DMS to achieve minimal downtime?
A company is migrating their on-premises MySQL database to Cloud SQL using Database Migration Service (DMS). The source database is MySQL 5.7, and the target is a Cloud SQL MySQL 8.0 instance. The migration job is set to continuous, but after the full dump phase, the CDC phase keeps failing with the error 'binary log not found'. What is the most likely cause?
An organization is planning a database migration from Oracle to PostgreSQL on Cloud SQL. They have a large number of stored procedures that use Oracle-specific PL/SQL features. Which tool should they use to automate the schema conversion, including conversion of PL/SQL to PL/pgSQL?
A company wants to migrate their on-premises SQL Server database to Cloud SQL for PostgreSQL using Database Migration Service. They need to minimize downtime. The source database is 2 TB and the network link has 1 Gbps bandwidth. What should they do first?
A data engineer is migrating a large Teradata data warehouse to BigQuery using the Schema Conversion Tool (SCTS). They need to convert BTEQ scripts and Teradata DDL to BigQuery-compatible SQL. After conversion, several date functions are not working correctly. What is the most likely reason?
A company is migrating an Oracle database to Cloud SQL for PostgreSQL. They have a table with a column defined as NUMBER(10,2). To maintain data integrity, what should be the corresponding PostgreSQL data type?
An organization needs to continuously replicate data from an on-premises PostgreSQL database to AlloyDB with minimal downtime during cutover. They have set up DMS continuous migration. During the cutover phase, what is the correct sequence of steps?
A company wants to migrate their on-premises PostgreSQL database to Cloud SQL using DMS. The source database is behind a firewall and does not have a public IP. The target Cloud SQL instance uses a private IP. How should the engineer connect the source to DMS?
A company is migrating their on-premises Oracle database to Cloud SQL for PostgreSQL. They want to test the converted stored procedures using unit tests. Which framework should they use?
A company is migrating a PostgreSQL database to Cloud SQL using DMS continuous migration. After the full dump, the CDC phase is replicating changes. To prepare for cutover, which TWO actions should the engineer take? (Choose 2)
An organization is migrating a large on-premises MySQL database to Cloud SQL using DMS. They want to minimize downtime. Which TWO configurations should they implement? (Choose 2)
A company is migrating a MySQL database to Cloud SQL using Database Migration Service (DMS). The source database is on-premises with a public IP address. Which networking configuration is required on the source to allow DMS to connect?
A team is migrating a PostgreSQL database to AlloyDB using DMS with continuous replication. After starting the migration job, the initial dump completes but CDC replication fails with a replication slot error. What is the most likely cause?
A team needs to migrate a large Teradata data warehouse to BigQuery. They want to automatically convert Teradata DDL and BTEQ scripts to BigQuery-compatible SQL. Which Google Cloud service should they use?
During a cutover from an on-premises Oracle database to Cloud SQL for PostgreSQL, the team needs to minimize downtime. They have set up continuous replication using a custom tool. Which sequence of steps should they follow to perform the cutover with minimal data loss?
A company is migrating a PostgreSQL database to Cloud SQL using DMS. The source database has logical replication enabled for the migration. What is the purpose of logical replication in this context?
A team is converting an Oracle stored procedure that uses PL/SQL with cursors to PostgreSQL PL/pgSQL. The procedure declares a cursor with parameters. Which conversion is correct for a parameterized cursor in PL/pgSQL?
A company is migrating a PostgreSQL database to AlloyDB using DMS. They need to test the converted stored procedures. Which tool should they use to write and run unit tests for PL/pgSQL functions?
A team is migrating an on-premises PostgreSQL database to Cloud SQL using DMS. They want the migration job to continuously replicate changes after the initial dump. Which type of migration job should they create?
A company is migrating an on-premises PostgreSQL database to Cloud SQL for PostgreSQL. They need to ensure minimal downtime and maintain ongoing replication until cutover. Which approach should they use?
An organization is migrating an Oracle database to Cloud SQL for PostgreSQL. They have numerous stored procedures written in PL/SQL. Which tool should they use to automatically convert these procedures to PL/pgSQL?
A company is migrating a 10 TB Teradata data warehouse to BigQuery. They need to convert Teradata DDL and BTEQ scripts to BigQuery SQL. Which Google Cloud service should they use?
An engineer is planning a migration from on-premises MySQL to Cloud SQL. They want to use Database Migration Service with continuous replication. What must be enabled on the source MySQL database before starting the migration job?
During cutover of a Database Migration Service continuous migration job, the engineer observes that the source database still receives writes after promoting the destination Cloud SQL instance. What should the engineer do to complete the migration?
A company is migrating an Oracle database to Cloud SQL for PostgreSQL using Ora2Pg for schema conversion. After conversion, they want to test the correctness of converted stored procedures. Which tool should they use?
During a one-time (non-continuous) migration from MySQL to Cloud SQL using mysqldump, the engineer wants to ensure the dump does not lock InnoDB tables. Which flag should be included in the mysqldump command?
An engineer is migrating from on-premises PostgreSQL to Cloud SQL for PostgreSQL using pg_dump. Which flags should be used to avoid errors related to roles and privileges when importing into Cloud SQL?
An organization is migrating from Teradata to BigQuery. They have 20 TB of data, complex BTEQ scripts, and require near-zero downtime. Which THREE components should be part of their migration plan? (Choose THREE.)
A company is planning a cutover from an on-premises MySQL database to Cloud SQL after a DMS continuous migration. To ensure minimal downtime and a successful cutover, which TWO actions should be part of the cutover procedure? (Choose TWO.)
A company is performing a heterogeneous migration from Oracle to Cloud SQL for PostgreSQL using Ora2Pg. During testing, they find that a stored procedure using Oracle's PL/SQL `DBMS_OUTPUT.PUT_LINE` does not execute after conversion. What is the most likely issue, and how should it be resolved?
A team is migrating a 2 TB MySQL database from on-premises to Cloud SQL. They want to minimize downtime. The source is MySQL 8.0 with InnoDB tables, and the application can be read-only during cutover. Which approach provides the lowest downtime while ensuring data consistency?
A migration from Oracle to PostgreSQL using Ora2Pg is complete. The team wants to run unit tests on the converted stored procedures to ensure they produce correct results. Which tool is most suitable for this purpose?
An engineer is migrating a MySQL database to Cloud SQL using DMS. The source database uses MyISAM tables. During the migration, the full dump phase fails with a timeout. What should the engineer do to increase the likelihood of success?
An organization is migrating a MySQL database to Cloud SQL using Database Migration Service (DMS). They need to ensure minimal downtime and continuous replication of changes from the source. Which type of migration job should they create?
An organization is migrating an Oracle database to PostgreSQL on Compute Engine. They used Ora2Pg to migrate schema and data. After migration, they want to validate that stored procedures produce correct results. Which tool should they use for unit testing the migrated PL/pgSQL code?
An engineer needs to migrate a PostgreSQL database to Cloud SQL. They have used pg_dump to create a dump file. Which flags should they use to avoid issues with ownership and ACLs, since Cloud SQL does not support those?
During an Oracle to PostgreSQL migration using Ora2Pg, a NUMBER(10,2) column is being mapped. Which PostgreSQL data type should be used to preserve precision and scale?
A company is using DMS to migrate from MySQL to Cloud SQL. During the full dump phase, the migration is taking longer than expected. Which factor most likely affects the duration of the full dump?
A team is migrating an on-premises Oracle database to Cloud SQL for PostgreSQL using DMS. They have completed the schema conversion using Ora2Pg and are now setting up continuous migration. The source database is behind a firewall. Which connectivity method should they use for the source connection profile if they cannot use public IP?
A company is migrating a MySQL 5.7 database to Cloud SQL for MySQL 8.0 using Database Migration Service (DMS). The source database has binary logging disabled. The team needs to perform a continuous migration with minimal downtime. What must be done before creating the DMS migration job?
A team is migrating an on-premises PostgreSQL 13 database to AlloyDB using DMS continuous migration. During the CDC phase, the migration job shows an error: 'ERROR: could not start WAL streaming: ERROR: replication slots are not enabled on the source.' The source is running in Google Cloud Compute Engine. What is the most likely cause?
An organization needs to migrate a 2 TB Oracle database to Cloud SQL for PostgreSQL. The schema has many stored procedures using PL/SQL. Which tool should they use for schema conversion and what is a key consideration when converting PL/SQL?
An engineer is performing a manual migration from PostgreSQL to Cloud SQL. They run pg_dump and want to import the dump into Cloud SQL. Which pg_dump flags are necessary to avoid errors related to ownership and ACLs?
During a DMS continuous migration from MySQL to Cloud SQL, the full dump phase completed successfully, but the CDC phase is failing with 'Error: binary log not found' after a few minutes. The source MySQL has binary logs enabled. What is the most likely cause?
A company is migrating Oracle to Cloud SQL for PostgreSQL using Ora2Pg. For a column defined as NUMBER(10,2) in Oracle, what is the corresponding data type in PostgreSQL?
A company is migrating a 5 TB Oracle database to Cloud SQL for PostgreSQL using DMS with continuous migration. They need to minimize downtime and have a rollback plan. Which TWO actions should they include in their migration plan? (Choose TWO.)
An engineer is migrating a 20 TB PostgreSQL database to AlloyDB using DMS continuous migration. The full dump phase is taking longer than expected. Which THREE factors could affect the duration of the full dump phase? (Choose THREE.)
An engineer is migrating an Oracle database to Cloud SQL for PostgreSQL. They use Ora2Pg to convert the schema. One source table uses a column with data type NUMBER(10,2). What is the appropriate PostgreSQL data type after conversion, and which tool should the engineer use to verify the correctness of converted stored procedures?
An engineer is manually migrating a MySQL database to Cloud SQL using mysqldump and import. They need to capture the binary log position to enable CDC with Database Migration Service later. Which TWO mysqldump flags should they include to ensure a consistent snapshot and capture the log position? (Choose 2 correct answers.)
A company is migrating an on-premises PostgreSQL database to Cloud SQL using Database Migration Service with continuous replication. The source database has binary logging enabled and uses the pglogical plugin. The migration job is failing after the full dump phase. Which THREE common issues should the engineer check? (Choose 3 correct answers.)
A team is planning a migration from Oracle to PostgreSQL on Cloud SQL. They use Ora2Pg to convert the schema. Which THREE Oracle data types require special attention for correct mapping to avoid data loss or precision issues? (Choose 3 correct answers.)
A company is migrating a 4 TB on-premises PostgreSQL 13 database to Cloud SQL for PostgreSQL. They require a one-time migration with less than 30 minutes of downtime. The database has a high volume of write transactions. Which migration approach should they use?
A financial services company is migrating a 4 TB on-premises PostgreSQL 13 database to Cloud SQL for PostgreSQL. The database must remain available for read and write operations throughout the migration, with a cutover downtime of less than five minutes. They have a 1 Gbps dedicated interconnect and can provision a Cloud SQL instance with sufficient storage. Which migration approach should they use?
A healthcare company is migrating a 10 TB on-premises Microsoft SQL Server 2019 database to Cloud SQL for SQL Server. The database has a high transaction rate, and the company requires near-zero downtime. They plan to use Database Migration Service (DMS) for SQL Server. Which configuration must they implement to support continuous replication?
A healthcare organization is migrating an on-premises Oracle database to Cloud SQL for PostgreSQL. They need to convert the schema and perform a one-time migration with minimal downtime. They have a 1 TB database and can tolerate up to 1 hour of downtime. Which combination of tools should they use?
A retail company runs a 3 TB on-premises PostgreSQL 14 database on a single server. They want to migrate to Cloud SQL for PostgreSQL with less than 15 minutes of downtime. The database has a high volume of write transactions and a continuous stream of updates. They have a 1 Gbps dedicated interconnect between on-premises and Google Cloud. Which migration approach should they use?
A financial services company is migrating its on-premises Oracle database to Cloud SQL for PostgreSQL. The database contains many PL/SQL packages and stored procedures. They plan to use the Google Cloud Database Migration Service (DMS) for the migration. However, DMS does not automatically convert PL/SQL code. Which approach should they take to ensure that the business logic is properly migrated and continues to function after the migration?
A startup is migrating a small 50 GB MySQL 8.0 database from an on-premises server to Cloud SQL for MySQL. They can afford a few hours of downtime and want the simplest migration method with minimal configuration. Which approach should they use?
An organization is migrating a 2 TB MongoDB Atlas cluster to Firestore in Native mode. They require a one-time snapshot migration with minimal operational overhead and do not need continuous replication. The source cluster uses MongoDB 4.4 and has a single replica set. Which migration approach should they use?
A startup is migrating a small 50 GB MySQL 8.0 database from a virtual machine in Google Compute Engine to Cloud SQL for MySQL. The database can tolerate a brief downtime of up to 30 minutes. They want a simple, cost-effective migration with minimal setup. Which method should they use?
A company is migrating a 5 TB on-premises SQL Server database to Cloud SQL for SQL Server. They want to minimize downtime and ensure data consistency. They plan to use Database Migration Service (DMS) for the migration. The database has a high volume of transactions, and the migration must be completed within a tight maintenance window. Which DMS migration type should they use to achieve minimal downtime?
A retail company is migrating a 3 TB on-premises MongoDB 4.4 replica set to Firestore in Native mode. They need to preserve document structure and minimize transformation effort. Which TWO actions should the engineer take? (Choose two.)
A financial services company is migrating a 4 TB PostgreSQL 13 database from an on-premises data center to Cloud SQL for PostgreSQL. The database has a write-heavy workload with continuous transactions. The migration must minimize downtime and ensure data consistency. They have a 1 Gbps dedicated network link. Which migration approach should they use?
You are migrating an on-premises PostgreSQL 14 database to Cloud SQL for PostgreSQL using Database Migration Service. The database is 800 GB and the business requires under five minutes of write downtime during cutover. You have already completed the initial full dump and the destination is replicating continuously from the source. Which action should you take to complete the migration with the least downtime?
A logistics company is migrating an on-premises MySQL 5.7 database to Cloud SQL for MySQL 8.0. They want to use Database Migration Service and need the initial load to complete without errors. The source database uses the MyISAM storage engine for several tables. What must the engineer do before starting the DMS migration job?
A media company is migrating a 10 TB on-premises MongoDB 4.4 replica set to MongoDB Atlas on Google Cloud. They need to minimize downtime and ensure that all writes during migration are captured. They have a dedicated 10 Gbps interconnect. Which migration approach should they use?
A company is migrating a large on-premises Microsoft SQL Server database to Cloud SQL for SQL Server using Database Migration Service (DMS). The database uses SQL Server Agent jobs for nightly ETL processes. The migration must be continuous with minimal downtime. Which of the following should they do to ensure the SQL Server Agent jobs are migrated correctly?
A company is migrating a small on-premises MySQL 5.7 database to Cloud SQL for MySQL using a one-time dump and load. They want to use the simplest method that requires minimal configuration. Which tool should they use?
A healthcare company is migrating a 10 TB on-premises Apache Cassandra cluster to Cloud Bigtable. The data model uses wide rows with millions of columns per partition key, and the application performs point reads by row key. They need to minimize read latency after migration. Which schema and migration design should the engineer choose?
A financial services firm is migrating an on-premises PostgreSQL 13 database to Cloud SQL for PostgreSQL using Database Migration Service (DMS) with continuous replication. During the CDC phase, they observe that changes to tables with large object (LOB) columns are not being replicated, while changes to other tables replicate normally. The source uses the default logical decoding plugin. Which action should they take to resolve this?
A startup is migrating a small 50 GB MySQL 8.0 database from a single on-premises server to Cloud SQL for MySQL. They want to use Database Migration Service (DMS) for a one-time migration with minimal configuration and no continuous replication. Which source connection profile configuration should they use?
A financial services firm is migrating an on-premises Microsoft SQL Server 2019 database to Cloud SQL for SQL Server. The database is 1.5 TB, and the team wants a managed, low-downtime path with continuous replication and built-in validation. Which approach should they use?
A media company is migrating a 10 TB on-premises PostgreSQL 14 database to Cloud SQL for PostgreSQL using Database Migration Service (DMS) with continuous replication. The migration must minimize downtime, and the source database has a high write throughput. Which TWO actions should they take to ensure the CDC phase can keep up and the cutover is as short as possible? (Choose two.)
A company is migrating a 2 TB Oracle database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). The Oracle database uses numerous PL/SQL stored procedures and triggers. DMS successfully migrates the schema and data, but the stored procedures and triggers are not migrated. What should the team do to migrate these objects?
A company is migrating a large on-premises MySQL database to Cloud SQL for MySQL using Database Migration Service (DMS). They want to perform a one-time migration with minimal administrative effort. The source database is MySQL 5.7 and uses InnoDB. They have already created the source and destination connection profiles. What is the simplest way to perform the migration?