Explanation:
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.
Ultimate access to all questions.
No comments yet.
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.