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 6 out of 14 pages

Viewing questions 51-60 out of questions

Questions # 51:

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 # 52:

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 # 53:

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 # 54:

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 # 55:

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 # 56:

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 # 56

Options:

Answer

Answer:

Explanation

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, , , , ]

Questions # 57:

You publish the dataset 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 # 57

Options:

Answer

Answer:

Questions # 58:

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

Options:

Select Column distribution.

Select the sales_amount column and apply a number filter.

Select Column profile, and then select the sales_amount column.

Transform the sales_amount column to replace negative values with 0.

Answer

Questions # 59:

You need to create the dataset. Which dataset mode should you use?

Options:

DirectQuery

Import

Live connection

Composite

Answer

Explanation

Composite Model means now you can have a model, that very large tables of that are coming from the DirectQuery connection, without the need for importing, and small tables to be imported to be accessible quickly.

Questions # 60:

You need to minimize the size of the semantic model. The solution must meet the report requirements.

What should you do?