March Sale Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

PL-300 PDF

$49

$139.99

3 Months Free Update

  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

PL-300 PDF + Testing Engine

$66.5

$189.99

3 Months Free Update

  • Exam Name: Microsoft Power BI Data Analyst
  • Last Update: Mar 28, 2024
  • Questions and Answers: 342
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

PL-300 Engine

$56

$159.99

3 Months Free Update

  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

PL-300 Microsoft Power BI Data Analyst Questions and Answers

Question # 6

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?

A.

Apply row-level security (RLS) to the Region table based on the sales manager username.

B.

Configure a bi-directional relationship between Region and Sales.Region.

C.

Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.

D.

In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Full Access
Question # 7

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

A.

FORMAT('Date'[date], "MMM YYYY")

B.

FORMAT('Date' [date], "M YY")

C.

FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")

D.

FORMAT('Date' [date_id], "MMM YYYY")

Full Access
Question # 8

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

A.

Create a security role that has a table filter on the Sales_Manager table where

username = UserName()

B.

Create a security role that has a table filter on the Region_Manager table where

sales_manager_id = UserPrincipalName().

C.

Create a security role that has a table filter on the Sales_Manager table where

name = UserName().

D.

Create a security role that has a table filter on the Sales_Manager table where

username = sales_manager_id.

Full Access
Question # 9

You have a BI dataset and a connected report.

You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset.

You grant the users the Build permission for dataset

What Should do next?

A.

Change default visual interaction for the report

B.

For the report change the Export data setting to Summarized data, data with current layout and underlying data

C.

For the report, change the Export data setting to None

D.

Certify the dataset used by the report.

Full Access
Question # 10

You have a table that contains the following three columns:

  • City
  • Total Sales
  • Occupation

You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

PL-300 question answer

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

NOTE: Each correct selection is worth one point.

PL-300 question answer

Full Access
Question # 11

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?

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.

Full Access
Question # 12

You have a Microsoft Power Bl workspace.

You need to grant the user capabilities shown in the following table.

PL-300 question answer

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

PL-300 question answer

Full Access
Question # 13

You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.

PL-300 question answer

Full Access
Question # 14

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 do in Microsoft Power Bl Desktop?

A.

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

B.

Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

C.

Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the

manufacturing reports library.

D.

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

Full Access
Question # 15

You view a query named Transactions as shown in the following exhibit.

PL-300 question answer

The query gets CSV files from a folder.

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.

PL-300 question answer

Full Access
Question # 16

You have a power BI tenant that hosts the datasets shown in the following table.

PL-300 question answer

You have the following requirements:

• The export of reports that contain Personally Identifiable Information (Pll) must be prevented.

• Data used for financial decisions must be reviewed and approved before use.

For each of the following statements, select Yes if the statement is true. Otherwise select No. NOTE: Each correct selection is worth one point

PL-300 question answer

Full Access
Question # 17

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.

PL-300 question answer

Full Access