Microsoft Power BI Data Analyst (PL-300) - Microsoft - Free Practice

1

Question

You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

Options

A Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

B Create a column by example that starts with 2018-12-31.

C Apply the parse function from the Date transformations options to the Logged column.

D Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2

Question

You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:

• Order Line ID

• Product ID

• Unit Price

• Order ID

• Quantity
Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID. You need to write a DAX measure that counts the number of orders.

Which formula should you use?

Options

A DistinctCount (sales'[Order ID])

B CountRows('Sales')

C Count ('Sales'(Order ID])

D CountA (Sale** (Order ID])

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3

Question

HOTSPOT You have a Power BI semantic model named Model1. You need to create a measure that will display the sales result for all units. The solution must maintain the existing filter.

How should you complete the DAX expression? TO answer, select the appropriate options in the

HOTSPOT

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4

Question

DRAG DROP You need to create a date table in Power B1 that must contain 10 full calendar years, including the current year

How should you complete the DAX expression? To answer, drag the appropriate values to the correct locations. Each value 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.

Reveal Only

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5

Question

You are building a Power Bl report. Users will view the report by using their mobile device. You need to configure the report to display data based on each user s location.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select 2

Options

A Use the columns of the geography data type in all visuals.

B Create a hierarchy for columns of the geography data type.

C For the relevant columns, set synonyms to match common geographical terms.

D In Data Category, set the geographic data category for the relevant columns.

E From Power Query Editor, detect the data types of the relevant columns.

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Microsoft Power BI Data Analyst (PL-300) - Microsoft Exam Questions

Delete Comment

Delete Comment

Delete Comment

Delete Comment

Delete Comment

Finish Practice?