PL-300 Free Practice Questions — Page 14

Question 122

HOTSPOT - You have a Power BI tenant that contains a workspace. The workspace contains a dataset named datasetA. You need to build a pivot table report in Microsoft Excel. The report must use datasetA as the data source. The solution must meet the following requirements: • Ensure that the report can be refreshed to get the latest available data from the Power BI service. • Ensure that all the visible data in datasetA is available for use in Excel. What should you do to connect Excel to datasetA, and which element in datasetA will be incompatible with the Excel connection? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 123

HOTSPOT - You use Power Query Editor to pull data from a Microsoft SharePoint Online list. You plan to use Advanced Editor to build a Power Query M formula language query. You need to create a query that loads the data, expands a column named location, and hides a column named CountryOrRegion from the dataset. How should you complete the query? To answer, select the appropriate options in the answer area. NOTE: Each correct answer is worth one point.

Question 124

DRAG DROP - You plan to use Power BI to create a quarterly profit report that meets the following requirements: • Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage • Compares profit margins across sales regions Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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 125

You use Power Query Editor to preview a query that contains sales order data in the following columns: • Tax Amount • Sales Order ID • Freight Amount • Subtotal Amount • Total Item Quantity The Sales Order ID column uniquely identifies each sales order. The Subtotal Amount and Total Item Quantity columns are always populated, but the Tax Amount and Freight Amount columns are sometimes null when an order has no associated amount. You need to query the data to identify the following metrics by month: • The average item quantity per order • The average freight amount per order • The maximum item quantity per order How should you modify the query?

Question 126

You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network. You are notified that the Excel data source was moved to a new location. You need to update the PBIX file to use the new location. What are three ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Question 127

HOTSPOT - You have a folder that contains 50 JSON files. You need to use Power BI Desktop to make the metadata of the files available as a single dataset. The solution must NOT store the data of the JSON files. Which type of data source should you use, and which transformation should you perform? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 128

You have the CSV file shown in the following table. You use Power Query Editor to preview the data in the file. You need to transform the data to meet the following requirements: • The first column must contain the month. • The second column must contain the year. • The third column must contain the order amount for the month and year. Which transformation should you use first?

Question 129

You have a Power BI report. The report contains a line chart that displays sales data for several regions. You need to add an element to the report that will enable users to filter the sales data to include only a selected region. Which two elements achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Question 130

You have a Power BI dataset that contains quarterly sales performance data. You need to enable managers to review the data in a format that meets the following requirements: • Is optimized for printing. • Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats. What should you create?

Question 131

You have a Power BI model that contains a table named Employees. The table contains the following columns: • Employee ID • First Name • Last Name • Department • Salary Each employee is uniquely identified by using Employee ID. You need to create a DAX measure that will calculate the average salary of all the employees in the sales department. Which DAX expression should you use?