AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: Scenario: You are loading CSV files from Cloud gcp video

Question 1 Be Honest
« Back   Next gcp data-engineer-pro Question »
Answer

Full Certification Question

Scenario: You are loading CSV files from Cloud Storage to BigQuery. The files have data quality issues like mismatched data types (STRINGs and INT64s in the same column) and inconsistent formatting (e.g., phone numbers and addresses). You need to create a data pipeline that ensures data quality and performs necessary cleansing and transformation. Question: What should you do to address the data quality issues during the data load process?