PL-300: Microsoft Power BI Data Analyst

PL-300: Microsoft Power BI Data Analyst practice questions, page 15 of 17, with answer review and explanations.

Question 71

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?

  1. From Model view, set the Subject and Body columns to Hidden.
  2. Remove the Subject and Body columns during the import.
  3. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Question 72

You create a Power BI dataset that contains the table shown in the following exhibit. You need to make the table available as an organizational data type in Microsoft Excel. How should you configure the properties of the table? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

Question 73

You have the Power BI model shown in the following exhibit. A manager can represent only a single country. You need to use row-level security (RLS) to meet the following requirements: ✑ The managers must only see the data of their respective country. ✑ The number of RLS roles must be minimized. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  1. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
  2. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
  3. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
  4. Create one role for each country.
  5. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

Question 74

You have a Power BI imported dataset that contains the data model shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Hot Area:

Question 75

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales. You need to create a measure that calculates the total sales from the equivalent month of the previous year. How should you complete the calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: