Microsoft DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Exam Practice Test

Page: 1 / 14
Total 162 questions
Question 1

You are configuring a Power Bl report for accessibility as shown in the following table.

You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency. Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.



Answer : A, B


Question 2

Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.



Answer : B, D

Some users indicate that the visuals in Power BI reports are slow to render when making filter selections.

B: You can investigate a slow query in a Power BI report using DAX Studio, looking at the query plan and the server timings.

D: Use Power BI Desktop Performance Analyzer to optimize the report or model.


https://docs.microsoft.com/en-us/power-bi/guidance/report-performance-troubleshoot

Question 3

You have a file named File1.txt that has the following characteristics:

* A header row

* Tab delimited values

* UNIX-style line endings

You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.

Which query should you execute?



Answer : A

Use FIELDTERMINATOR ='\t' for tab.

Use ROWTERMINATOR ='\0x0A ' for UNIX-style line endings

Use FIRSTROW= 2 for a header row

Note: Using Row Terminators

The row terminator can be the same character as the terminator for the last field. Generally, however, a distinct row terminator is useful. For example, to produce tabular output, terminate the last field in each row with the newline character (\n) and all other fields with the tab character (\t).

If you want to output a line feed character only (LF) as the row terminator - as is typical on Unix and Linux computers - use hexadecimal notation to specify the LF row terminator. For example:

bcp -r '0x0A'

FIRSTROW

FIRSTROW =first_row Specifies the number of the first row to load. The default is 1. This indicates the first row in the specified data file. The row numbers are determined by counting the row terminators. FIRSTROW is 1-based.


https://docs.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql

Question 4

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 the Power Bl data model shown in the exhibit. (Click the Exhibit tab.)

Users indicate that when they build reports from the data model, the reports take a long time to load.

You need to recommend a solution to reduce the load times of the reports.

Solution: You recommend normalizing the data model.

Does this meet the goal?



Answer : B

Instead denormalize For Performance.

Even though it might mean storing a bit of redundant data, schema denormalization can sometimes provide better query performance. The only question then becomes is the extra space used worth the performance benefit.


Question 5

You have the following Python code in an Apache Spark notebook.

Which type of chart will the code produce?



Answer : D

The matplotlib.pyplot.fill_between function fills the area between two horizontal curves.

The curves are defined by the points (x, y1) and (x, y2). This creates one or multiple polygons describing the filled area.


Question 6

You need to recommend a solution to ensure that sensitivity labels are applied. The solution must minimize administrative effort.

Which three actions should you include in the recommendation? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.



Answer : A, D, E

A Synapse Analytics dedicated SQL pool is named SQLDW.

Customer contact data in SQLDW and the Power BI dataset must be labeled as Sensitive. Records must be kept of any users that use the sensitive data.

A (not B): Enable sensitivity labels

Sensitivity labels must be enabled on the tenant before they can be used in both the service and in Desktop.

To enable sensitivity labels on the tenant, go to the Power BI Admin portal, open the Tenant settings pane, and find the Information protection section.

In the Information Protection section, perform the following steps:

Open Allow users to apply sensitivity labels for Power BI content.

Enable the toggle.

D (not C): When data protection is enabled on your tenant, sensitivity labels appear in the sensitivity column in the list view of dashboards, reports, datasets, and dataflows.

E: Power BI Tenant Discovery Setting include Make certified content discoverable.


https://docs.microsoft.com/en-us/power-bi/enterprise/service-security-apply-data-sensitivity-labels

https://support.nhs.net/knowledge-base/power-bi-guidance/

Question 7

You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool named Pool1.

You plan to deploy a data lake that will record the history of transactions executed against Pool1.

You need to recommend which type of file to use to store the history. The solution must ensure that the history is written in the scope of the related transaction.

Which file type should you recommend?



Answer : C


Page:    1 / 14   
Total 162 questions