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

Viewing questions 41-50 out of questions

Questions # 41:

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

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

What should you create to meet the reporting requirements of the sales department?

Options:

a measure that uses a formula of SUM (Sales [sales_id])

a calculated column that use a formula of COUNTA(sales [sales_id])

a measure that uses a formula of COUNTROWS (Sales)

a calculated column that uses a formula of SUM (Sales [sales_id])

Answer

Explanation

The sale department requires reports that contain the number of sales transactions.

The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

[Reference:, https://docs.microsoft.com/en-us/dax/countrows-function-dax, , , , ]

Questions # 44:

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

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

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

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

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

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?

Options:

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

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

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

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

Answer

Questions # 49:

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

Options:

Answer

Answer:

Questions # 50:

What should you create to meet the reporting requirements of the sales department?

Options:

a measure that uses a formula of SUM (Sales [sales_id])

a calculated column that use a formula of COUNTA(sales [sales_id])

a measure that uses a formula of COUNTROWS (Sales)

a calculated column that uses a formula of SUM (Sales [sales_id])

Answer

Explanation

The sale department requires reports that contain the number of sales transactions.

The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

[Reference:, https://docs.microsoft.com/en-us/dax/countrows-function-dax, , , , ]

Viewing page 5 out of 14 pages

Viewing questions 41-50 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