Nontechnical business users need a GUI to clean and prepare data, then analyze results directly in a spreadsheet. Which solution meets both needs?
Choose an answer
Tap an option to check your answer.
Correct answer: Use Dataprep to clean data, write results to BigQuery, and analyze with Connected Sheets..
Why this is the answer
The correct solution is to use Dataprep to clean data, write results to BigQuery, and analyze with Connected Sheets. Dataprep provides a GUI for nontechnical users to clean and prepare data. Writing the results to BigQuery ensures the data is stored in a scalable, analytical database. Connected Sheets allows users to directly analyze BigQuery data within Google Sheets, a familiar spreadsheet interface. The other options are incorrect because: Looker Studio (formerly Data Studio) is a dashboarding tool, not a spreadsheet for direct analysis. Dataflow is a powerful programming-based service for data processing, not a GUI tool for nontechnical users.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed