Microsoft PL-300 - Microsoft Power BI Data Analyst

Microsoft PL-300 Premium Access Download Demo

Page: 3 / 5
Total 434 questions

Question # 21

You need to create the semantic model.

Which storage mode should you use for the tables in the semantic model?

live connection

Dual

Import

DirectQuery

Question # 22

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

DirectQuery

Import

Live connection

Composite

Question # 23

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

What should you do?

Filter out discontinued products while importing the Products table.

Group the Categories table by the CategorylD column.

Change the OrderlD column in the Orders table to the Text data type.

Remove the QuantityPerUnit column from the Products table.

Question # 24

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

Merge queries

Append queries

Combine files

Question # 25

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

Change lite OrderlD column in the Orders table to the text data type.

Filter out discontinued products while importing the Product table.

Remove the QuantityPerUnit column from the Products table

Group the Categories table by the CategorylD column.

Question # 26

You use Microsoft Power B1 Desktop to review the data shown in the following exhibit.

Question # 27

You have the Power Bl data model shown in the following exhibit.

You need to create a measure to count the number of product categories that had products sold during a selected period. 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.

Question # 28

You have a Power Bl model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

The model contains the following DAX measure.

Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.

Which DAX calculation should you use?

CALCULATE < [Total Sales], OATEADD (Date[Date], -1, QUARTER))

CALCULATE ([Total Sales], DATESQTD (Date[Date]))

TOTALQTD ([Total Sales], Date[Date])

CALCULATE < [Total Sales], PARALLELPERIOO (Date[Date], 1, QUARTER))

Question # 29

Each Region value appears only on the tow where it first occurred. Each subsequent occurrence of the Region value is blank.

You need to ensure that every row contains the connect non-blank value The solution must minimize development effort.

Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area. NOTE; Each connect selection is worth one point.