PL-300 Deploy and maintain assets Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✓

  Open Model view, drag a column from one table to a column in another table, configure cardinality and cross-filter direction in the Edit Relationship dialog, then click OK.

  Why this is correct

  This is the correct order because creating a relationship in Power BI Desktop requires first accessing the Model view where tables are displayed, then dragging a column from one table to the matching column in another table. This opens the Edit Relationship dialog where you must verify and configure cardinality and cross-filter direction before finalizing by clicking OK.

• ✗

  Open Model view, click on the table to select it, then click on the 'Create Relationship' button in the ribbon, then select the columns from a dropdown menu, then click OK.

  Why it's wrong here

  This is incorrect because although you can create relationships via the ribbon, the typical drag-and-drop method is the most common and the question implies drag-and-drop. Additionally, the described steps omit the crucial step of dragging columns and may lead to confusion about the relationship creation workflow.

• ✗

  Open Model view, drag a column from one table to the other table header, then in the dialog that appears, choose the cardinality, then click OK.

  Why it's wrong here

  This is incorrect because dragging a column to the table header does not create a relationship; you must drag to a specific column in the target table. Additionally, the cross-filter direction configuration is missing, which is an essential part of the relationship setup.

• ✗

  Open Model view, configure cardinality and cross-filter direction in the Edit Relationship dialog, then drag a column from one table to a column in another table, then click OK.

  Why it's wrong here

  This option inverts the required workflow: the Edit Relationship dialog in Power BI Desktop is not accessible beforehand; it is only invoked after you physically drag a column from one table and drop it onto a matching column in another table. Prior to that drag action, there is no dialog open and no way to configure cardinality or cross-filter direction, because the relationship doesn't yet exist to edit. Even if you attempted to open the dialog via the ribbon, the column pair must first be selected or the drag initiated, so the order described here is impossible to execute.

Go deeper

Related to this question