How to enable business users to clean and analyze data in spreadsheets?
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?
Community Votes
100% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
The question tests knowledge of user-friendly data preparation tools versus code-based pipelines and the distinction between spreadsheet interfaces and BI dashboards.
For business users requiring a GUI for data cleaning and spreadsheet analysis, using Dataprep with BigQuery and Connected Sheets is the recommended solution. The community agrees this combination best fits the requirement for low-code data preparation and familiar interfaces.
Choosing Dataflow (Option C or D) is a common mistake because it requires coding skills unsuitable for non-technical users, whereas Dataprep offers the necessary GUI.
Community Discussion (6 comments)
- Allow business users to perform their analysis in a familiar spreadsheet interface via Connected Sheets.
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Option A is correct because Dataprep is specifically designed as a serverless, visual data service for cleaning and preparing data without coding. It allows business users to inspect, clean, and transform data visually. Once the data is written to BigQuery, Connected Sheets enables these users to analyze the data directly within Google Sheets, a familiar spreadsheet interface, satisfying the specific constraints of the scenario.Why the Other Options Are Wrong
Options C and D are incorrect because Dataflow is a stream and batch data processing service that requires programming (Java or Python), which contradicts the requirement for users who are less technically savvy and prefer GUIs. Option B is incorrect because while Dataprep is the right tool for cleaning, Looker Studio is a visualization and dashboarding tool, not a spreadsheet interface; the users specifically requested analysis in a spreadsheet.Community Comment Notes
The community overwhelmingly supports Option A, noting the simplicity of the question compared to others. Comments highlight the alignment of Dataprep with the GUI requirement and Connected Sheets with the spreadsheet preference. One user explicitly pointed out that Connected Sheets allows analysis in a "familiar spreadsheet interface," which is a key keyword in the question.Official Reference
Exam Strategy
Focus on the user persona described in the question. Keywords like "less technically savvy" or "prefer GUI" immediately rule out code-heavy tools like Dataflow in favor of Dataprep.