DP-500 Online Practice Questions and Answers

DRAG DROP

You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails contains three date columns named OrderDate, CreatedOnDate, and ModifiedDate.

You need to implement an incremental refresh of SalesDetails. The solution must ensure that OrderDate starts on or after the beginning of the prior year.

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.

NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Select and Place:

HOTSPOT

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.

Hot Area:

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.

Select and Place:

You have a Power Bl dataset that uses DirectQuery against an Azure SQL database.

Multiple reports use the dataset.

A database administrator reports that too many queries are being sent from Power Bl to the database.

You need to reduce the number of queries sent to the database. The solution must meet the following requirements:

DirectQuery must continue to be used.

Visual interactions in all the reports must remain as they are configured currently.

Consumers of the reports must only be allowed to apply filters from the Filter pane.

Which two settings should you select? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. Disabling cross highlighting/filtering by default

B. Add a single Apply button to the filter pane to apply changes at once

C. Add an Apply button to each slicer to apply changes when you're ready

D. Add Apply buttons to all basic filters to apply changes when you're ready

E. Ignore the Privacy Levels and potentially improve performance

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?

A. Yes

B. No

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. parameter rules

B. selective deployment

C. auto-binding across pipelines

D. data source rules

You are using GitHub as a source control solution for an Azure Synapse Studio workspace. You need to modify the source control solution to use an Azure DevOps Git repository. What should you do first?

A. Disconnect from the GitHub repository.

B. Create a new pull request.

C. Change the workspace to live mode.

D. Change the active branch.

You need to recommend a solution for the analysts in the Finance and Accounting business unit to mitigate the increase in maintenance of their assets in the Power BI tenant.

Which two actions should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. Use Microsoft Purview to search for datasets that contain the relevant data.

B. Perform impact analysis on the relevant data source.

C. Create a live connection to a Power BI dataset.

D. Create a Power BI template app.

You have an Azure Synapse Analytics notebook.

You run the %%sql magic command to render data into an Apache Spark DataFrame named df1, and then you run the following code.

display(df1, summary = true)

Which three attributes will be returned by the command? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. type

B. range

C. missing

D. unique

E. ordinal

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 Data Frame in a tabular view. Which method should you invoke on the Data Frame?

A. sample

B. describe

C. freqItems

D. explain