PROFESSIONAL-DATA-ENGINEER · Question #228
PROFESSIONAL-DATA-ENGINEER Question #228: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #228. The question stem and answer options stay visible for context.
Question
You receive data files in CSV format monthly from a third party. You need to cleanse this data, but every third month the schema of the files changes. Your requirements for implementing these transformations include: Executing the transformations on a schedule Enabling non-developer analysts to modify transformations Providing a graphical tool for designing transformations What should you do?
Options
- AUse Cloud Dataprep to build and maintain the transformation recipes, and execute them on a scheduled basis
- BLoad each month's CSV data into BigQuery, and write a SQL query to transform the data to a standard schema.
- CHelp the analysts write a Cloud Dataflow pipeline in Python to perform the transformation.
- DUse Apache Spark on Cloud Dataproc to infer the schema of the CSV file before creating a Dataframe.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.