Google Cloud Professional Data Engineer — Question 3

You store historic data in Cloud Storage. You need to perform analytics on the historic data. You want to use a solution to detect invalid data entries and perform data transformations that will not require programming or knowledge of SQL.
What should you do?

Answer options

• A. Use Cloud Dataflow with Beam to detect errors and perform transformations.
• B. Use Cloud Dataprep with recipes to detect errors and perform transformations.
• C. Use Cloud Dataproc with a Hadoop job to detect errors and perform transformations.
• D. Use federated tables in BigQuery with queries to detect errors and perform transformations.

Correct answer: B

Explanation

The correct answer is B because Cloud Dataprep is designed for data preparation and allows users to detect and transform data without requiring programming skills. Option A, while useful for processing, requires more technical knowledge, and options C and D involve more complex setups that do not align with the requirement for no programming or SQL knowledge.