Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Microsoft
Microsoft Certified: Power BI Data Analyst Associate
PL-300
Microsoft Power BI Data Analyst Questions and Answers

Pass the Microsoft Certified: Power BI Data Analyst Associate PL-300 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam PL-300 Premium Access

View all detail and faqs for the PL-300 exam

Go to Exam

704 Students Passed

91% Average Score

95% Same Questions

Viewing page 10 out of 14 pages

Viewing questions 91-100 out of questions

Questions # 91:

You need to grant access to the business unit analysts.

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

NOTE: Each correct selection is worth one point.

Question # 91

Options:

Answer

Answer:

Explanation

Box 1: The Viewer role to the workspace

The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can’t browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to “Members can only view Power BI content”.

Box 2: Build

The analysts must be able to build new reports from the dataset that contains the profit and loss data.

Scenario: The reports must be made available to the board from powerbi.com.

The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.

[Reference:, https://www.nickyvv.com/2019/08/the-new-power-bi-workspace-viewer-role-explained.html, , , , ]

Questions # 92:

Which DAX expression should you use to get the ending balances in the balance sheet reports?

Options:

CALCULATE (SUM( BalanceSheet [BalanceAmount] ),DATESQTD( 'Date'[Date] ))

CALCULATE (SUM( BalanceSheet [BalanceAmount] ),LASTDATE( 'Date'[Date] ))

FIRSTNONBLANK ( 'Date' [Date]SUM( BalanceSheet[BalanceAmount] ))

CALCULATE (MAX( BalanceSheet[BalanceAmount] ),LASTDATE( 'Date' [Date] ))

Answer

Explanation

Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.

DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.

rence:

https://docs.microsoft.com/en-us/dax/datesqtd-function-dax

Questions # 93:

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

Options:

an additional date table named ShipDate, a one-to-many relationship fromSales[sales_date_id] to Date[date_id], and a one-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

an additional date table named ShipDate, a many-to-many relationship fromSales[sales_date_id] to Date[date_id], and a many-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-manyrelationship from Sales[sales_ship_date_id] to Date[date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

Answer

Explanation

Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.

[Reference:, https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand, , ]

Questions # 94:

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

Options:

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

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

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

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

Answer

Questions # 95:

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

Options:

import that uses a Microsoft account

DirectQuery that uses the end-user s credentials

DirectQuery that uses a database credential

Import that uses a database credential

Answer

Questions # 96:

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

Options:

In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

Answer

Explanation

Scenario: Region managers require a visual to analyze weekly sales and returns.

To relate the two tables we need a common column.

Questions # 97:

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

Options:

Change the data type of Sales[region_id] to Whole Number.

In the Sales table, add a measure for sum(sales_amount).

Change the data type of sales[sales_id] to Text.

Change the data type of sales [region_id] to Decimal Number.

Answer

Explanation

Scenario: Executives require a visual that shows sales by region.

Need to change the sales_id column from Varchar to Whole Number (Integer).

Questions # 98:

You publish the semantic model to powerbi.com.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Question # 98

Options:

Answer

Answer:

Questions # 99:

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

What should you include in the solution?

Options:

Create a security role that has a table filter on the Sales_Manager table whereusername = UserName()

Create a security role that has a table filter on the Region_Manager table wheresales_manager_id = UserPrincipalName().

Create a security role that has a table filter on the Sales_Manager table wherename = UserName().

Create a security role that has a table filter on the Sales_Manager table whereusername = sales_manager_id.

Answer

Explanation

https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/

Questions # 100:

You need to create a visualization to meet the reporting requirements of the sales managers.

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

NOTE: Each correct selection is worth one point.

Question # 100

Options:

Answer

Answer:

Explanation

100

Scenario: The sales managers require a visual to analyze sales performance versus sales targets.

Box 1: KPI

A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.

Box 2: Sales[sales_amount]

Box 3: Date[month]

Time > FiscalMonth. This value will represent the trend.

Box 4: Targets[sales_target]

[Reference:, https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi, , , , ]

Viewing page 10 out of 14 pages

Viewing questions 91-100 out of questions

Modal title

Registered Required

In order to participate in the comments you need to be logged-in.
You can sign-up or login (it's free).

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.

2V0-11.25

ADM-201

Agentforce-Specialist

CMMC-CCP

Data-Cloud-Consultant

PDI

PSE-Strata-Pro-24

Secure-Software-Design

Sharing-and-Visibility-Architect

Workday-Pro-Integrations

ZDTA