Check Real Microsoft DP-500 Exam Question for Free (2023) [Q13-Q34]

Check Real Microsoft DP-500 Exam Question for Free (2023)

Get Ready to Boost your Prepare for your DP-500 Exam with 115 Questions

NEW QUESTION # 13
You have a Power Bl dataset that contains the following measure.

You need to improve the performance of the measure without affecting the logic or the results. What should you do?

A. Remove "calendar'[Flag] = "YTD" from the code.
B. Create a variable and replace the values for [sales Amount].
C. Remove the alternative result of blank( ) from the divide function.
D. Replace both calculate functions by using a variable that contains the calculate function.

Answer: D

NEW QUESTION # 14
You plan to generate a line chart to visualize and compare the last six months of sales data for two
departments. You need to increase the accessibility of the visual. What should you do?

A. Configure a unique marker for each series.
B. Configure a distinct color for each series.
C. Replace long text with abbreviations and acronyms.
D. Move important information to a tooltip.

Answer: A

NEW QUESTION # 15
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 are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.
The queries use open row set and infer the schema shown in the following table.

You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend defining an external table for the Parquet files and updating the query to use the table Does this meet the goal?

A. Yes
B. No

Answer: B

NEW QUESTION # 16
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 moving all the measures to a calculation group.
Does this meet the goal?

A. Yes
B. No

Answer: B

Explanation:
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.

NEW QUESTION # 17
You need to integrate the external data source to support the planned changes.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.

Answer:

Explanation:

NEW QUESTION # 18
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.

A. First-level elements colors
B. Sentiment colors
C. Theme colors
D. Divergent colors

Answer: A

NEW QUESTION # 19
You have a Power Bl report that contains one visual.
You need to provide users with the ability to change the visual type without affecting the view for other users.
What should you do?

A. From Visual options in Report settings, select Use the modern visual header with updated styling options.
B. From the Bookmarks pane, select Focus mode, and then select Add.
C. From Report setting, select Personalize visuals.
D. From Tabular Editor, create a new perspective.

Answer: C

NEW QUESTION # 20
You have the following code in an Azure Synapse notebook.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the code.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://matplotlib.org/stable/gallery/lines_bars_and_markers/bar_stacked.html
https://matplotlib.org/stable/api/legend_api.html

NEW QUESTION # 21
You have an Azure Synapse workspace named Workspace1.
You need to use PySpark in a notebook to read data from a SQL pool as an Apache Spark DataFrame and display the top five How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION # 22
You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the Apache Parquet format. A sample of the data is shown in the following table.

You need to create a Transact-SQL query that will return the source IP address.
Which function should you use in the select statement to retrieve the source IP address?

A. FOR.JSON
B. FIRST VALUE
C. CONVERT
D. JS0N_VALUE

Answer: D

NEW QUESTION # 23
You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one
report.
You need to prevent project managers from accessing the data in two columns in Table1 named Budget and
Forecast.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.

Answer:

Explanation:

NEW QUESTION # 24
You have new security and governance protocols for Power Bl reports and datasets. The new protocols must meet the following requirements.
* New reports can be embedded only in locations that require authentication.
* Live connections are permitted only for workspaces that use Premium capacity datasets.
Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. From Tenant settings, set Publish to web to Disable.
B. From Capacity settings, set XMLA Endpoint to Read Write.
C. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.
D. From Embed Codes, delete all the codes.
E. From the Premium per user settings, set XMLA Endpoint to Off.

Answer: A,B,C

Explanation:
Reference:
https://powerbi.microsoft.com/en-us/blog/power-bi-february-service-update

NEW QUESTION # 25
You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL database named
DB1. DB1 is a transactional database in the third normal form.
You need to recommend a solution to minimize how long it takes to execute the query. The solution must
maintain the current functionality. What should you include in the recommendation?

A. Normalize the tables in DB1.
B. Create calculated columns in Dataset1.
C. Remove the relationships from Dataset1.
D. Denormalize the tables in DB1.

Answer: A

NEW QUESTION # 26
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 are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.
The queries use open row set and infer the schema shown in the following table.

You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend defining a data source and view for the Parquet files. You recommend updating the query to use the view.
Does this meet the goal?

A. Yes
B. No

Answer: B

Explanation:
Solution: You recommend using OPENROWSET WITH to explicitly specify the maximum length for businessName and surveyName.
The size of the varchar(8000) columns are too big. Better reduce their size.
A SELECT...FROM OPENROWSET(BULK...) statement queries the data in a file directly, without importing the data into a table. SELECT...FROM OPENROWSET(BULK...) statements can also list bulk-column aliases by using a format file to specify column names, and also data types.

NEW QUESTION # 27
You have a Power Bl report that contains the visual shown in the following exhibit.

You need to make the visual more accessible to users who have color vision deficiency. What should you do?

A. Add additional measures to the table values.
B. Add icons to represent the sales status of each product.
C. Change the font color of values in the Sales column to white.
D. Change the red background color to orange.

Answer: D

NEW QUESTION # 28
You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one report.
You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer:

Explanation:

1 - From Power BI Desktop, create a role named Project Managers.
2 - Open Tabular Editor
3 - From Power BI Desktop, add a DAX filter to the Project Managers role.
4 - For Table1, the Budget and Forecast columns, set the permissions to None.

NEW QUESTION # 29
You are using an Azure Synapse notebook to create a Python visual.
You run the following code cell to import a dataset named Iris.

A sample of the data is shown in the following table.

You need to create the visual shown in the exhibit. (Click the Exhibit tab.)

How should you complete the Python code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION # 30
You need to recommend an automated solution to monitor Power Bl user activity. The solution must meet the following requirements:
* Security admins must identify when users export reports from Power Bl within five days of a new sensitivity label being applied to the artifacts in Power Bl.
* Power Bl admins must identify updates or changes to the Power Bl capacity.
* The principle of least privilege must be used.
Which log should you include in the recommendation for each group? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION # 31
You are creating a Power Bl Desktop report.
You add a Python visual to the report page.
You plan to create a scatter chart to visualize the data.
You add Python code to the Python script editor.
You need to create the scatter chart.
How should you complete the Python code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION # 32
You need to create the customized Power Bl usage reporting. The Usage Metrics Report dataset has already been created. The solution must minimize development and administrative effort.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer:

Explanation:

1 - From powerbi.com, create a new report..
2 - Add a report measure
3 - Add visuals to the report
4 - Publish the report to the Sales Analytics workspace

NEW QUESTION # 33
You use Vertipaq Analyzer to analyze a model.
The Relationships tab contains the results shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.