You have a Power BI data model that contains a table named Employees. The table has the following columns:• Employee Name• Email Address• Start Date• Job TitleYou are implementing dynamic row-level security (RLS).You need to create a table filter to meet the following requirements:• Users must see only their own employee data.• The DAX expression must work in both Power BI Desktop and the Power BI service.Which expression should you use?
Answer(s): D
DRAG DROP (Drag and Drop is not supported)You have the Power BI data model shown in the following exhibit.The Country table contains the following data.You create two row-level security (RLS) roles named Manager and CFO.You plan to publish the dataset to the Power BI service.You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:• Each manager must see only the data in the Sales and Human Resources tables for their own country.• The CFO must be prevented from seeing the data in the Human Resources table.• The CFO must see the sales data of all countries.How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.
Answer(s): A
You have a Power BI data model that imports data from a Microsoft Excel spreadsheet.You use Power Query to load a query that contains both renamed and custom columns.Later, you attempt to reload the query and receive the following error message.Expression.Error: The column 'Category' of the table wasn't found.What are two possible causes of the error? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
Answer(s): A,B
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:• Order Line ID• Product ID• Unit Price• Order ID• QuantityOrders are uniquely identified by using the order ID and can have multiple order lines. Each order line within an order contains a different product ID.You need to write a DAX measure that counts the number of orders.Which formula should you use?
HOTSPOT (Drag and Drop is not supported)You are creating a Power BI model in Power BI Desktop.You need to create a calculated table named Numbers that will contain all the integers from -100 to 100.How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.
Post your Comments and Discuss Microsoft PL-300 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the PL-300 content, but please register or login to continue.