Answer-first summary for fast verification
Answer: Cloud Dataprep by Trifacta
**Correct Option:** B. Cloud Dataprep by Trifacta: This is the correct choice because it is specifically designed for data preparation and cleaning, offering an interactive and visual interface to clean, transform, and enrich data before loading it into a data warehouse like BigQuery. It simplifies the process of data wrangling, making it easier to handle complex data transformations without requiring extensive coding. **Incorrect Options:** A. Cloud Run: This is incorrect because Cloud Run is a fully managed compute platform for running containerized applications and is not tailored for data preparation tasks. C. Cloud Functions: This is incorrect because Cloud Functions is a serverless compute service for running small pieces of code in response to events and is not designed for preprocessing and cleaning data before loading it into a data warehouse. D. Cloud SQL: This is incorrect because Cloud SQL is a fully managed relational database service for hosting relational databases and is not designed for data preparation and cleaning tasks.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In the context of preparing data for analysis in a data warehouse, you are tasked with selecting the most appropriate Google Cloud service for preprocessing and cleaning large datasets. The solution must support visual data wrangling, handle complex transformations without extensive coding, and integrate seamlessly with BigQuery for loading the processed data. Given these requirements, which of the following services should you choose? (Choose one correct option)
A
Cloud Run
B
Cloud Dataprep by Trifacta
C
Cloud Functions
D
Cloud SQL
No comments yet.