
Ultimate access to all questions.
You have a collection of historical data stored in Cloud Storage that you need to analyze. You're looking for a solution that can spot invalid data entries and carry out data transformations without the need for programming or SQL expertise. Which of the following options would best meet your needs?
A
Leverage Cloud Dataproc with a Hadoop job to detect errors and transform data.
B
Employ federated tables in BigQuery with queries to identify errors and transform data.
C
Use Cloud Dataflow with Beam to detect errors and transform data.
D
Opt for Cloud Dataprep with recipes to visually detect errors and transform data without coding.