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 data analytics team has raw transactional data already loaded into Google BigQuery tables. The team wants to transform this data within BigQuery using SQL-based logic. They need a tool that natively supports SQLX definitions, version control, table dependency management, and scheduled pipeline execution without managing external compute infrastructure.
Which Google Cloud tool should the team use?
Dataflow is a fully managed, serverless stream and batch data processing service based on the open-source Apache Beam SDK.
The scenario required streaming real-time event data from Pub/Sub, performing sliding-window aggregations, and writing the enriched records into BigQuery with sub-second latency.
Dataproc is a managed service for running open-source distributed big data frameworks such as Apache Spark, Apache Hadoop, Presto, and Hive on Google Cloud infrastructure.
The team needed to migrate existing on-premises Apache Spark or Hadoop batch jobs to Google Cloud to process petabytes of unstructured files stored in Cloud Storage.
Dataform is a fully managed service within Google Cloud designed for data analysts and data engineers to build, version control, test, and schedule complex SQL-based data transformation pipelines directly inside BigQuery (an ELT approach).

When data is already in BigQuery and transformations can be expressed in SQL, Dataform provides an integrated, serverless ELT modeling framework with software engineering best practices (versioning, testing, modularity) without the maintenance burden of separate workflow clusters.
Storage Transfer Service is a fully managed service for moving large volumes of unstructured data into Cloud Storage from other cloud providers (such as AWS S3 or Azure Blob Storage), on-premises file systems, or between Cloud Storage buckets.
The team needed to transfer terabytes of raw CSV or Parquet files from an Amazon S3 bucket into Google Cloud Storage on a recurring schedule.
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