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

Sure Pass Exam PL-300 PDF

Page: 6 / 15
Total 459 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 21

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 22

You have a Power BI dashboard that displays different visualizations of company sales.

You enable Q&A on the dashboard.

You need to provide users with sample questions that they can ask when using Q&A.

Which settings should you modify from the Power BI Settings?

Options:

A.

Subscriptions

B.

Dashboards

C.

Datasets

D.

Workbooks

Question 23

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 three dates at the same time.

Solution; You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table.

Does this meet the goal?

Options:

A.

Yes

B.

No

Question 24

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.

The Sales table contains purchase and ship dates.

Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.

Which data modeling design should you use?

Options:

A.

Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.

B.

Duplicate the Date query in Power Query and use active relationships between both Date tables.

C.

On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

D.

Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Page: 6 / 15
Total 459 questions