Google Cloud Professional Data Engineer — Question 188

Your business users need a way to clean and prepare data before using the data for analysis. Your business users are less technically savvy and prefer to work with graphical user interfaces to define their transformations. After the data has been transformed, the business users want to perform their analysis directly in a spreadsheet. You need to recommend a solution that they can use. What should you do?

Answer options

• A. Use Dataprep to clean the data, and write the results to BigQuery. Analyze the data by using Connected Sheets.
• B. Use Dataprep to clean the data, and write the results to BigQuery. Analyze the data by using Looker Studio.
• C. Use Dataflow to clean the data, and write the results to BigQuery. Analyze the data by using Connected Sheets.
• D. Use Dataflow to clean the data, and write the results to BigQuery. Analyze the data by using Looker Studio.

Correct answer: A

Explanation

Option A is correct because Dataprep provides an intuitive graphical interface for users to clean and prepare their data, and Connected Sheets allows for seamless analysis in a spreadsheet format. Options B and D suggest using Looker Studio, which is not suitable for spreadsheet analysis. Option C uses Dataflow, which is more complex and not designed for users who prefer graphical interfaces.