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.
An analytics team needs to collect daily marketing metrics and customer transaction records stored in an external cloud provider's object storage (such as Amazon S3 or Azure Blob Storage). The team wants to load this data automatically into a BigQuery dataset on a recurring 24-hour schedule without writing custom extraction scripts or managing virtual servers.
Which Google Cloud service should the team configure to meet these requirements?
Dataproc is a fully managed cloud service for running open-source big data frameworks such as Apache Spark, Apache Hadoop, and Presto/Trino to perform distributed processing and complex analytics.
The team needed to perform heavy distributed in-memory data processing, custom graph computations, or execute existing open-source Spark/Hadoop workflows before loading outputs to BigQuery.
Cloud Composer is a managed workflow orchestration service built on Apache Airflow. It allows data engineers to author, schedule, and monitor complex multi-step data pipelines using Directed Acyclic Graphs (DAGs) written in Python.
The requirements involved orchestrating a complex, multi-stage data processing workflow with intricate branch logic, cross-system dependencies, and multiple dependent ETL tasks across various cloud platforms.
Storage Transfer Service is a Google Cloud service optimized for moving large volumes of unstructured data and files between different storage repositories, such as between Amazon S3, Azure Blob Storage, on-premises file systems, and Cloud Storage buckets.
The scenario required moving petabytes of raw backup files, images, or media archives from Amazon S3 or on-premises storage into a Cloud Storage bucket for long-term archiving.
BigQuery Data Transfer Service (DTS) is a fully managed, serverless service designed to automate data movement directly into BigQuery datasets on a scheduled, recurring basis. It enables organizations and analytics teams to establish seamless ingestion pipelines from various external cloud providers, SaaS platforms, and internal Google services without writing custom code or managing underlying infrastructure.

bq command-line tool, or the Data Transfer Service API without developing custom extract-transform-load (ETL) scripts.WRITE_APPEND (for incremental batch additions) and WRITE_TRUNCATE (for complete table refreshes).BigQuery Data Transfer Service is the purpose-built solution in Google Cloud for loading external cloud and SaaS data directly into BigQuery. It eliminates maintenance overhead, reduces implementation time from weeks to minutes, and ensures reliable, automated scheduled delivery.
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