Google Cloud Professional Data Engineer PDE — Topic 1 Question 190

Question

You are loading CSV files from Cloud Storage to BigQuery. The files have known data quality issues, including mismatched data types, such as STRINGs and INT64s in the same column, and inconsistent formatting of values such as phone numbers or addresses. You need to create the data pipeline to maintain data quality and perform the required cleansing and transformation. What should you do?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Use Data Fusion to transform the data before loading it into BigQuery. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. Cloud Data Fusion builds ETL/ELT pipelines visually with little code.

Google Cloud Professional Data Engineer PDE — Question 190