BenchMark Quizzes by MDFT Pro

Select Low-Code Transformation Tool

You work for MDFT Pro, a well-known training agency that offers certification preparation courses. Mark, the Project Manager, is planning a data engineering project and needs to select appropriate Microsoft Fabric items for the project team.

The project team consists of Power BI developers who specialize in creating reports and dashboards using Power Query for data preparation. They need to transform student enrollment data from multiple sources (CSV files, SQL databases, and web APIs) into a unified format for analysis. The transformations include cleaning data, merging tables, filtering records, and creating calculated columns. The team wants to use a low-code approach that leverages their existing Power BI and Power Query expertise to minimize the learning curve and development time.

What should Mark recommend for the project?

Choose the correct answer from the options below.

Explanations for each answer:

Data Pipeline is incorrect. Data pipelines are designed for orchestrating data workflows and require configuring various activities and connections. While they support some visual configuration, they don't provide the low-code Power Query interface that Power BI users are familiar with.
Dataflow Gen2 is correct. Dataflow Gen2 is the perfect choice because it uses the same Power Query interface that Power BI users already know. It provides a familiar, low-code visual experience for data transformation with drag-and-drop operations, allowing the team to leverage their existing Power BI skills without requiring extensive coding knowledge.
Eventstream is incorrect. Eventstream is designed for real-time streaming data scenarios, not batch data transformations. While it has some transformation capabilities, it doesn't provide the comprehensive low-code Power Query interface that Power BI users are accustomed to.
Notebook is incorrect. Notebooks require coding skills in Python, PySpark, SQL, or R and are not a low-code solution. They would require the Power BI team to learn programming languages, which contradicts the requirement to minimize development effort.

Learn more about creating Dataflow Gen2 dataflows:

Create Dataflow Gen2 Dataflows

Practice Exam

Select Low-Code Transformation Tool

Discuss this question on social media: