Associate Data Practitioner

By Google · Question Mode

QuestionQ39

Data Preparation and Ingestion

You need to design a data pipeline that ingests data from CSV, Avro, and Parquet files into Cloud Storage. The data contains raw user input. You must remove all malicious SQL injections before storing the data in BigQuery. Which data-manipulation methodology should you select?

Explanation

ETL (extract, transform, load) transforms and sanitizes data before it reaches BigQuery. Removing malicious SQL-injection content before the BigQuery load therefore requires the transform step to occur before the load step. Google Cloud distinguishes this from ELT, in which raw data is loaded into BigQuery before transformation.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!