DP-500 Online Practice Questions and Answers

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.

Select and Place:

DRAG DROP

You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in the following table.

Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each pool type 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.

Select and Place:

HOTSPOT

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.

Hot Area:

HOTSPOT

You have a Power Bl dataset that has the query dependencies 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.

Hot Area:

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

You plan to modify a Power Bl dataset.

You open the Impact analysis panel for the dataset and select Notify contacts.

Which contacts will be notified when you use the Notify contacts feature?

A. any users that accessed a report that uses the dataset within the last 30 days

B. the workspace admins of any workspace that uses the dataset

C. the Power Bl admins

D. all the workspace members of any workspace that uses the dataset

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. Create calculated columns in Dataset1.

B. Remove the relationships from Dataset1.

C. Normalize the tables in DB1.

D. Denormalize the tables in DB1.

You have two Power BI reports named Report1 and Report2.

Report1 connects to a shared dataset named Dataset1.

Report2 connects to a local dataset that has the same structure as Dataset1. Report2 contains several calculated tables and parameters.

You need to prepare Report2 to use Dataset1.

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

NOTE: Each correct selection is worth one point.

A. Remove the data source permissions.

B. Delete all the Power Query Editor objects.

C. Modify the source of each query.

D. Update all the parameter values.

E. Delete all the calculated tables.

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 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?

A. Azure Purview

B. Site-to-Site VPN

C. an XMLA endpoint

D. the on-premises data gateway