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 company needs to build a data pipeline that currently processes historical sales logs in batch from Cloud Storage, transforms the data, and loads it into BigQuery. In the near future, the company plans to ingest and transform live transactional events in real time from Pub/Sub using the exact same transformation logic and programming framework without rewriting application code.
Which Google Cloud service should the company use to implement this unified batch and stream data processing pipeline?
Dataflow is a fully managed Google Cloud service designed for large-scale, unified stream and batch data processing. Built on the open-source Apache Beam framework, Dataflow allows developers to write data processing pipelines in languages such as Java, Python, or Go that execute seamlessly across both bounded (batch) and unbounded (real-time streaming) data sources.
Dataflow is the purpose-built service for building complex, scalable ETL and ELT data pipelines in Google Cloud that require unified batch and streaming capabilities, custom data transformations, and automated resource management.
BigQuery Data Transfer Service (DTS) is a fully managed service designed to automate scheduled, recurring data imports into BigQuery from supported Software-as-a-Service (SaaS) applications and external cloud storage repositories.
The organization needed an automated, code-free schedule to periodically copy raw marketing report files from Google Ads or Cloud Storage directly into BigQuery without applying custom transformations or real-time event streaming.
Cloud Data Fusion is a fully managed, visual, code-free data integration platform built on top of the open-source CDAP (Cask Data Application Platform) ecosystem. It provides a graphical user interface (Studio) for constructing ETL/ELT pipelines.
The company required a code-free, drag-and-drop graphical interface for business analysts to visually design batch ETL pipelines from various on-premises databases into BigQuery without writing custom code.
Database Migration Service (DMS) is a fully managed service that facilitates high-fidelity, minimal-downtime migrations of relational databases (such as MySQL, PostgreSQL, and Oracle) to Cloud SQL or AlloyDB.
The organization required continuous replication to migrate an on-premises transactional MySQL or PostgreSQL database to a Cloud SQL instance with minimal application downtime.
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