Associate Data Practitioner · Free Practice Question Medium
Question 22
You need to perform complex data cleaning on a dataset with inconsistent formatting before loading it into BigQuery. Which Google Cloud service provides the most user-friendly, visual interface for this task?
-
A
Dataprep by Trifacta
-
B
Dataflow
-
C
BigQuery
-
D
Cloud Functions
Reveal correct answer
Correct answer: A
Explanation
Option A is CORRECT. Dataprep by Trifacta is specifically designed for visual data preparation with a no-code interface. It provides intelligent suggestions for data cleaning operations, allows you to see transformations in real-time, and offers a point-and-click interface for handling inconsistent data formats. It's purpose-built for making data cleaning accessible to users without extensive coding experience.
Option B is INCORRECT. Dataflow requires coding in Java or Python to define transformation pipelines. While powerful and scalable, it doesn't provide the user-friendly visual interface that would make complex data cleaning more accessible.
Option C is INCORRECT. BigQuery is primarily a data warehousing and analytics service. While you can perform some transformations using SQL, it doesn't offer visual tools specifically designed for complex data cleaning of inconsistently formatted data.
Option D is INCORRECT. Cloud Functions is a serverless compute service that requires writing code to implement transformations. It lacks the visual interface and built-in data cleaning capabilities that would make the task more accessible.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
