You Store Historic Data in Cloud Storage

Multiple Choice

You store historic data in Cloud Storage. You need to perform analytics on the historic data. You want to use a solution to detect invalid data entries and perform data transformations that will not require programming or knowledge of SQL. What should you do?

A) Use Cloud Dataflow with Beam to detect errors and perform transformations.
B) Use Cloud Dataprep with recipes to detect errors and perform transformations.
C) Use Cloud Dataproc with a Hadoop job to detect errors and perform transformations.
D) Use federated tables in BigQuery with queries to detect errors and perform transformations.