You have historic data in Cloud Storage and need to detect invalid entries and apply transformations without coding or SQL knowledge. Which service should you use?
Choose an answer
Tap an option to check your answer.
Correct answer: Use Cloud Dataprep with recipes to detect errors and perform transformations..
Why this is the answer
Cloud Dataprep is a serverless, intelligent, and interactive data preparation service that allows users to visually explore, clean, and prepare data for analysis without writing code. Its "recipes" feature enables users to define a sequence of transformations and data quality rules through a user-friendly interface, making it ideal for users without coding or SQL knowledge. Cloud Dataflow with Beam requires coding skills (Java, Python, or Go) to define pipelines. Cloud Dataproc involves managing Hadoop clusters and writing jobs in languages like Java or Scala, which also requires coding. BigQuery federated tables allow querying external data but still necessitate SQL knowledge for transformations and error detection.
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