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 needs to ingest reporting data on a recurring daily schedule from SaaS platforms, including Salesforce and Google Ads, directly into BigQuery for analysis.
The team has the following requirements:
Which Google Cloud service should the team use?
Dataflow is a fully managed, serverless stream and batch processing service based on the open-source Apache Beam SDK, capable of real-time event stream analysis and large-scale parallel batch compute.
The scenario required streaming real-time events with complex event-time windowing, sub-second latency, or custom data transformations before writing to storage sinks.
Database Migration Service (DMS) is a managed service that facilitates high-fidelity, minimal-downtime migrations of operational relational databases (such as MySQL, PostgreSQL, and SQL Server) into Cloud SQL or AlloyDB for PostgreSQL.
The scenario required migrating an on-premises or third-party cloud PostgreSQL or MySQL database to Cloud SQL with minimal downtime.
Cloud Data Fusion is a fully managed, cloud-native data integration service that provides a graphical drag-and-drop interface (Pipeline Studio) for building, orchestrating, and managing complex Extract, Transform, and Load (ETL) and Extract, Load, and Transform (ELT) data pipelines.
The scenario required extensive data transformation, schema restructuring, data masking, or multi-source data joins before landing the data in BigQuery.
BigQuery Data Transfer Service (DTS) is a fully managed service that automates data movement from software-as-a-service (SaaS) applications, third-party cloud storage, and external databases directly into BigQuery on a scheduled basis.
bq command-line tool, or API without building data pipelines.BigQuery Data Transfer Service is purpose-built for loading SaaS and external source data directly into BigQuery on a managed schedule. Unlike Dataflow or Cloud Data Fusion, it eliminates the need to author code, build transformation graphs, or manage execution clusters.
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