Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Microsoft
  3. Microsoft Certified: Power BI Data Analyst Associate
  4. PL-300
  5. Microsoft Power BI Data Analyst Questions and Answers

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

Exam PL-300 All Questions
Exam PL-300 Premium Access

View all detail and faqs for the PL-300 exam

Go to Exam
Viewing page 2 out of 14 pages
Viewing questions 11-20 out of questions
Questions # 11:

You have the visual shown in the exhibit. (Click the Exhibit tab.)

Question # 11

You need to show the relationship between Total Cost and Total Sales over time.

What should you do?

Options:

A.

Add a play axis.

B.

Add a slicer for the year.

C.

From the Analytics pane, add an Average line.

D.

Create a DAX measure that calculates year-over-year growth.

Expert Solution
Questions # 12:

O: 12 HOTSPOT

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

Question # 12

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

NOTE: Each correct selection is worth one point.

Question # 12

Options:

Expert Solution
Questions # 13:

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

Options:

Expert Solution
Questions # 14:

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

Options:

A.

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

B.

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

C.

a measure that uses a formula of COUNTROWS (Sales)

D.

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

Expert Solution
Questions # 15:

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

Options:

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")

Expert Solution
Questions # 16:

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

Options:

Expert Solution
Questions # 17:

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

Options:

A.

Select Column distribution.

B.

Select the sales_amount column and apply a number filter.

C.

Select Column profile, and then select the sales_amount column.

D.

Transform the sales_amount column to replace negative values with 0.

Expert Solution
Questions # 18:

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

Options:

A.

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

B.

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

C.

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

D.

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

Expert Solution
Questions # 19:

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

What should you include in the solution?

Options:

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.

Expert Solution
Questions # 20:

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:

A.

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.

B.

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

C.

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.

Expert Solution
Viewing page 2 out of 14 pages
Viewing questions 11-20 out of questions