Answer-first summary for fast verification
Answer: Use Dataprep to clean the data, and write the results to BigQuery. Analyze the data by using Connected Sheets.
The correct answer is A. The task requires a user-friendly, graphical interface for data transformation, which Dataprep provides. After cleaning and preparing the data with Dataprep, the results can be written to BigQuery. For analysis directly in a spreadsheet, Connected Sheets is the ideal choice as it integrates with Google Sheets, allowing business users to analyze BigQuery data within the familiar spreadsheet interface. This meets the requirement of the business users who prefer less technical, spreadsheet-based analysis.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your business users require a solution to cleanse and prepare data before it is utilized for analytical purposes. Given that these users are not highly technical, they favor utilizing graphical user interfaces to define their data transformations. Once the data has been transformed, they wish to conduct their analysis directly within a spreadsheet application. What solution would you recommend to satisfy their needs?
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.
No comments yet.