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 retail analytics team needs to build a new data pipeline to ingest, clean, and transform transactional records from multiple database sources before loading them into their analytics storage.
The team has established the following requirements:
Which Google Cloud service should the team select?
Dataproc is a fully managed cloud service for running open-source big data processing engines, including Apache Spark, Apache Hadoop, Apache Flink, and Presto/Trino. It allows organizations to lift and shift existing on-premises big data clusters to Google Cloud infrastructure.
The organization had existing on-premises Apache Spark or Hadoop workloads that they wanted to migrate directly to Google Cloud without refactoring their open-source codebase.
Cloud Data Fusion is Google Cloud's fully managed, cloud-native data integration service that provides a graphical user interface for building and managing scalable ETL/ELT data pipelines. Built on the open-source CDAP (Cask Data Application Platform) framework, it allows organizations to ingest data from heterogeneous sources, apply complex transformations visually, and sink transformed datasets into analytics destinations such as BigQuery without writing underlying code.

Cloud Data Fusion is the optimal choice because it specifically targets users who need a no-code visual ETL interface. In contrast to programmatic frameworks like Dataflow or code-driven cluster solutions like Dataproc, Cloud Data Fusion accelerates time-to-value for business analysts while retaining robust distributed data processing capabilities.
Dataflow is Google Cloud's fully managed, serverless stream and batch data processing service based on the open-source Apache Beam SDK. It enables real-time message consumption, event-driven windowing, and distributed batch processing at massive scale with exactly-once processing guarantees.
PCollection, ParDo, and CombinePerKey.The scenario required a programmatic, real-time streaming pipeline where data engineers needed to write custom Python or Java code to process high-throughput events from Pub/Sub with millisecond latency and complex sliding time-window aggregations.
BigQuery is a serverless, highly scalable enterprise data warehouse designed for analytical data querying using standard SQL. It provides columnar storage, built-in machine learning (BigQuery ML), geospatial analysis, and business intelligence integrations.
The scenario stated that all raw data had already been ingested into tables within the cloud data warehouse, and analysts wanted to use standard SQL to filter, join, and aggregate tables inside the warehouse using an ELT design pattern.
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