Courseiva
Knowledge + Practice
CertificationsVendorsCareer RoadmapsLabs & ToolsStudy GuidesGlossaryPractice Questions
C
Courseiva

Free IT certification practice questions with explained answers for CCNA, CompTIA, AWS, Azure, Google Cloud, and more.

Certification Practice Questions

CCNA practice questionsSecurity+ SY0-701 practice questionsAWS SAA-C03 practice questionsAZ-104 practice questionsAZ-900 practice questionsCLF-C02 practice questionsA+ Core 1 practice questionsGoogle Cloud ACE practice questionsCySA+ CS0-003 practice questionsNetwork+ N10-009 practice questions
View all certifications →

Product

CertificationsCertification PathsExam TopicsPractice TestsExam Dumps vs Practice TestsStudy HubComparisons

Free Resources

Difficulty IndexLearn — Free ChaptersIT GlossaryFree Tools & LabsStudy GuidesCareer RoadmapsBrowse by VendorCisco Command ReferenceCCNA Scenarios

Company

AboutContactEditorial PolicyQuestion Writing PolicyTrust Center

Legal

Privacy PolicyTerms of Service

Courseiva is a free IT certification practice platform offering original exam-style practice questions, detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics for Cisco, CompTIA, Microsoft, AWS, and other technology certifications.

© 2026 Courseiva. Courseiva is operated by JTNetSolutions Ltd. All rights reserved.

Courseiva is an independent certification practice platform and is not affiliated with, endorsed by, or sponsored by Cisco, Microsoft, AWS, CompTIA, Google, ISC2, ISACA, or any other certification vendor. Vendor names and certification marks are used only to identify the exams learners are preparing for.

← Migrate Data Solutions practice sets

PCD Migrate Data Solutions • Complete Question Bank

PCD Migrate Data Solutions — All Questions With Answers

Complete PCD Migrate Data Solutions question bank — all 0 questions with answers and detailed explanations.

100
Questions
Free
No signup
Certifications/PCD/Practice Test/Migrate Data Solutions/All Questions
Question 1mediummultiple choice
Read the full Migrate Data Solutions 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 during the cutover. What should they do to achieve a zero-downtime cutover?

Question 2hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 3easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 4mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 5mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 6hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 7easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 8mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 9easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 10mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 11mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 12hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 13mediummulti select
Read the full Migrate Data Solutions explanation →

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

Question 14hardmulti select
Read the full Migrate Data Solutions explanation →

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

Question 15easymulti select
Read the full Migrate Data Solutions explanation →

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

Question 16mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 17hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 18easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 19mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 20mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 21hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 22easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 23mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 24easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 25mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 26hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 27mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 28mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 29hardmulti select
Read the full Migrate Data Solutions explanation →

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?

Question 30mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 31easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 32mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 33hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 34mediummultiple choice
Read the full Migrate Data Solutions explanation →

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

Question 35easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 36mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 37hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 38mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 39hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 40easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 41mediummultiple choice
Read the full Migrate Data Solutions explanation →

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

Question 42mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 43hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 44easymultiple choice
Read the full Migrate Data Solutions explanation →

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

Question 45mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 46easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 47mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 48hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 49mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 50easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 51mediummultiple choice
Read the full Migrate Data Solutions explanation →

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

Question 52mediummultiple choice
Read the full Migrate Data Solutions explanation →

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

Question 53hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 54mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 55easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 56mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 57hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 58mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 59hardmulti select
Read the full Migrate Data Solutions explanation →

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?

Question 60mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 61mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 62hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 63easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 64mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 65mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 66hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 67easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 68mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 69mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 70hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 71easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 72mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 73mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 74hardmulti select
Read the full Migrate Data Solutions explanation →

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?

Question 75mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 76easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 77mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 78mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 79hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 80mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 81easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 82hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 83mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 84easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 85mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 86hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 87mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 88mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 89mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 90hardmulti select
Read the full Migrate Data Solutions explanation →

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?

Question 91mediummultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 92hardmultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 93easymultiple choice
Read the full Migrate Data Solutions explanation →

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?

Question 94mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 95hardmulti select
Read the full Migrate Data Solutions explanation →

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?

Question 96mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 97easymulti select
Read the full Migrate Data Solutions explanation →

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

Question 98mediummulti select
Read the full Migrate Data Solutions explanation →

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?

Question 99hardmulti select
Read the full Migrate Data Solutions explanation →

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?

Question 100easymulti select
Read the full Migrate Data Solutions explanation →

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?

Practice tests

Scored 10-question sessions with instant feedback and explanations.

PCD Practice Test 1 — 25 Questions→PCD Practice Test 2 — 25 Questions→PCD Practice Test 3 — 25 Questions→PCD Practice Test 4 — 25 Questions→PCD Practice Test 5 — 25 Questions→PCD Practice Exam 1 — 20 Questions→PCD Practice Exam 2 — 20 Questions→PCD Practice Exam 3 — 20 Questions→PCD Practice Exam 4 — 20 Questions→Free PCD Practice Test 1 — 30 Questions→Free PCD Practice Test 2 — 30 Questions→Free PCD Practice Test 3 — 30 Questions→PCD Practice Questions 1 — 50 Questions→PCD Practice Questions 2 — 50 Questions→PCD Exam Simulation 1 — 100 Questions→

Practice by domain

Each domain maps to a weighted exam section. Focus on the domain where you are weakest.

Manage a Solution that Can Span Multiple Database SystemsDeploy Scalable and Highly Available Databases in Google CloudDesign Scalable and Highly Available Cloud Database SolutionsMigrate Data SolutionsDesigning highly scalable, available, and reliable cloud-native applicationsBuilding and testing applicationsDeploying applicationsIntegrating Google Cloud servicesManaging application performance monitoring

Practice by scenario

Filter questions by type — troubleshooting, exhibit, drag-and-drop, PBQ, ACLs, OSPF, and more.

Browse scenarios→

Continue studying

All Migrate Data Solutions setsAll Migrate Data Solutions questionsPCD Practice Hub