Dec-2023 Download Free Latest Exam DP-500 Certified Sample Questions [Q54-Q78]

ExamBoosts December 9, 2023 DP-500 > Microsoft 0

Rate this post

Dec-2023 Download Free Latest Exam DP-500 Certified Sample Questions

Prepare for your exam certification with our DP-500 Certified Microsoft

To prepare for the Microsoft DP-500 certification exam, candidates should have a solid understanding of data analytics concepts, as well as experience working with Microsoft Azure and Microsoft Power BI. They should also be familiar with data storage and processing technologies, such as Azure Data Factory, Azure Databricks, and Azure Stream Analytics.

NEW QUESTION 54
Note: This question is part of a scries 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 creating a perspective that contains the commonly used fields.
Does this meet the goal?

Yes

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 55
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 ft. 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.

The loT GUID and loT ID columns
You need to analyze loT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You split the loT are column into a column named Date and a column named Time.
Does this meet the goal?

Yes

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

Which type of chart will the code produce?

a stacked bar chart

a pie chart

a bar chart

an area chart

Explanation
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.
Reference: https://matplotlib.org/3.5.0/api/_as_gen/matplotlib.pyplot.fill_between.html

NEW QUESTION 57
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?
A)

B)

C)

D)

Option A

Option B

Option C

Option D

NEW QUESTION 58
You need to provide users with a reproducible method to connect to a data source and transform the data by using an Al function. The solution must meet the following requirement
* Minimize development effort.
* Avoid including data in the file.
Which type of file should you create?

PBIDS

PBIX

PBIT

Explanation
A PBIT file is a template created by Power BI Desktop, a Microsoft application used to create reports and visualizations. It contains queries, visualization settings, data models, reports, and other data added by the user.
A PBIT file acts as a Power BI template. It doesn’t include any data from your source systems.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources

NEW QUESTION 59
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 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 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.

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-data-sensitivity-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/

NEW QUESTION 60
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?

From Report setting, select Personalize visuals.

From Tabular Editor, create a new perspective.

From the Bookmarks pane, select Focus mode, and then select Add.

From Visual options in Report settings, select Use the modern visual header with updated styling options.

Explanation
Enable personalization in a report
You can enable the feature either in Power BI Desktop or the Power BI service. You can also enable it in embedded reports.
To enable the feature in Power BI Desktop, go to File > Options and settings > Options > Current file > Report settings. Make sure Personalize visuals is turned on.

NEW QUESTION 61
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.

The workspace is in shared capacity.

You have insufficient permissions.

Dataset certification is disabled for the Power Bl tenant.

The sensitivity level for the dataset is set to Highly Confidential.

Row-level security (RLS) is missing from the dataset.

Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-endorse-content

NEW QUESTION 62
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 dbo.SalesTransactions where the SalesDate value is during the last three days.

a full refresh of all the tables

an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last hour.

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.
Overview
Contoso, Ltd. is a company that sells enriched financial data to a variety of external customers.
Contoso has a main office in Los Angeles and two branch offices in New York and Seattle.

NEW QUESTION 63
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?

parameter rules

selective deployment

auto-binding across pipelines

data source rules

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 64
You are creating a Power Bl report that will contain multiple visuals.
You need to ensure that the report is accessible to users who use a screen reader.
Which two configurations should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

consistent colors for each visual

consistent fonts for each visual

alt text for each visual

the tab order for each page

Play Axis for each page

NEW QUESTION 65
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.

NEW QUESTION 66
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?

[UserPermissions] – USERNAME()

[UserPermissions] – USERPRINCIPALNAME()

[User] = USERPRINCIPALNAME()

[User] = USERNAME()

[User] = USEROBJECTID()

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 67
You have the following Python code in an Apache Spark notebook.

Which type of chart will the code produce?

a stacked bar chart

a pie chart

a bar chart

an area chart

NEW QUESTION 68
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 ft. 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.

The loT GUID 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 split the loT DateTime column into a column named Date and a column named Time.
Does this meet the goal?

Yes

NEW QUESTION 69
You have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset.
You need to recommend an Azure Synapse Analytics pool for the data scientists. The solution must minimize costs.
Which type of pool should you recommend?

a Data Explorer pool

an Apache Spark pool

a dedicated SQL pool

a serverless SQL pool

In Azure Synapse, training machine learning models can be performed on the Apache Spark Pools with tools like PySpark/Python, Scala, or .NET.

NEW QUESTION 70
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 admin access to the existing Power Bl workspace.

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.

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

NEW QUESTION 71
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?

[UserPermissions] – USERNAME()

[UserPermissions] – USERPRINCIPALNAME()

[User] = USERPRINCIPALNAME()

[User] = USERNAMEQ()

[User] = USEROBJECTID()

NEW QUESTION 72
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.

Explanation
Box 1: SELECTEDMEASURENAME()
SELECTEDMEASURENAME is used by expressions for calculation items to determine the measure that is in context by name.
Syntax: SELECTEDMEASURENAME()
No parameters.
Example:
The following calculation item expression checks if the current measure is Expense Ratio and conditionally applies calculation logic. Since the check is based on a string comparison, it is not subject to formula fixup and will not benefit from object renaming being automatically reflected. For a similar comparison that would benefit from formula fixup, please see the ISSLECTEDMEASURE function instead.
IF (
SELECTEDMEASURENAME = “Expense Ratio”,
SELECTEDMEASURE (),
DIVIDE ( SELECTEDMEASURE (), COUNTROWS ( DimDate ) )
)
Box 2: SELECTEDVALUE()
SELECTEDVALUE returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.
Syntax:
SELECTEDVALUE(<columnName>[, <alternateResult>])
M1, M2, … – A list of measures.
Reference: https://docs.microsoft.com/en-us/dax/selectedmeasurename-function-dax
https://docs.microsoft.com/en-us/dax/selectedvalue-function

NEW QUESTION 73
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.

Reference:
https://matplotlib.org/stable/api/markers_api.html

NEW QUESTION 74
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 using openrowset with to explicitly specify the maximum length for businessName and surveyName.
Does this meet the goal?

Yes

Instead use Solution: You recommend using OPENROWSET WITH to explicitly define the collation for businessName and surveyName as Latin1_General_100_BIN2_UTF8.
Query Parquet files using serverless SQL pool in Azure Synapse Analytics.
Important
Ensure you are using a UTF-8 database collation (for example Latin1_General_100_BIN2_UTF8) because string values in PARQUET files are encoded using UTF-8 encoding. A mismatch between the text encoding in the PARQUET file and the collation may cause unexpected conversion errors. You can easily change the default collation of the current database using the following T-SQL statement: alter database current collate Latin1_General_100_BIN2_UTF8′.
Note: If you use the Latin1_General_100_BIN2_UTF8 collation you will get an additional performance boost compared to the other collations. The Latin1_General_100_BIN2_UTF8 collation is compatible with parquet string sorting rules. The SQL pool is able to eliminate some parts of the parquet files that will not contain data needed in the queries (file/column-segment pruning). If you use other collations, all data from the parquet files will be loaded into Synapse SQL and the filtering is happening within the SQL process. The Latin1_General_100_BIN2_UTF8 collation has additional performance optimization that works only for parquet and CosmosDB. The downside is that you lose fine-grained comparison rules like case insensitivity.

NEW QUESTION 75
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?

Change the font color of values in the Sales column to white.

Change the red background color to orange.

Add icons to represent the sales status of each product.

Add additional measures to the table values.

Themes, contrast and colorblind-friendly colors
You should ensure that your reports have enough contrast between text and any background colors.
Certain color combinations are particularly difficult for users with color vision deficiencies to distinguish. These include the following combinations:
**—> green and black
green and red
green and brown
blue and purple
green and blue
light green and yellow
blue and grey
green and grey
Avoid using these colors together in a chart, or on the same report page.

NEW QUESTION 76
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?

Yes

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 77
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.

NEW QUESTION 78
You plan to create a Power Bl report that will use an OData feed as the data source. You will retrieve all the entities from two different collections by using the same service root The OData feed is still in development. The location of the feed will change once development is complete.
The report will be published before the OData feed development is complete.
You need to minimize development effort to change the data source once the location 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.

Explanation
Graphical user interface, text, application Description automatically generated

Step 1: Create a parameter that contains the service root URI
Step 2: Get data from OData feed source and use the parameter to populate the first part of the URL.
The URI is in the first part of the query.
Example: let
Source = OData.Feed
(“https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/WorkItemSnapshot? “
&”$apply=filter( “
&”WorkItemType eq ‘Bug’ “
&”and StateCategory ne ‘Completed’ “
&”and startswith(Area/AreaPath,'{areapath}’) “
&”and DateValue ge {startdate} “
&”) “
&”/groupby( “
&”(DateValue,State,WorkItemType,Priority,Severity,Area/AreaPath,Iteration/IterationPath,AreaSK), “
&”aggregate($count as Count) “
&”) “
,null, [Implementation=”2.0″,OmitValues = ODataOmitValues.Nulls,ODataVersion = 4]) in Source Box 3: From Advanced Editor, duplicate the query and change the resource path in the URL.
Choose Get Data, and then Blank Query.
From the Power BI Query editor, choose Advanced Editor.
The Advanced Editor window opens.
Edit the query.
Etc.
Reference: https://docs.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect

Loading …