Month End Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Sure Pass Exam PL-300 PDF

Page: 6 / 16
Total 422 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 21

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

Options:

A.

DirectQuery

B.

Import

C.

Live connection

D.

Composite

Question 22

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

What should you do?

Options:

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.

Question 23

You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.

For each of the following statement, select Yes if the statement is true, Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Question 24

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

Options:

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.

Page: 6 / 16
Total 422 questions