Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A digital marketing agency collects massive daily volumes of unstructured and semi-structured campaign data from various external platforms. The team wants to ingest all raw data into Google Cloud as quickly as possible without creating preprocessing bottlenecks, preserving the raw logs so they can transform them on demand using SQL-based tools like Dataform.
Which data integration strategy should the agency implement?
Cloud SQL is a fully managed relational database service (supporting MySQL, PostgreSQL, and SQL Server) optimized for OLTP (Online Transaction Processing) workloads requiring low-latency, row-level transactions.
The scenario involved replicating relational database transactions from an on-premises transactional database into a managed cloud database for live transactional application serving.
For unstructured data analytics, BigQuery paired with object storage and BigLake/external tables provides superior scalability compared to transactional relational databases.
ETL (Extract, Transform, Load) is a data integration pattern where data is extracted from source systems, transformed and structured in an external compute layer (such as Cloud Data Fusion or a dedicated processing cluster), and finally loaded into the target storage destination.
The scenario required strict data cleansing for compliance or privacy reasons before data touches the cloud warehouse, or if the organization had legacy transformation systems designed to minimize BigQuery compute consumption.
While tools like Cloud Data Fusion effectively implement ETL when required, ELT remains the preferred pattern for high-volume analytics workloads in modern cloud environments.
Reverse ETL is the process of extracting transformed, enriched data and analytical insights from a centralized data warehouse like BigQuery and loading them into operational downstream tools, such as CRM systems, marketing platforms, or customer support databases.
The scenario stated that marketing teams had already modeled customer churn scores in BigQuery and needed to push those scores back to external advertising platforms or CRM applications.
Reverse ETL complements ELT pipelines by closing the loop between analytical insight generation and operational business execution.
The ELT (Extract, Load, Transform) pattern is a modern data integration architecture where data is extracted from source systems, loaded directly in its raw format into a scalable data warehouse such as BigQuery, and then transformed inside the destination engine using SQL, Dataform, or Data Manipulation Language (DML).

Compared to legacy ETL patterns, ELT maximizes the native parallel processing and storage scalability of BigQuery, minimizing data loading latency and providing flexibility for rapidly evolving analytical requirements.
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