Migrate Data Solutions

A company is migrating an on-premises PostgreSQL database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). They need to minimize downtime during the cutover. What should they do to achieve a zero-downtime cutover?

An organization is migrating a large Oracle database to Cloud SQL for PostgreSQL using Ora2Pg. They have complex PL/SQL packages with overloaded procedures. What is the correct approach to handle these packages in PostgreSQL?

A company is migrating a MySQL 5.7 database to Cloud SQL for MySQL 8.0. They use MyISAM tables and utf8 charset. What changes must they make during migration?

A team is migrating a Teradata data warehouse to BigQuery. They use BTEQ scripts for ETL. What is the best approach to migrate the BTEQ scripts?

An organization wants to migrate a Redshift data warehouse to BigQuery. They have a large dataset stored in Redshift. What is the most efficient migration approach for the initial data load?

A company is migrating from Oracle to Cloud SQL for PostgreSQL. They have a stored procedure that uses Oracle's DBMS_OUTPUT.PUT_LINE for logging. How should they convert this to PostgreSQL?

A team is planning to migrate a 500 GB MySQL database to Cloud SQL. The application can tolerate up to 2 hours of downtime. Which migration method should they choose?

A company is migrating from Snowflake to BigQuery. They have a large dataset with semi-structured data stored as VARIANT columns in Snowflake. How should they represent this data in BigQuery?

You need to migrate an on-premises PostgreSQL database to Cloud SQL using Database Migration Service. The source database is behind a firewall without a public IP. Which connectivity option should you configure?

A company is migrating from Oracle to Cloud SQL for PostgreSQL. They have a table with a column of type RAW(16). Which PostgreSQL data type should they use?

A team is migrating a set of stored procedures from Oracle to Cloud SQL for PostgreSQL. The procedures use Oracle's package-level global variables. How should they handle this in PostgreSQL?

An organization is planning a re-architect migration of a monolithic Oracle database to a microservices architecture using Cloud SQL for PostgreSQL and Cloud Spanner. They need to split the schema into multiple databases while maintaining data consistency across services. Which approach should they use?

Your company is migrating a 2 TB Oracle database to Cloud SQL for PostgreSQL using Database Migration Service (DMS). The source database is behind a firewall and only allows connections from specific IP ranges. The migration must have minimal downtime. Which TWO actions should you take? (Choose 2 options.)

A company is migrating from MySQL 5.7 to Cloud SQL for MySQL 8.0. They have a mix of MyISAM and InnoDB tables, and their application uses utf8 charset. They want to minimize changes to the application code. Which THREE changes should they make during migration? (Choose 3 options.)

A data engineering team wants to implement version-controlled schema migrations for their PostgreSQL database on Cloud SQL. They need to integrate with their CI/CD pipeline. Which TWO tools should they consider? (Choose 2 options.)

An organization is migrating a 2 TB Oracle database to Cloud SQL for PostgreSQL. They need to minimize downtime and have a limited maintenance window of 30 minutes. Which migration strategy should they use?

A company is migrating from MySQL 5.7 to Cloud SQL for MySQL 8.0. After migration, a legacy application that uses the 'GROUP BY' clause with implicit sorting stops working correctly. What is the most likely cause?

A data engineer is migrating a Teradata data warehouse to BigQuery. They need to transfer historical data and set up continuous replication. Which service should they use?

An organization is migrating a large Oracle database to Cloud Spanner using Database Migration Service. They need to convert stored procedures and functions from PL/SQL to Spanner's SQL dialect. What is the best approach?

A company is migrating a MySQL database with MyISAM tables to Cloud SQL for MySQL. They want to ensure the target database uses InnoDB for better transactional support and crash recovery. What should they do?

A team is migrating an Oracle database to Cloud SQL for PostgreSQL using Database Migration Service. The source has a stored procedure that uses Oracle's 'SYSDATE' function. What should they replace it with in PostgreSQL?

A data engineer wants to perform version-controlled schema migrations as part of a CI/CD pipeline for a Cloud SQL for PostgreSQL database. Which tools should they use?

During an Oracle to PostgreSQL migration, a team uses the Ora2Pg tool. They notice that some PL/SQL code containing the 'DBMS_OUTPUT.PUT_LINE' procedure is not converted correctly. How should they handle this?

A company is migrating a Redshift data warehouse to BigQuery. They need to stage the data in an intermediate storage before loading into BigQuery. What should they use?

An organization is migrating a MySQL database to Cloud SQL for MySQL. The source database uses the 'utf8' character set. To support emoji characters, what should they do before migration?

A team is migrating a 500 GB Snowflake data warehouse to BigQuery. They have a tight deadline and need to minimize manual SQL rewriting. Which approach is most efficient?

A company is using Database Migration Service to migrate an on-premises PostgreSQL database to Cloud SQL for PostgreSQL. The source database is behind a firewall that does not allow direct connections from Google Cloud. What connectivity option should they use?

A team is migrating a MySQL database to Cloud SQL for MySQL. They want to test the migration with a dual-write strategy before cutting over to the new database. Which TWO steps should they take?

An organization is migrating a large Oracle database to Cloud SQL for PostgreSQL. They need to handle Oracle's SEQUENCE objects, which are used for primary key generation. Which THREE approaches are valid for this migration?

A company is planning to migrate from MySQL to Cloud SQL for MySQL. They want to ensure the migrated database meets performance and security requirements. Which TWO configurations should they apply to Cloud SQL?

A company is migrating an on-premises MySQL 5.7 database to Cloud SQL for MySQL 8.0. The database includes MyISAM tables. What is the required action for these tables?

An organization is migrating from Oracle to Cloud SQL for PostgreSQL using Database Migration Service. The source Oracle database has many stored procedures with PL/SQL. Which tool should be used to automate the conversion of these stored procedures to PL/pgSQL?

An enterprise is migrating a 10 TB Teradata data warehouse to BigQuery with minimal downtime. They need to transform Teradata BTEQ scripts to equivalent BigQuery SQL. Which approach should the migration team take to handle the SQL dialect differences?

A company is using Database Migration Service to continuously migrate data from an on-premises PostgreSQL database to Cloud SQL for PostgreSQL. The source database is behind a firewall. Which two steps are required to establish connectivity? (Choose two.)

A database team is planning to migrate a 500 GB MySQL database to Cloud SQL. They require minimal downtime. Which Database Migration Service job type should they use?

A company is migrating from Amazon Redshift to BigQuery. They need to stage the data in Amazon S3 before transferring to BigQuery. Which service should they use to automate the transfer?

A team is migrating an Oracle database to Cloud SQL for PostgreSQL. They are using Ora2Pg for schema conversion. Which of the following data type mappings is correct?

An organization uses Flyway for versioned schema migrations. They are migrating from PostgreSQL to Cloud SQL for PostgreSQL. What is the best practice for applying schema changes during the migration?

During a continuous migration job from on-premises MySQL to Cloud SQL, the engineer notices that the migration job fails after the full dump phase with an error about character set mismatch. The source uses utf8 charset, but Cloud SQL defaults to utf8mb4. What is the best action to resolve this?

A company is migrating from Snowflake to BigQuery. They have a large amount of historical data. What is the recommended service to automate the data transfer?

A team is performing a shadow writes testing strategy as part of database migration validation. What does this involve?

An engineer is using Database Migration Service for a continuous migration from on-premises Oracle to Cloud SQL for PostgreSQL. The migration job has completed the full dump and is now in the CDC phase. The engineer wants to perform a zero-downtime cutover. What action should they take?

During a migration from Teradata to BigQuery, the team needs to convert Teradata BTEQ scripts to BigQuery SQL. Which of the following is a key difference between Teradata SQL and BigQuery SQL that the team must account for?

A database administrator is using Liquibase for schema versioning during a migration to Cloud SQL. What is the primary benefit of using Liquibase?

A company is migrating from MySQL 5.7 to Cloud SQL for MySQL 8.0. They have stored procedures that use GROUP BY with non-aggregated columns. In MySQL 5.7, this is allowed. What change might they need to make?

An organization is migrating an on-premises PostgreSQL database to Cloud SQL. They want to minimize downtime during the cutover. Which Google Cloud service should they use to perform an online migration with near-zero downtime?

A team plans to migrate an Oracle database to Cloud SQL for PostgreSQL. They have identified complex PL/SQL packages that need conversion. Which open-source tool is specifically designed to assist with schema conversion from Oracle to PostgreSQL?

A company is migrating a MySQL 5.7 database to Cloud SQL for MySQL 8.0. Their application uses utf8 charset and GROUP BY with nonstandard behavior (e.g., missing expressions in SELECT list). After migration, they notice queries that previously ran now fail. What is the most likely cause?

An engineer is migrating a large on-premises SQL Server database to Cloud SQL for PostgreSQL. They need to continuously replicate changes during the migration to minimize downtime. Which Database Migration Service job type should they use?

A company wants to migrate their data warehouse from Teradata to BigQuery. They need to automate the loading of data on a regular schedule. Which Google Cloud service should they use?

During a migration from MySQL to Cloud SQL, an engineer notices that the source database uses MyISAM tables with full-text indexes. What must be done to successfully migrate these tables to Cloud SQL (which uses InnoDB by default)?

A company is migrating their MySQL database to Cloud SQL. They have a requirement to automate schema changes as part of their CI/CD pipeline. Which tools should they consider for version-controlled schema migrations? (Select the best option.)

An organization is migrating from Oracle to Cloud SQL for PostgreSQL using Database Migration Service. They need to convert Oracle NUMBER(10,2) and VARCHAR2(100) columns to appropriate PostgreSQL types. What are the correct mappings?

A team is migrating a Snowflake data warehouse to BigQuery. They need to move historical data and set up a one-time batch transfer. Which method is most appropriate?

An engineer is planning a database migration and needs to assess the source database's size, schema complexity, stored procedures, and dependencies. Which activity is this part of?

A company is migrating from Redshift to BigQuery. They have large datasets in Amazon S3. What is the recommended approach to transfer this data into BigQuery?

An engineer is using Database Migration Service for a continuous migration from on-premises MySQL to Cloud SQL. The source database is not directly reachable from DMS due to network restrictions. Which connectivity option should the engineer configure?

A company is migrating a MySQL database to Cloud SQL. They want to test the migration by sending writes to both the old and new databases simultaneously and comparing results. Which TWO techniques should they use?

An organization is migrating from Oracle to Cloud SQL for PostgreSQL. They need to convert Oracle packages (which use PL/SQL) into PostgreSQL equivalents. Which TWO approaches are correct for handling Oracle packages?

A team is migrating a Redshift data warehouse to BigQuery using BigQuery Data Transfer Service. They need to ensure the transfer is secure and cost-effective. Which THREE considerations are important?

A company plans to migrate an on-premises Oracle database to Cloud SQL for PostgreSQL. They need to minimize downtime and ensure continuous sync during migration. Which migration approach should they use?

During an Oracle to Cloud SQL for PostgreSQL migration using DMS, the full dump phase completes successfully, but the CDC phase fails with a 'missing table' error. What is the most likely cause?

A company wants to migrate their MySQL 5.7 database to Cloud SQL for MySQL. They are concerned about performance after migration. Which step is essential for ensuring optimal performance on Cloud SQL?

An organization is migrating a Teradata data warehouse to BigQuery. They want to minimize manual SQL rewriting. Which approach is most effective for converting Teradata SQL to BigQuery-compatible SQL?

A company is migrating their on-premises SQL Server database to Cloud SQL for SQL Server. They need to ensure that schema changes are version-controlled and repeatable across environments. Which tool should they use?

During a live migration from MySQL to Cloud SQL using DMS, the migration job enters a 'failed' state after the full dump. The error log indicates 'Binlog position out of bounds'. What is the most likely cause?

A company wants to migrate an on-premises PostgreSQL 9.6 database to Cloud SQL for PostgreSQL with minimal downtime. Which service should they use?

An organization is migrating from Oracle to Cloud SQL for PostgreSQL using Ora2Pg. After conversion, several stored procedures fail to compile. Which step should they take to identify and fix the issues?

A company is migrating a MySQL 5.7 database to Cloud SQL for MySQL 8.0. They have many queries using GROUP BY that return different results in 8.0. What is the most likely cause?

A financial services company is migrating a Redshift data warehouse to BigQuery. They need to stage data in Amazon S3 before transferring. Which service should they use to automate the transfer?

A company needs to migrate an on-premises Cassandra database to Google Cloud. They want a managed NoSQL database with high availability and low latency. Which service should they choose?

During a MySQL to Cloud SQL migration using DMS, the migration job completes the full dump and CDC phases, but the cutover step fails. The error says 'Source database write operations still occurring'. What should the engineer do to complete cutover?

A company is migrating a Snowflake data warehouse to BigQuery. They need to convert Snowflake SQL to BigQuery SQL. Which TWO tools or services can assist with this conversion?

A company is performing a lift-and-shift migration of an on-premises Oracle database to Cloud SQL for PostgreSQL using DMS with continuous migration. Which THREE prerequisites must be met before starting the migration job?

A company is migrating a MySQL database to Cloud SQL for MySQL. They want to use Flyway for versioned schema migrations in CI/CD. Which TWO commands are part of a typical Flyway migration workflow?

A company is planning to migrate an on-premises Oracle database to Cloud SQL for PostgreSQL. They want to use Google's Database Migration Service (DMS) for continuous migration with minimal downtime. Which source connectivity method does DMS support for connecting to the Oracle database over the internet?

An organization is migrating a MySQL 5.7 database to Cloud SQL for MySQL 8.0. They have many tables using MyISAM engine and want to ensure compatibility. What is the correct approach for handling MyISAM tables?

A team is migrating a Teradata data warehouse to BigQuery using the BigQuery Data Transfer Service. They need to schedule regular incremental transfers. What is the correct configuration for the transfer?

During an Oracle to PostgreSQL migration using Ora2Pg, a developer notices that PL/SQL packages are not being converted correctly. What is the recommended strategy to handle Oracle packages in PostgreSQL?

A company is migrating a MySQL database to Cloud SQL. They plan to use Database Migration Service (DMS) with a continuous migration job to minimize downtime. How do they perform the cutover with zero downtime?

An organization is migrating from on-premises Microsoft SQL Server to Cloud SQL for SQL Server. They want to use a lift-and-shift approach to minimize application changes. Which migration method is most appropriate?

During a MySQL 5.7 to Cloud SQL for MySQL 8.0 migration, the team notices that some queries that worked before are now failing with 'ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause'. What is the cause and solution?

A company is planning to migrate from Snowflake to BigQuery. They have existing complex SQL transformations using Snowflake-specific functions like LISTAGG and PIVOT. What is the best approach to handle these differences?

A team is migrating a legacy application database to Cloud SQL. They want to implement versioned schema changes as part of their CI/CD pipeline. Which tool should they use?

During an Oracle to PostgreSQL migration using Database Migration Service (DMS), the continuous replication fails with an error about unsupported data types. The source table uses Oracle's RAW data type. How should this be handled?

A company is migrating a critical on-premises PostgreSQL database to Cloud SQL. They need to test the migration with production data shape without affecting the source. What is the recommended testing strategy?

An organization is migrating from Amazon Redshift to BigQuery. They have large datasets stored in Amazon S3. What is the most efficient method to migrate the data?

A company is migrating from Oracle to Cloud SQL for PostgreSQL using Database Migration Service. They need to ensure that the migration is validated before cutover. Which TWO actions should they take?

An organization is migrating a MySQL 5.7 database to Cloud SQL for MySQL 8.0. They must ensure compatibility of character sets and collations. Which THREE aspects should they review?

A team is migrating a Teradata data warehouse to BigQuery. They need to assess the migration complexity. Which TWO factors are most critical in determining the level of effort for SQL translation?

A company plans to migrate a 200 GB Oracle database to Cloud SQL for PostgreSQL with minimal downtime. The source database has complex stored procedures and triggers. Which approach should the company use?

An organization is migrating a 5 TB MySQL database from on-premises to Cloud SQL. The source uses MyISAM tables and the utf8 charset. The target must support full Unicode (emojis). The migration should have minimal downtime. What should the organization do?

A data engineering team needs to migrate a 10 TB Teradata data warehouse to BigQuery. They want to automate the migration of historical data and ongoing changes. Which Google Cloud service should they use?

A company is migrating a 1 TB MySQL database to Cloud SQL for MySQL 8.0. The source uses the utf8 charset and MyISAM tables. They need to minimize downtime. Which TWO actions should the team take?

An organization is migrating an Oracle database to Cloud SQL for PostgreSQL using Database Migration Service. The source has many PL/SQL packages, sequences, and data types (NUMBER, VARCHAR2, DATE, CLOB, RAW). Which THREE conversions are correct?

A company is migrating a 500 GB MySQL database to Cloud SQL for MySQL 8.0. They want to test the migration with minimal risk before the final cutover. Which TWO testing approaches should they use?

A data engineer is migrating a Redshift data warehouse to BigQuery. Which THREE steps are typically required?

A company is migrating an on-premises Oracle database to Cloud SQL for PostgreSQL using Database Migration Service. They need to convert stored procedures and ensure data type compatibility. Which TWO tools or steps are essential?

A company is migrating a 2 TB Snowflake data warehouse to BigQuery. The migration must be completed within a month with no downtime. Which THREE actions should the team take?

A startup is migrating a 100 GB PostgreSQL database from a self-managed VM to Cloud SQL. They want zero downtime during cutover. Which TWO features of Database Migration Service should they use?