Microsoft Power BI Data Analyst (PL-300) Free Questions - Part 5

Question No : 61) You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.

The reports display the data configured as shown in the following table.

 

You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.

 

You need to ensure that the users of the reports can locate the correct report by using natural language queries.

What should you do?

A. From the properties of the dataset, create four Featured Q&A Questions.

B. From the Format settings of the reports, modify the Page Information.

C. From the properties of the dataset, modify the Q&A and Cortana settings.

D. From the properties of the workspace, modify the Language Settings.


Question No : 62) You plan to embed multiple visualization in a public website.

Your Power BI infrastructure contains the visualizations configured as shown in the following table.

 

Your Power BI infrastructure contains the visualizations configured as shown in the following table.

 

Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.

NOTE: Each correct selection is worth one point.

A. Visual1

B. Visual2

C. Visual3

D. Visual4

E. Visual5


Question No : 63) You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Add the same slicer to each page and configure Sync slicers.

B. Edit the interactions of the KPI visualization.

C. Configure a page-level filter.

D. Edit the interactions of the slicer that is on the same page as the KPI visualization.

E. Configure a report-level filter.


Question No : 64) You have an app workspace named Retail Analysis in the Power BI service. 

You need manage the members that have access to the app workspace.

What should you do?

A. From the Power BI Admin portal, click Usage metrics.

B. From the Office 365 Admin center, click Users.

C. From the Office 365 Admin center, click Groups.

D. From the Power BI Admin portal, click Tenant settings.


Question No : 65) You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

 

You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

 

You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)

 

You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit.

 

What should you do?

A. Edit the details of each tile.

B. Change the report theme.

C. Change the dashboard theme.

D. Create a custom CSS file.

 

Question No : 66) You plan to use Power BI Desktop optimized for Power BI Report Server to create a report.  The report will be published to Power BI Report Server.

You need to ensure that all the visualization in the report can be consumed by users.

Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. Funnel charts

B. Custom visuals

C. Bubble maps

D. Breadcrumbs

E. R visuals

 

Question No : 67) In the Power BI service, you create an app workplace that contains several dashboards.

You need to provide a user named [email protected] with the ability to edit and publish dashboards.

What should you do?

A. Modify the members of the app workspace.

B. Configure security for the dataset used by the app.

C. Share the dashboard, and then modify the Access settings of the dashboard.

D. From the app workspace, click Update app, and then configure the Access settings.


Question No : 68) You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.

 

You build a report about warehouse inventory data.

 

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.

You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

 

To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.


Question No : 69) 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.

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: You create a new query that references DataSourceExcel.

Does this meet the goal?

A. Yes
B. No


Question No : 70) You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:

A line chart that shows the number of defective products manufactured by day.

A KPI visual that shows the current daily percentage of defective products manufactured.

You need to be notified when the daily percentage of defective products manufactured exceeds 3%.

What should you create?

A. a Q&A visual

B. a subscription

C. a smart narrative visual

D. an alert


Question No : 71) 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 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.

 

How should you complete the DAX expression?

 


Question No : 72) You are creating a visual to show the ranking of product categories by sales revenue.

Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant

Which approach provides the widest variety of visuals while adhering to the security policy?

A. Use default visuals or custom visuals uploaded from a .pbiviz file.

B. Use only default visuals.

C. Use default or any custom visuals from the marketplace.

D. Use default or certified custom visuals.


Question No : 73) You plan to create the chart shown in the following exhibit.

 

You plan to create the chart shown in the following exhibit.

 

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

A. Create a horizontal line that has a fixed value of 24,000.

B. Add a measure to the visual that uses the following DAX expression.

Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)

C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

D. Add a measure to the visual that uses the following DAX expression.

Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

 

Question No : 74) 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.

You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: You add a Power Apps custom visual to the report.

Does this meet the goal?

A. Yes

B. No

 

Question No : 75) You have a Power BI report.

You need to create a calculated table to return the 100 highest spending customers. 

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.

 

You have a Power BI report.

 

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

A. Create a horizontal line that has a fixed value of 24,000.

B. Add a measure to the visual that uses the following DAX expression. Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)

C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

D. Add a measure to the visual that uses the following DAX expression. Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40) 


PL-300 Answers

 

Part 1

Part 2

Part 3

Part 4

Part 5

Part 6

Part 7

Part 8

Part 9

Part 10

Part 11

Part 12

Part 13