Exam Professional Data Engineer topic 1 question 145 discussion

A should be the answer

Why there are so many wrong answers? Examtopics.com are you enjoying paid subscription by giving random answers from people? Ans: A

A. Use Dataprep by Trifacta to build and maintain the transformation recipes, and execute them on a scheduled basis Addresses Requirements: Scheduled Execution: Dataprep supports running transformations on a schedule. Analyst-Friendly: Dataprep's visual interface is designed for non-developer analysts to build and modify transformations easily. Graphical Tool: It provides a drag-and-drop environment for designing data transformations. Schema Flexibility: Dataprep can handle schema changes. Analysts can adapt recipes using the visual interface

Scheduled Transformations: Dataprep by Trifacta allows you to design and schedule transformation recipes to process data on a regular basis. You can automate the data cleansing process by scheduling it to run monthly. User-Friendly Interface: Dataprep provides a user-friendly graphical interface that enables non-developer analysts to design, modify, and maintain transformation recipes without writing code. This empowers analysts to work with the data effectively. Transformation Flexibility: Dataprep supports flexible data transformations, making it suitable for scenarios where the schema of the incoming data changes. Analysts can adapt the transformations to new schemas using the visual tools provided by Dataprep.

Providing a graphical tool for designing transformations is enough for A

Your company receives a lot of financial data in CSV files. The files need to be processed, cleaned and transformed before they are made available for analytics. The schema of the data also changes every third month. The Data analysts should be able to perform the tasks 1. No prior knowledge of any language with no coding 2. Provided a GUI tool to build and modify the schema What solution best fits the need?

A is the answer. https://cloud.google.com/dataprep Dataprep by Trifacta is an intelligent data service for visually exploring, cleaning, and preparing structured and unstructured data for analysis, reporting, and machine learning. Because Dataprep is serverless and works at any scale, there is no infrastructure to deploy or manage. Your next ideal data transformation is suggested and predicted with each UI input, so you don’t have to write code.

non-developer analysts

Dataprep is for non developers

Option A -- Dataprep is the right answer

Answer is A

A: https://cloud.google.com/dataprep/

Cloud Dataprep is a tool to do the job.

vote for option A

Vote for 'A', because of requirement - Enabling non-developer analysts to modify transformations

A is correct

Answer should be D. Dataprep will detect schema automatically in the initial recipe.After 3 months if the schema is changed the scheduled dataprep job cannot handle. So D should be the option.