ExamGecko
Login
Home / Microsoft / DP-500 / List of questions
Ask Question

Microsoft DP-500 Practice Test - Questions Answers

Add to Whishlist

List of questions

Question 1

Report Export Collapse

What should you configure in the deployment pipeline?

a backward deployment
a backward deployment
a selective deployment
a selective deployment
auto-binding
auto-binding
a data source rule
a data source rule
Suggested answer: D
Explanation:

Development Process Requirements

Litware identifies the following development process requirements:

SQLDW and datalake1 will act as the development environment. Once feature development is complete, all entities in synapseworkspace1 will be promoted to a test workspace, and then to a production workspace.

Power BI content must be deployed to test and production by using deployment pipelines.

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.

You can configure data source rules and parameter rules.

Incorrect:

Not B: if you already have a steady production environment, you can deploy it backward (to Test or

Dev, based on your need) and set up the pipeline. The feature is not limited to any sequential orders.

Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-getstarted#step-4---create-deployment-rules

asked 02/10/2024
Carlos Periterra
42 questions

Question 2

Report Export Collapse

DRAG DROP

You need to implement object-level security (OLS) in the Power Bl dataset for the sales associates.

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.


Microsoft DP-500 image Question 2 90253 10022024015932000
Correct answer: Microsoft DP-500 image answer Question 2 90253 10022024015932000
asked 02/10/2024
Juli Santo
42 questions

Question 3

Report Export Collapse

HOTSPOT

You need to populate the CustomersWithProductScore table.

How should you complete the stored procedure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft DP-500 image Question 3 90254 10022024015932000
Correct answer: Microsoft DP-500 image answer Question 3 90254 10022024015932000
Explanation:

Box 1: FLOAT

Identify which customers should receive promotional emails based on their likelihood of purchasing promoted products.

FLOT is used in the last statement of the code: WITH (score FLOAT) as p;

From syntax: MODEL

The MODEL parameter is used to specify the model used for scoring or prediction. The model is specified as a variable or a literal or a scalar expression.

Box 2: dbo.CustomerWithProductScore

Identify which customers should receive promotional emails based on their likelihood of purchasing promoted products.

Only table CustomerWithProductScore has the required filed score.

From the syntax:

DATA

The DATA parameter is used to specify the data used for scoring or prediction. Data is specified in the form of a table source in the query. Table source can be a table, table alias, CTE alias, view, or tablevalued function.

Reference: https://docs.microsoft.com/en-us/sql/t-sql/queries/predict-transact-sql

asked 02/10/2024
Tiro malope
44 questions

Question 4

Report Export Collapse

DRAG DROP

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.


Microsoft DP-500 image Question 4 90255 10022024015932000
Correct answer: Microsoft DP-500 image answer Question 4 90255 10022024015932000
Explanation:

Step 1: From powerbi.com, create a new report..

The company wants custom Power BI usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace each month.

Step 2: Add a report measure

Measures are used in some of the most common data analyses. Simple summarizations such as sums, averages, minimum, maximum and counts can be set through the Fields well. The calculated results of measures are always changing in response to your interaction with your reports, allowing for fast and dynamic ad-hoc data exploration.

Step 3: Add visuals to the report

Step 4: Publish the report to the Sales Analytics workspace

Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-measures

asked 02/10/2024
Dilara Unsal
35 questions

Question 5

Report Export Collapse

You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements.

What should you do?

Grant the sales managers the Build permission for the existing Power Bl datasets.
Grant the sales managers the Build permission for the existing Power Bl datasets.
Grant the sales managers admin access to the existing Power Bl workspace.
Grant the sales managers admin access to the existing Power Bl workspace.
Create a deployment pipeline and grant the sales managers access to the pipeline.
Create a deployment pipeline and grant the sales managers access to the pipeline.
Create a PBIT file and distribute the file to the sales managers.
Create a PBIT file and distribute the file to the sales managers.
Suggested answer: D
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.

Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-templates

asked 02/10/2024
james james
39 questions

Question 6

Report Export Collapse

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.

From the Power Bl Admin portal, set Allow users to apply sensitivity labels for Power Bl content to Enabled.
From the Power Bl Admin portal, set Allow users to apply sensitivity labels for Power Bl content to Enabled.
From the Power Bl Admin portal, set Apply sensitivity labels from data sources to their data in Power Bl to Enabled.
From the Power Bl Admin portal, set Apply sensitivity labels from data sources to their data in Power Bl to Enabled.
In SQLDW. apply sensitivity labels to the columns in the Customer and CustomersWithProductScore tables.
In SQLDW. apply sensitivity labels to the columns in the Customer and CustomersWithProductScore tables.
In the Power Bl datasets, apply sensitivity labels to the columns in the Customer and CustomersWithProductScore tables.
In the Power Bl datasets, apply sensitivity labels to the columns in the Customer and CustomersWithProductScore tables.
From the Power Bl Admin portal, set Make certified content discoverable to Enabled.
From the Power Bl Admin portal, set Make certified content discoverable to Enabled.
Suggested answer: A, D, E
Explanation:

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.

Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-security-enable-datasensitivity-labels

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

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

asked 02/10/2024
Louis Flink
53 questions

Question 7

Report Export Collapse

How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?

an incremental refresh of Product where the ModifiedDate value is during the last three days.
an incremental refresh of Product where the ModifiedDate value is during the last three days.
an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last three days.
an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last three days.
a full refresh of all the tables
a full refresh of all the tables
an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last hour.
an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last hour.
Suggested answer: B
Explanation:

The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in SQLDW up to three days after being created. The records do NOT change after three days.

asked 02/10/2024
Oktorio Rizki Prasetya
48 questions

Question 8

Report Export Collapse

HOTSPOT

You need to create a measure to count orders for the market basket analysis.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft DP-500 image Question 8 90259 10022024015932000
Correct answer: Microsoft DP-500 image answer Question 8 90259 10022024015932000
asked 02/10/2024
RANA MANSOUR
40 questions

Question 9

Report Export Collapse

You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from the Microsoft SQL Server data warehouse.

What should you include in the recommendation?

Azure Purview
Azure Purview
Site-to-Site VPN
Site-to-Site VPN
an XMLA endpoint
an XMLA endpoint
the on-premises data gateway
the on-premises data gateway
Suggested answer: D
asked 02/10/2024
Yucel Cetinkaya
47 questions

Question 10

Report Export Collapse

You need to recommend a solution for the customer workspaces to support the planned changes.

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

NOTE: Each correct selection is worth one point.

Set Use datasets across workspaces to Enabled
Set Use datasets across workspaces to Enabled
Publish the financial data to the web.
Publish the financial data to the web.
Grant the Build permission for the financial data to each customer.
Grant the Build permission for the financial data to each customer.
Configure the FinData workspace to use a Power Bl Premium capacity.
Configure the FinData workspace to use a Power Bl Premium capacity.
Suggested answer: A, D
Explanation:

Build a new dataset in the FinData workspace by using data from the Synapse Analytics dedicated SQL pool.

Provide all the customers with their own Power BI workspace to create their own reports. Each workspace will use the new dataset in the FinData workspace

Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-admin-acrossworkspaces

asked 02/10/2024
Nelson Mira
50 questions
Total 162 questions
Go to page: of 17
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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?
DRAG DROP You have a Power Bl dataset that contains the following measures: • Budget • Actuals • Forecast You create a report that contains 10 visuals. You need provide users with the ability to use a slicer to switch between the measures in two visuals only. You create a dedicated measure named cg Measure switch. How should you complete the DAX expression for the Actuals measure? 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.
HOTSPOT You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly telemetry dat a. The data is organized in folders by the year, month, and day according to when the telemetry was captured. You have the following query in Power Query Editor. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point
You are creating a Python visual in Power Bl Desktop. You need to retrieve the value of a column named Unit Price from a DataFrame. How should you reference the Unit Price column in the Python code?
You have an Azure Synapse Analytics serverless SQL pool. You need to catalog the serverless SQL pool by using Azure Purview. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
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?
You have a Power Bl report that contains a card. The card displays the value for year-to-date revenue. You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed. What should you do?
HOTSPOT 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.
DRAG DROP You have a shared dataset in Power Bl named Dataset1. You have an on-premises Microsoft SQL Server database named DB1. You need to ensure that Dataset1 refreshes data from DB1. 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.
HOTSPOT 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.