Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
Your organization is planning to migrate a legacy data warehouse to BigQuery. Before migrating, you need to perform a technical inventory of the source system to determine migration complexity and identify optimization opportunities.
You have the following requirements for the assessment:
Which solution should you implement to achieve these requirements?
Dataplex Universal Catalog is a fully managed intelligent data fabric that unifies distributed data, automates data governance, and provides centralized metadata management across Google Cloud and third-party sources.
While Dataplex is excellent for discovering and managing data, it does not analyze historical execution logs from legacy on-premises data warehouses to determine query latency, identify unused tables based on historical execution, or map database coupling for migration planning.
The scenario required implementing a centralized metadata discovery and governance solution for data assets that have already been migrated to BigQuery and Cloud Storage.
Database Migration Service (DMS) is a fully managed Google Cloud service designed to migrate operational relational databases (such as MySQL, PostgreSQL, and SQL Server) to Cloud SQL or AlloyDB with minimal downtime.
DMS is engineered for operational (OLTP) database migrations, not for analytical (OLAP) data warehouse assessments. It cannot ingest or analyze data warehouse query logs to provide insights into database coupling, table usage, or analytical query latency.
The organization was migrating a transactional MySQL or PostgreSQL database to Cloud SQL and required a tool to manage continuous replication with minimal application downtime.
The BigQuery migration assessment is a specialized tool designed to evaluate legacy data warehouse environments by analyzing their historical execution logs. It provides comprehensive reports on system utilization, data dependencies, and query patterns to facilitate a smooth migration to Google Cloud.
Unlike generic data movement or metadata tools, the BigQuery migration assessment is purpose-built for the planning and technical inventory phase of a data warehouse migration. It directly parses source system logs to extract the exact usage metrics, dependencies, and performance characteristics required by the scenario.
The BigQuery Data Transfer Service is a fully managed data ingestion tool that automates the movement of data from various sources (such as SaaS applications, cloud storage, and other data warehouses) into BigQuery on a scheduled basis.
This service is strictly a data movement and ingestion engine. It does not possess the capability to analyze source system query logs, determine which tables are frequently accessed together, or evaluate query runtimes to recommend BigQuery BI Engine optimizations.
The assessment phase was already complete, and the organization needed a managed service to schedule and execute the actual batch transfer of data from the legacy data warehouse into BigQuery.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated