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?

The correct response must have both of the following products be the correct products to use: (1) Dataprep vs Dataflow - Dataprep provides an accessible UI for wrangling data, whereas Dataflow requires writing code or SQL. (2) Connected Sheets vs Looker Studio - Connected Sheets allows viewing BQ data in a spreadsheet as the users wanted, whereas Looker Studio is a dashboard. Option A is correct because Dataprep and Connected Sheets are correct. Option B is incorrect because Dataprep is correct, but using Looker Studio is incorrect. Option C is incorrect because using Dataflow is incorrect, but using Connect Sheets is correct. Option D is incorrect because using Dataflow and Looker Studio are both incorrect.