[2023] Pass your DP-500 exam with this 100% Free DP-500 Braindump

View All DP-500 Actual Exam Questions, Answers and Explanations for Free

NEW QUESTION # 12
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:

Explanation

NEW QUESTION # 13
You need to create Power Bl reports that will display data based on the customers' subscription level.
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 # 14
What should you configure in the deployment pipeline?

• A. auto-binding
• B. a selective deployment
• C. a backward deployment
• D. a data source rule

Answer: A

NEW QUESTION # 15
You have the Power BI workspaces 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.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-portal-workspaces

NEW QUESTION # 16
You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips.
You need to create a chart that will show the total trip distance according to the number of passengers as shown in the following exhibit.

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

Answer:

Explanation:

Explanation

NEW QUESTION # 17
You manage a dataset that contains the two data sources as shown in the following table.

When you attempt to refresh the dataset in powerbi.com, you receive the following error message: "[Unable to combine data] Add Columns is accessing data sources that have privacy levels which cannot be used together.
Please rebuild this data combination."
You discover that the dataset contains queries that fold data from the SharePoint folder to the Azure SQL database.
You need to resolve the error. The solution must provide the highest privacy possible.
Which privacy level should you select for each data source? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation
Box 1: Private
This Formula.Firewall error is the result of Power Query's Data Privacy Firewall (aka the Firewall) Note: Folding is a term that refers to converting expressions in M (such as filters, renames, joins, and so on) into operations against a raw data source (such as SQL, OData, and so on).
Box 2: Organizational
Organizational Limits the visibility of a data source to a trusted group of people. It is isolated from all Public data sources, but is visible to other Organizational data sources. A common example is a Microsoft Word document on an intranet SharePoint site with permissions enabled for a trusted group.
Reference:
https://support.microsoft.com/en-us/office/set-privacy-levels-power-query-cc3ede4d-359e-4b28-bc72-9bee7900b

NEW QUESTION # 18
You need to recommend a security solution for the Power Bl tenant to control external data sharing. The solution must meet the technical requirements.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation

NEW QUESTION # 19
You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics.
You need to present the data distribution statistics from a DataFrame in a tabular view.
Which method should you invoke on the DataFrame?

• A. rollup
• B. explain
• C. cov
• D. describe

Answer: D

Explanation:
The aggregating statistic can be calculated for multiple columns at the same time with the describe function.
Example:
titanic[["Age", "Fare"]].describe()
Out[6]:
Age Fare
count 714.000000 891.000000
mean 29.699118 32.204208
std 14.526497 49.693429
min 0.420000 0.000000
25% 20.125000 7.910400
50% 28.000000 14.454200
75% 38.000000 31.000000
max 80.000000 512.329200

NEW QUESTION # 20
You are implementing a reporting solution that has the following requirements:
* Reports for external customers must support 500 concurrent requests. The data for these reports is approximately 7 GB and is stored in Azure Synapse Analytics.
* Reports for the security team use data that must have local security rules applied at the database level to restrict access. The data being reviewed is 2 GB.
Which storage mode provides the best response time for each group of users?

• A. Import for the external customers and DirectQuery for the security team.
• B. DirectQuery for the external customers and DirectQuery for the security team.
• C. Import for the external customers and import for the security team.
• D. DirectQuery for the external customers and import for the security team.

Answer: D

Explanation:
Explanation
With DirectQuery, queries are sent back to your Azure Synapse Analytics in real time as you explore the data.
Real-time queries, combined with the scale of Synapse Analytics enables users to create dynamic reports in minutes against terabytes of data.
Need import for the security team for local security rules.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-data-warehouse-with-direct-connect

NEW QUESTION # 21
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:
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.
Reference: https://www.mssqltips.com/sqlservertutorial/3211/denormalize-for-performance/

NEW QUESTION # 22
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 Datasetl.
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 DAX Studio, you write a query that uses grouping sets.
Does this meet the goal?

• A. Yes
• B. No

Answer: B

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 a dataset that contains a table named UserPermissions. UserPermissions contains the following data.

You plan to create a security role named User Security for the dataset. You need to filter the dataset based on the current users. What should you include in the DAX expression?

• A. [User] = USEROBJECTID()
• B. [User] = USERPRINCIPALNAME()
• C. [UserPermissions] - USERNAME()
• D. [UserPermissions] - USERPRINCIPALNAME()
• E. [User] = USERNAME()

Answer: E

Explanation:
Explanation
USERNAME() returns the domain name and username from the credentials given to the system at connection time.
It should be compared to column name of User, which in DAX is expressed through [User].
Reference: https://docs.microsoft.com/en-us/dax/username-function-dax

NEW QUESTION # 25
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.
From Power Query Editor, you profile the data shown in the following exhibit.

From Power Query Editor, you profile the data shown in the following exhibit The loT GUIO and loT ID columns are unique to each row in the query.
You need to analyze loT events by the hour and day of the year. The solution must improve dataset performance. Solution: You remove the loT ID column and retain the loT GUID column. Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION # 26
You have a Power Bl dataset. The dataset contains data that is updated frequently.
You need to improve the performance of the dataset by using incremental refreshes.
Which four actions should you perform in sequence to enable the incremental refreshes? 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 - Create RangeStart and RangeEnd parameters.
2 - Apply a custom Date/Time filter to the data.
3 - Define the incremental refresh policy for the table.
4 - Publish the model to the Power BI service.

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

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

• A. Move the conditional formatting icons to a tooltip report.
• B. Add alt text to explain the information that each color conveys.
• C. Change the icons to use a different shape for each color.
• D. Remove the icons and use red, yellow, and green background colors instead.

Answer: B

Explanation:
Explanation
Report accessibility checklist, All Visuals.
* Ensure alt text is added to all non-decorative visuals on the page.
* Avoid using color as the only means of conveying information. Use text or icons to supplement or replace the color.
* Check that your report page works for users with color vision deficiency.
* Etc.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-creating-reports

NEW QUESTION # 28
You are using DAX Studio to query an XMLA endpoint.
You need to identify the duplicate values in a column named Email in a table named Subscription.
How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each value may be used once, more than once. may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

NEW QUESTION # 29
You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode.
A database administrator reports a drastic increase in the number of queries sent from the Power Bi service to an Azure SQL database since the creation of the deployment pipeline.
An investigation into the issue identifies the following:
One of the datasets is larger than 1 GB and has a fact table that contains more than 500 million rows.
When publishing dataset changes to development, test, or production pipelines, a refresh is triggered against the entire dataset.
You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production.
What should you recommend?

• A. Configure the dataset to use a composite model that has a DirectQuery connection to the fact table.
• B. In the dataset, delete the fact table.
• C. Request the authors of the deployment pipeline datasets to reduce the number of datasets republished during development.
• D. From Capacity settings in the Power Bi Admin portal, reduce the Max Intermediate Row Set Count setting.

Answer: A

Explanation:
Explanation
Previously in Power BI Desktop, when you used a DirectQuery in a report, no other data connections, whether DirectQuery or import, were allowed for that report. With composite models, that restriction is removed. A report can seamlessly include data connections from more than one DirectQuery or import data connection, in any combination you choose.
The composite models capability in Power BI Desktop consists of three related features:
* Composite models: Allows a report to have two or more data connections from different source groups, such as one or more DirectQuery connections and an import connection, two or more DirectQuery connections, or any combination thereof.
* Etc.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models

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

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

Answer: C,D

NEW QUESTION # 31
You are using DAX Studio to analyze a slow-running report query. You need to identify inefficient join operations in the query. What should you review?

• A. the query history
• B. the query statistics
• C. the server timings
• D. the query plan

Answer: D

Explanation:
Explanation
Open DAX Studio.
Paste the query there, enable Query Plan display and Server Timings, run your query (with clear cache), and then study the query plan for large row counts. Once the culprit is identified you can decide how to rewrite your DAX to make that part faster.
Reference: https://community.powerbi.com/t5/Power-Query/DAX-Query-taking-longer-time/td-p/1171961
https://www.sqlbi.com/wp-content/uploads/DAX-Query-Plans.pdf

NEW QUESTION # 32
You have a Power Bl workspace that contains one dataset and four reports that connect to the dataset. The dataset uses Import storage mode and contains the following data sources:
* A CSV file in an Azure Storage account
* An Azure Database for PostgreSQL database
You plan to use deployment pipelines to promote the content from development to test to production. There will be different data source locations for each stage. What should you include in the deployment pipeline to ensure that the appropriate data source locations are used during each stage?

• A. selective deployment
• B. auto-binding across pipelines
• C. parameter rules
• D. data source rules

Answer: C

Explanation:
Note: Create deployment rules
When working in a deployment pipeline, different stages may have different configurations. For example, each stage can have different databases or different query parameters. The development stage might query sample data from the database, while the test and production stages query the entire database.
When you deploy content between pipeline stages, configuring deployment rules enables you to allow changes to content, while keeping some settings intact. For example, if you want a dataset in a production stage to point to a production database, you can define a rule for this. The rule is defined in the production stage, under the appropriate dataset. Once the rule is defined, content deployed from test to production, will inherit the value as defined in the deployment rule, and will always apply as long as the rule is unchanged and valid.

NEW QUESTION # 33
You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements.
What should you do?

• A. Create a PBIT file and distribute the file to the sales managers.
• B. Grant the sales managers the Build permission for the existing Power Bl datasets.
• C. Grant the sales managers admin access to the existing Power Bl workspace.
• D. Create a deployment pipeline and grant the sales managers access to the pipeline.

Answer: A

Explanation:
Allow sales managers to perform ad hoc sales reporting with minimal effort Power BI report templates contain the following information from the report from which they were generated:
Report pages, visuals, and other visual elements
The data model definition, including the schema, relationships, measures, and other model definition items All query definitions, such as queries, Query Parameters, and other query elements What is not included in templates is the report's data.
Report templates use the file extension .PBIT (compare to Power BI Desktop reports, which use the .PBIX extension).
Note: With Power BI Desktop, you can create compelling reports that share insights across your entire organization. With Power BI Desktop templates, you can streamline your work by creating a report template, based on an existing template, which you or other users in your organization can use as a starting point for a new report's layout, data model, and queries. Templates in Power BI Desktop help you jump-start and standardize report creation.

NEW QUESTION # 34
You are attempting to configure certification for a Power BI dataset and discover that the certification setting for the dataset is unavailable.
What are two possible causes of the issue? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A. Row-level security (RLS) is missing from the dataset.
• B. The sensitivity level for the dataset is set to Highly Confidential.
• C. You have insufficient permissions.
• D. Dataset certification is disabled for the Power Bl tenant.
• E. The workspace is in shared capacity.

Answer: C,D

Explanation:
Explanation
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-endorsement-overview Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-setup-certification
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-endorse-content

NEW QUESTION # 35
......

DP-500 dumps Free Test Engine Verified By It Certified Experts: https://www.examstorrent.com/DP-500-exam-dumps-torrent.html

DP-500 Exam Free Practice Test with100% Accurate Answers: https://drive.google.com/open?id=1ng7izIDS-siNmDrAi2Z1qWLPjJ0HoRiX