Valentine Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netbudy65

PL-300 Microsoft Power BI Data Analyst Questions and Answers

Questions 4

A user creates a Power B1 report named ReportA that uses a custom theme

You create a dashboard named DashboardA.

You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

A.

From DashboardA upload a JSON theme.

B.

Publish ReportA to the Microsoft Power B1 Community theme gallery.

C.

From DashboardA create a custom theme.

D.

From ReportA save the current theme.

E.

Publish ReportA to Power Bl.

Buy Now
Questions 5

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?

Options:

A.

Upload the Excel file to a Power BI workspace.

B.

Create a subscription to the report.

C.

Deploy an on-premises data gateway.

D.

Edit the data source credentials.

Buy Now
Questions 6

You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.

A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.

You need to ensure that User sees App1 from the My organization AppSource.

What should you do?

Options:

A.

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

B.

From the app workspace settings, add a member.

C.

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

D.

From the app workspace, share the dashboard.

Questions 7

You have a Power B1 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?

Options:

A.

a paginated report

B.

a template app

C.

an interactive report

D.

a dashboard

Buy Now
Questions 8

You are building a Power Bl report that uses data from an Azure SQL database named erp1.

You Import the following tables.

You need to perform the following analyses:

• Orders sold over time that include a measure of the total order value

• Orders by attributes of products sold

The solution must minimize update times when interacting with visuals in the report. What should you do first?

Options:

A.

From Power Query, merge the Orders query and the Order Line Hems query.

B.

Calculate the count of orders per product by using a DAX function.

C.

Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.

D.

From Power Query, merge the Order Line Items query and the Products query.

Buy Now
Questions 9

You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month.

You pin the Sales by month visual to Dashboard1.

In Report1, you change the Sales by month visual to a bar chart.

You need to ensure that bar chart displays on Dashboard1.

What should you do?

Options:

A.

Edit the details for the dashboard tile of Dashboard1.

B.

Select Refresh visuals for Dashboard1.

C.

the Sales by month bar chart to Dashboard1

D.

Refresh the dataset used by Report1 and Dashboard1.

Buy Now
Questions 10

You have a dataset that contains revenue data from the past year.

You need to use anomaly detection in Power Bl to show anomalies in the dataset.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 11

You have the Azure SQL databases shown in the following table.

You plan to build a single PBIX file to meet the following requirements:

• Data must be consumed from the database that corresponds to each stage of the development lifecycle.

• Power Bl deployment pipelines must NOT be used.

• The solution must minimize administrative effort.

What should you do? To answer, select the appropriate options in the answer area.

Options:

Buy Now
Questions 12

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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.

Solution: You add a WHERE clause to the SQL statement.

Does this meet the goal?

Options:

A.

Yes

B.

No

Buy Now
Questions 13

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 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.

Options:

Buy Now