Free DP-500 Exam Braindumps (page: 13)

Page 13 of 46

You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)



The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)



You need to reduce the model size by eliminating invalid relationships.

Which column should you remove?

  1. Sales[Sales Amount]
  2. Sales[Row ID]
  3. Sales[Sales ID]
  4. Plan[Row ID]

Answer(s): B

Explanation:

Sales[Row ID] has 858,786 missing keys and 858,789 Max From Cardinality.
Note: The Max From Cardinality column defines the cost of the relationship which is the amount of time DAX needs to transfer the filters from the dimensions table to the fact table.


Reference:

https://blog.enterprisedna.co/vertipaq-analyzer-tutorial-relationships-referential-integrity/



You are optimizing a Power BI data model by using DAX Studio.

You need to capture the query events generated by a Power BI Desktop report.

What should you use?

  1. the DMV list
  2. a Server Timings trace
  3. an All Queries trace
  4. a Query Plan trace

Answer(s): C

Explanation:

The All Queries trace in Dax Studio supports capturing the query events from all client tools (not just queries sent from DAX Studio like the Query Plan and Server Timings features do). The ‘All Queries” trace is really useful when you wish to see the queries that are generated by a client tool like Power BI Desktop.


Reference:

https://daxstudio.org/documentation/features/all-queries-trace/



You have a sales report as shown in the following exhibit.



The sales report has the following characteristics:

-The measures are optimized.
-The dataset uses import storage mode.
-Data points, hierarchies, and fields cannot be removed or filtered from the report page.

From powerbi.com, users experience slow load times when viewing the report.

You need to reduce how long it takes for the report to load without affecting the data displayed in the report.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

  1. Change the report theme to monochromatic.
  2. Replace the single-value cards with a multi-row card.
  3. Replace the product category charts with a bar chart for sales and a hierarchy of Category and Sub Category on the axis.
  4. Replace all the filters on the Filters pane with visual slicers on the report page.

Answer(s): B,C

Explanation:

Incorrect:
Not A: Report themes do not affect the report loading time.
Not D: Slicers could slow down the report further.



You are building a Power BI dataset that will use two data sources.

The dataset has a query that uses a web data source. The web data source uses anonymous authentication.

You need to ensure that the query can be used by all the other queries in the dataset.

Which privacy level should you select for the data source?

  1. None
  2. Organizational
  3. Public
  4. Private

Answer(s): C

Explanation:

A Public data source gives everyone visibility to the data contained in the data source. Only files, internet data sources, or workbook data can be marked Public. Data from a Public data source may be freely folded to other sources.


Reference:

https://docs.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels



Page 13 of 46



Post your Comments and Discuss Microsoft DP-500 exam with other Community members:

Summer commented on July 28, 2024
Wonderful site. It helped me pass my exam. Way to go guys!
UNITED STATES
upvote

Siyya commented on January 19, 2024
might help me to prepare for the exam
Anonymous
upvote

Siyya commented on January 19, 2024
might help me to prepare for the exam
Anonymous
upvote

siyaa commented on January 19, 2024
helped me understand the material better.
Anonymous
upvote

Bunny commented on June 19, 2023
Good Content
Anonymous
upvote

Demetrius commented on June 01, 2023
Important and useful
Anonymous
upvote

Kartoos commented on April 06, 2023
The practice exam was an important part of my preparation and helped me understand the material better.
FRANCE
upvote