Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Microsoft PL-300 - Microsoft Power BI Data Analyst

Page: 3 / 5
Total 434 questions

You need to create the semantic model.

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

A.

live connection

B.

Dual

C.

Import

D.

DirectQuery

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

A.

DirectQuery

B.

Import

C.

Live connection

D.

Composite

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

What should you do?

A.

Filter out discontinued products while importing the Products table.

B.

Group the Categories table by the CategorylD column.

C.

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

D.

Remove the QuantityPerUnit column from the Products table.

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?

A.

Merge queries

B.

Append queries

C.

Combine files

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

A.

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

B.

Filter out discontinued products while importing the Product table.

C.

Remove the QuantityPerUnit column from the Products table

D.

Group the Categories table by the CategorylD column.

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

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.

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?

A.

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

B.

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

C.

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

D.

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

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.

Your company has training videos that are published to Microsoft Stream.

You need to surface the videos directly in a Microsoft Power BI dashboard.

Which type of tile should you add?

A.

video

B.

custom streaming data

C.

text box

D.

web content