PL-300 exam

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns: ✑ Customer ID ✑ Customer Name ✑ Phone ✑ Email Address ✑ Address ID Address contains the following columns: ✑ Address ID ✑ Address Line 1 ✑ Address Line 2 ✑ City...

You have the visual shown in the Original exhibit. {Click the Original tab.) You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.) What should you add to the visual?A . a measureB . a trendlineC . a forecastD . an Average lineView AnswerAnswer:...

DRAG DROP You receive revenue data that must be included in Microsoft Power Bl reports. You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit. You plan to create several visuals from the data, including a visual that shows revenue split...

HOTSPOT You have a report page that contains the visuals 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. View AnswerAnswer: Explanation: Box 1: cross-filter...

You have the following three versions of an Azure SQL database: ✑ Test ✑ Production ✑ Development You have a dataset that uses the development database as a data source. You need to configure the dataset so that you can easily change the data source between the development, test, and...

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. 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...

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.) What occurred at 12:03:06 PM?A . A user pressed F5B . A new transaction...

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure. You need to load only the manufacturing reports to a table for analysis. What should you...

DRAG DROP You have a Microsoft Power Bl workspace. You need to grant the user capabilities shown in the following table. The solution must use the principle of least privilege. Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each...

HOTSPOT You need to create the Top Customers report. Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Top N...