DP-600 Fabric Analytics Engineer Practice Exam

In Power Query Editor, which tab would you use to create a derived column based on a conditional statement?

Home Transform Add column View

Correct Answer:

Add column

Explanation:

To build a new column whose values come from a condition, you create a derived column by adding a new column and defining its value with a conditional rule. The tab that contains this capability is Add Column, where you can choose Conditional Column (for if/then/else rules) or use Custom Column for a broader M expression. The other tabs serve different tasks: Home for general actions, Transform for altering existing columns, and View for UI options. So the Add Column tab is the place to create a derived column based on a conditional statement.

Access more questions from this quiz

Continue to DP-600 Fabric Analytics Engineer Practice Exam for more practice questions and the full quiz experience.

Access More Questions