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 loaded raw customer transaction records directly into a BigQuery table. Before the dataset can be analyzed, the team must perform several data cleaning tasks:
Which BigQuery transformation method should the team use to perform these in-place data cleaning operations?
BigQuery Data Transfer Service (DTS) is a fully managed service that automates scheduled data ingestion and data movement into BigQuery from external software-as-a-service (SaaS) applications, cloud storage platforms, and third-party databases.
The scenario required setting up an automated, recurring pipeline to ingest marketing performance metrics from Google Ads or an Amazon S3 bucket directly into BigQuery without writing custom ingestion scripts.
Storage Transfer Service is a scalable, managed service designed to transfer large volumes of unstructured or file-based data between different cloud storage providers (such as Amazon S3 or Azure Blob Storage), on-premises repositories, and Cloud Storage buckets.
The requirement was to migrate terabytes of raw CSV or Parquet files from an Amazon S3 bucket or on-premises storage into Google Cloud Storage before starting an ingestion pipeline.
Transfer Appliance is a high-capacity, physical storage hardware device provided by Google Cloud to physically ship massive amounts of offline data (from 20 TB up to petabytes) from on-premises data centers into Cloud Storage.
The organization needed to migrate 100 TB of legacy on-premises historical data to Google Cloud within a limited timeframe and had insufficient internet bandwidth to upload it over the network.
Data Manipulation Language (DML) in BigQuery consists of standard GoogleSQL statements (UPDATE, DELETE, INSERT, MERGE, and TRUNCATE) that allow users to mutate and manipulate data stored directly inside existing BigQuery tables.
UPDATE statement can easily scan table columns and replace NULL entries with standard defaults (such as 0 or 'Unknown').DELETE or MERGE statement can identify and remove duplicate rows based on primary keys or timestamp logic directly within the table.When raw data is already stored inside BigQuery, executing SQL DML statements provides the simplest, lowest-friction, and most cost-effective method to cleanse and prepare data in place before downstream reporting.
Change the inputs and watch how the outcome changes.

Pick a method and a goal to see how the pipeline reacts.
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