You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.You add the following fields to the Explain By field:* Customer Country* Product Category* Supplier Country* Sales Employee* Supplier Name* Product Name* Customer CityThe key influencers visual returns the results shown in the following exhibit. What can you identify from the visual?

Customers in Austria order 18.8 more units than the average order quantity.

Customers in Boise order 20.37 percent more than the average order quantity.

Product Category positively influences the quantity per order.

Customers in Cork order lower quantities than average.

You have a Microsoft Excel file on a file server.You create a Power BI report and import a table from the Excel file.You publish the report.You need to ensure that the data refreshes every four hours.What should you do first?

Deploy an on-premises data gateway.

Upload the Excel file to a Power BI workspace.

Create a subscription to the report.

Deploy an on-premises data gateway.

Edit the data source credentials.

You are creating a dashboard by using the Power Bl service.You have an existing report page that contains three charts.You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do?

Pin the report page as a live tile.

Edit interactions in the report and set all interactions to Filter

Edit the dashboard theme and pin each chart as a file.

Pin the report page as a live tile.

You have a dataset that is used infrequently and refreshes every hour.You receive a notification that the refresh was disabled due to inactivity.Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

From the Power BI service, open a dashboard that uses the dataset.

From the Power BI service, open a report that uses the dataset.

Enable query caching for the dataset.

Import the dataset to Microsoft Excel.

From the Power BI service, open a dashboard that uses the dataset.

From the Power BI service, open a report that uses the dataset.

From PowerShell, run the get-powerbireport cmdlet.

In Power BI Desktop, you are creating a report that will contain three pages.You need to create a custom tooltip page and prepare the page for use.Which three actions should you perform? Each correct answer presents part of the solution.

For the target page, set Allow use as tooltip to On.

Add and configure visuals on the tooltip page.

For the tooltip page, set Allow use as tooltip to On.

Configure filters on the target visual.

For the target page, set Allow use as tooltip to On.

Add and configure visuals on the tooltip page.

For the tooltip page, set Allow use as tooltip to On.

For the tooltip page, configure filters.

You are creating a query to be used as a Country dimension in a star schema.A snapshot of the source data is shown in the following table. You need to create the dimension. The dimension must contain a list of unique countries.Which two actions should you perform? Each correct answer presents part of the solution.

Remove duplicates from the Country column.

Remove duplicates from the City column.

Remove duplicates from the table.

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the fol-lowing format:2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

Apply a transformation to extract the first 11 characters of the Logged column.

Create a column by example that starts with 2018-12-31.

Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

Apply a transformation to extract the first 11 characters of the Logged column.

split the Logged column by using at as the delimiter.

You are building a Power Bl report.Users will view the report by using their mobile device.You need to configure the report to display data based on each user s location.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Use the columns of the geography data type in all visuals.

In Data Category, set the geographic data category for the relevant columns.

For the relevant columns, set synonyms to match common geographical terms.

From Power Query Editor, detect the data types of the relevant columns.

Use the columns of the geography data type in all visuals.

Create a hierarchy for columns of the geography data type.

In Data Category, set the geographic data category for the relevant columns.

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 use Power Bl Desktop to load only the manufacturing reports to a table for analysis.What should you do?

Get data from a SharePoint folder and enter the site URL. Select Transform, then filter by the folder path to the manufacturing reports library,

Get data from a SharePoint folder, enter the site URL and then select Combine & Load

Get data from a SharePoint list and enter the site URL Select Combine & Transform, then filter by the folder path to the manufacturing reports library.

Get data from a SharePoint list enter the site URL and then select Combine & Load

Get data from a SharePoint folder and enter the site URL. Select Transform, then filter by the folder path to the manufacturing reports library,

You are building a data model for a Power Bl report. You have data formatted as shown in the following table. You need to create a clustered bar chart as shown in the following exhibit. What should you do?

From Power Query Editor, split the Machine-User column by using a delimiter.

In a DAX function, create two calculated columns named Machine and User by using the substitute function.

From Power Query Editor, create a column that contains the last three digits of the Machine-User column.

in a DAX function, create two measures named Machine and User by using the substitute function.

You have a Power Bl report that contains a page. The page contains the following:• A shape named Shape 1• A card named Sales Summary• A clustered bar chart named Sales by RegionYou need to ensure that Sales Summary renders on top of Shape 1. What should you modify?

Layer order in the Selection pane

Tab order in the Selection pane

Layer order in the Selection pane

Maintain layer order in the General visual settings

Vertical alignment in the Canvas settings

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.

From the answer B1 service modify the Report settings.

From the Power B1 service, modify the dataset permissions.

From Power B1 Desktop, modify the Data Load settings

From the answer B1 service modify the Report settings.

From Power B1 Desktop modify the Report settings

From the Power B1 service, modify the dataset permissions.

You have data in a Microsoft Excel worksheet as shown in the following table. You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:* If the discount column returns an error, a discount of 0.05 must be used.* All the rows of data must be maintained.* Administrative effort must be minimized.What should you do in Power Query Editor?

Edit the query in the Query Errors group.

In Power BI Desktop, you have a dataset that contains a table.You create a table visual on a Power BI report page as shown in the following exhibit You need to configure the visual to display the referenced image instead of the URL in the Plant Image column.What should you do?

Set the Data category of the Plant Image field to Image URL

Set the Data type of the Plant Image field to Binary.

Set the Data category of the Plant Image field to Web URL.

From the Formatting tab. select Values, and then set URL icons to On for the table.

From Power Query Editor, you attempt to execute a query and receive the following error message.Datasource.Error: could not find file.What are two possible causes of the error? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

An incorrect privacy level was used for the data source.

You do not have permissions to the file.

An incorrect privacy level was used for the data source.

The referenced file was moved to a new location

You do not have permissions to the file.

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?

DistinctCount (sales'[Order ID])

Microsoft PL-300 Practice Test 8 - Free Online Exam Prep & Questions

Question 1 / 40

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. From Power Query Editor, you profile the data shown in the following exhibit.

Microsoft PL-300 image Question 248 106505 10052024010716000000

The IoT GUID and IoT ID columns are unique to each row in query.

You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You split the loT DateTime column into a column named Date and a column named Time.

Does this meet the goal?

Become a Premium Member for full access

Unlock Premium Member

Microsoft PL-300 Practice Test 8

Question

Microsoft PL-300 Practice Tests

Practice Tests