QUESTION: 69 Exam Topic: Question Set 2

You are creating a Power BI model that contains a table named Store. Store contains the following fields.

You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City.
What should you do to ensure that the locations are mapped properly?

Change the data type of City, State/Province, and Country.
Set Summarization for City, State/Province, and Country to Don't summarize.
Set the data category of City, State/Province, and Country.
Create a calculated column that concatenates the values in City, State/Province, and Country.

Answer(s): C

Explanation:

A hierarchy is a set of fields categorized in a hierarchical way that one level is the parent of another level. Values of the parent level can be drilled down to the lower level.
Create Hierarchy
Right-click on the field you want to set as level 1 of the hierarchy in the fields list, and then select Create Hierarchy.

After that, you will see a new hierarchy created named your field name Categoryplus the word Hierarchy. This would have a hierarchy icon beside it and also an option to expand to the fields of the hierarchy. If you expand, you will see a copy of the Category field in there too.

Etc.

Reference:

https://radacad.com/what-a-power-bi-hierarchy-is-and-how-to-use-it

Reveal Solution Next Question

QUESTION: 70 Exam Topic: Question Set 2

You are building a data model for a Power BI report.
You have data formatted as shown in the following table.

You need to create a clustered bar chart as shown in the following exhibit.

What should you do?

From Power Query Editor, split the Machine-User column by using a delimiter.
From Power Query Editor, create a column that contains the last three digits of the Machine-User column.
In a DAX function, create two calculated columns named Machine and User by using the SUBSTITUTE function.
In a DAX function, create two measures named Machine and User by using the SUBSTITUTE function.

Answer(s): A

Explanation:

Split a column of text (Power Query)
You can split a column with a text data type into two or more columns by using a common delimiter character. For example, a Name column that contains values written as <LastName>, <FirstName> can be split into two columns using the comma (,) character.
Note: Power Query is an Extract Transform Load (ETL) tool. It allows us to
Download and fetch data from different sources. We call this data ingestion
Combine, clean, and model this data. We call this data wrangling

Reference:

https://support.microsoft.com/en-us/office/split-a-column-of-text-power-query-5282d425-6dd0-46ca-95bf-8e0da9539662

Reveal Solution Next Question

QUESTION: 71 Exam Topic: Question Set 2

DRAG DROP (Drag and Drop is not supported)
You need create a date table in Power BI that must contain 10 full calendar years, including the current year.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: YEAR
Get the current year.

Box 2: TODAY
TODAY returns the current date.

Box 3: CALENDAR
CALENDAR returns a table with a single column named ג€Dateג€ containing a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.
The following formula returns a table with dates between January 1st, 2005 and December 31st, 2015.
CALENDAR (
DATE ( 2005, 1, 1 ),
DATE ( 2015, 12, 31 )

Reference:

https://dax.guide/calendar/

Reveal Solution Next Question

QUESTION: 72 Exam Topic: Question Set 2

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
-Due Date
-Order Date
-Delivery Date

You need to support the analysis of sales over time based on all the date foreign keys.
Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship between the sales table and the date table.
Does this meet the goal?

Answer(s): B

Explanation:

Instead: Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables.

Reference:

https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 18)

QUESTION: 69 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 70 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 71 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 72 Exam Topic: Question Set 2

Explanation:

Reference: