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

Microsoft Certified: Power BI Data Analyst Associate PL-300 Dumps PDF

Page: 11 / 16
Total 422 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 41

What is the minimum number of Power BI datasets needed to support the reports?

Options:

A.

a single imported dataset

B.

two imported datasets

C.

two DirectQuery datasets

D.

a single DirectQuery dataset

Question 42

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

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

You need to create a calculated table that v/ill contain the following:

Options:

Question 43

You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns:

• Date

• Fiscal year

• Fiscal Quartet

• Month Name

• Calendar Year

• Week Number

• Month Number

• Calendar Quarter

You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?

Options:

A.

DATATABLE

B.

ADDCOLUMS

C.

SUMMARIZE

D.

CALCULATE

Question 44

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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload

Does this meet the goal?

Options:

A.

Yes

B.

No

Page: 11 / 16
Total 422 questions