Answer-first summary for fast verification
Answer: Employ Dataprep for data cleaning, output the results to BigQuery, and analyze the data using Connected Sheets.
**Correct Answer: B** - **Dataprep** is designed for users who prefer graphical interfaces, allowing them to visually explore, clean, and prepare data without coding. This makes it ideal for less technically savvy business users. - **BigQuery** serves as a scalable and cost-effective data warehouse, ensuring that the cleaned data is stored securely and is readily accessible for analysis. - **Connected Sheets** enables users to analyze BigQuery data directly within Google Sheets, catering to those who favor spreadsheet environments for their analysis. **Why other options are less suitable:** - **A & D:** Looker Studio, while powerful, may present a steeper learning curve for users unfamiliar with business intelligence tools. - **C:** Dataflow, being a tool for real-time data processing, might be too complex for users who prefer simple, graphical interfaces for data preparation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
For business users with limited technical expertise who need a straightforward tool to clean and prepare data using graphical interfaces and prefer analyzing data directly in a spreadsheet, which solution would you recommend?
A
Utilize Dataflow for data cleaning, output the results to BigQuery, and analyze the data with Looker Studio.
B
Employ Dataprep for data cleaning, output the results to BigQuery, and analyze the data using Connected Sheets.
C
Use Dataflow for data cleaning, output the results to BigQuery, and analyze the data with Connected Sheets.
D
Apply Dataprep for data cleaning, output the results to BigQuery, and analyze the data using Looker Studio.
No comments yet.