PL-300 Online Practice Questions and Answers
Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add?
A. video
B. custom streaming data
C. text box
D. web content
You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?
A. Use the Test as role option to view data as the salesperson's user account.
B. Use the Test as role option to view data as the Sales role.
C. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.
You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using QandA. You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using QandA. The solution must minimize the size of the model.
What should you do?
A. Add a description of "subscriber count" to the Customer Count measure.
B. Set Summarize By to None for the CustomerlD column.
C. Add a description of "Subscriber" to the Customer table.
D. Add a synonym of "subscriber" to the Customer table.
You have a Power B1 report named ReportA.
You have a Power B1 tenant that allows users to export data.
You need to ensure that consumers of ReportA cannot effort any data from visuals.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE Each correct selection is worth one point.
A. From Power B1 Desktop, modify the Data Load settings
B. From the answer B1 service modify the Report settings.
C. From Power B1 Desktop modify the Report settings
D. From the Power B1 service, modify the dataset permissions.
You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
Due Date
Order Date
Delivery Date
You need to support the analysis of sales over time based on all three dates at the same time.
Solution: You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table.
Does this meet the goal?
A. Yes
B. No
You have five reports and two dashboards in a workspace.
You need to grant all organizational users read access to one dashboard and three reports
Solution: In Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra. you create a group that contains all the users. You share each selected report and the one dashboard to the group.
Does this meet the goal?
A. Yes
B. No
HOTSPOT
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.
You need to develop a measure to support the visual.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
