Associate Data Practitioner

By Google · Question Mode

QuestionQ28

Data Preparation and Ingestion

You are working with a large dataset of customer reviews stored in Cloud Storage. The dataset has several inconsistencies, including missing values, incorrect data types, and duplicate entries. You must clean the data so it is accurate and consistent before analyzing it. What should you do?

Explanation

BigQuery can batch load large datasets directly from Cloud Storage. SQL can then perform set-based data-quality transformations, such as handling missing values, casting incorrect types, and removing duplicate rows, before analytical queries run. This is the appropriate managed batch-processing approach when no real-time or custom-processing requirement is stated.

Learn more

Community Discussion

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