PL-300 Free Practice Questions — Page 5

Question 31

HOTSPOT - You have a semantic model that has the relationships 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.

Question 32

HOTSPOT - You import a Microsoft Excel spreadsheet into Power Query Editor and name the query Sales_Spreadsheet. Sales_Spreadsheet contains the following columns: • Customer ID • Customer Name • Date • Total Sales Amount You plan to use the Sales Spreadsheet query to load two tables named Customer and Sales into the associated semantic model. The tables relate to each other on the Customer ID column of each query. The solution must meet the following requirements: • The Customer query must contain the Customer ID and Customer Name columns. • The Sales query must contain the Customer ID, Date, and Total Sales Amount columns. • Power Query logic must be consolidated to avoid the duplication of logic across the queries and ensure that only one location is used to update the logic. You need to identify how to create the Sales query, and what to do to the Sales_Spreadsheet query before loading the model? What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 33

DRAG DROP - You have a Power BI semantic model that contains two tables named Dim Location and Fact Deliveries. The relationships between the tables are configured as shown in the following table. The model contains one measure that has the following formula. Deliveries = COUNTROWS(‘Fact Deliveries’) You need to create a new measure that counts the number of deliveries based on the destination location. How should you complete the DAX expression? To answer, drag the appropriate functions to the correct targets. Each function 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.

Question 34

You have a Microsoft Fabric eventhouse named Eventhouse1 that contains high-velocity and high-volume data from IoT devices. Eventhouse1 can be queried to deliver data to reports in near-real-time (NRT). You plan to use Power BI Desktop to create a report that will contain both historical and live data. You need to connect to Eventhouse1. The solution must minimize development effort. What should you do?

Question 35

You have a PBIX file that contains sensitive information. You need to secure the information to meet the following requirements: • Only internal users must be able to open the file if the file is shared via email. • Once the file is published, only internal users must be able to open the semantic model and the report downloaded from the Power BI service. What should you do?

Question 36

You have a Fabric workspace named Workspace1 that contains two Power BI reports named Report1 and Report2. You create a workspace app that contains both reports. You need to ensure that the app meets the following requirements: • Report1 must be visible to all the users in your organization. • Report2 must be visible to only a security group named Group1. What should you do next?

Question 37

HOTSPOT - You have a Fabric workspace that contains the items shown in the following table. You need to make content available to the management department and the accounting department at your company. The solution must meet the following requirements: • The management department must have view access to the Headcount and Department Expenses reports. • The management department must NOT be able to view any other current or future reports. • The management department must NOT be able to build new reports by using the semantic models. • The accounting department must only be able to view the Company Expenses report. • The accounting department must be able to build new reports by using the Expenses semantic model. The solution must follow the principle of least privilege and minimize administrative effort. How should you make the content available to the users in each department? To answer, select the appropriate options in the answer area. NOTE: Each collect selection is worth one point.

Question 38

HOTSPOT - You have the Performance analyzer results 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.

Question 39

You are creating a Power BI report that will contain multiple visuals. You need to ensure that the report is accessible to users who use a screen reader. Which two configurations should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Question 40

You are creating a visual in a Power BI report. The associated semantic model contains sales from the last four years for three products. You need to display the total sales by quarter categorized by product. The visual must display trends in both total sales and individual product sales. Which type of visual should you use?