New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Newly Released Microsoft DP-500 Exam PDF

Page: 3 / 6
Total 160 questions

Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Questions and Answers

Question 9

You have a Power BI report named Report1. Repor1 is connected to an imported dataset that contains a matrix. The matrix displays five measures. When users view the report they discover that the matrix is slow to render.

You need to review the execution times and durations in the formula engine and the storage engine for the DAX query executed by the matrix. What should you use?

Options:

A.

DAX Studio

B.

SQL Server Profiler

C.

Performance analyzer

D.

Vertipaq Analyzer

Question 10

You have a Power Bl tenant.

You need to ensure that all reports use a consistent set of co applied to existing reports.

colors and fonts. The solution must ensure that the colors and fonts can be

What should you create?

Options:

A.

a report theme file

B.

a PBIX file

C.

a Power Bl template

Question 11

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 Bl dataset named Dataset1.

In Dataset1, you currently have 50 measures that use the same time intelligence logic.

You need to reduce the number of measures, while maintaining the current functionality.

Solution: From Tabular Editor, you create a calculation group.

Does this meet the goal?

Options:

A.

Yes

B.

No

Question 12

You have an Azure Synapse Analytics serverless SQL pool.

You need to return a list of files and the number of rows in each file.

How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Options:

Page: 3 / 6
Total 160 questions