Microsoft DP-500 Exam Questions - Best Way Towards Success

Microsoft DP-500 Exam Questions – Best Way Towards Success

Jonnie Karnath2023-03-14T16:52:04+00:00

Practicing with Microsoft DP-500 exam questions is an essential part of preparing for the Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI exam, and can greatly increase the chances of success. To maximize your chances of success on the DP-500 exam, it’s essential to focus on your weak areas and practice extensively. By practicing with Microsoft DP-500 exam questions, candidates can also identify areas where they need to improve their knowledge, and focus their studying efforts accordingly. Additionally, by answering these questions under timed conditions, candidates can simulate the exam environment and become more comfortable with the format and pacing of the actual exam.

Page 1 of 4

1. You develop a solution that uses a Power Bl Premium capacity. The capacity contains a dataset that is expected to consume 50 GB of memory.

Which two actions should you perform to ensure that you can publish the model successfully to the Power Bl service? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Increase the Max Offline Dataset Size setting.

Invoke a refresh to load historical data based on the incremental refresh policy.

Restart the capacity.

Publish an initial dataset that is less than 10 G

Publish the complete dataset.

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

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

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

rollup

cov

explain

describe

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

Request the authors of the deployment pipeline datasets to reduce the number of datasets republished during development.

In the dataset, delete the fact table.

Configure the dataset to use a composite model that has a DirectQuery connection to the fact table.

From Capacity settings in the Power Bi Admin portal, reduce the Max Intermediate Row Set Count setting.

6. 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 Dataset1.

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 Power Bl Desktop, you create a hierarchy.

Does this meet the goal?

Yes

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

Create a managed identity in Azure Active Directory (Azure AD).

Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.

Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.

Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.

8. You are optimizing a Power Bl data model by using DAX Studio.

You need to capture the query events generated by a Power Bl Desktop report.

What should you use?

the DMV list

a Query Plan trace

an All Queries trace

a Server Timings trace

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

10. DRAG DROP

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.

Page 2 of 4

11. 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 Dataset1.

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 Tabular Editor, you create a calculation group.

Does this meet the goal?

Yes

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

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

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

Create calculated columns in Dataset1.

Remove the relationships from Dataset1.

Normalize the tables in DB1.

Denormalize the tables in DB1.

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

16. HOTSPOT

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.

17. You are creating an external table by using an Apache Spark pool in Azure Synapse Analytics. The table will contain more than 20 million rows partitioned by date. The table will be shared with the SQL engines.

You need to minimize how long it takes for a serverless SQL pool to execute a query data against the table.

In which file format should you recommend storing the table data?

JSON

Apache Parquet

CSV

Delta

18. DRAG DROP

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.

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

20. HOTSPOT

You use Vertipaq Analyzer to analyze a model.

The Relationships tab contains the results 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.

Page 3 of 4

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

DirectQuery for the external customers and import for the security team.

DirectQuery for the external customers and DirectQuery for the security team.

Import for the external customers and DirectQuery for the security team.

Import for the external customers and import for the security team.

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

Turn off auto refresh when publishing the dataset changes to the Power Bl service.

In the dataset. change the fact table from an import table to a hybrid table.

Enable the large dataset storage format for workspace.

Create a dataset parameter to reduce the fact table row count in the development and test pipelines.

23. HOTSPOT

You have an Azure Synapse notebook.

You need to create the visual shown in the following exhibit.

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

24. You need to identify the root cause of the data refresh issue.

What should you use?

the Usage Metrics Report in powerbi.com

Query Diagnostics in Power Query Editor

Performance analyzer in Power Bl Desktop

25. DRAG DROP

You need to create Power BI 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.

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

Remove the data source permissions.

Delete all the Power Query Editor objects.

Modify the source of each query.

Update all the parameter values.

Delete all the calculated tables.

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

pandas.DataFrame('Unit Price')

dataset['Unit Price']

data = [Unit Price]

('Unit Price')

28. HOTSPOT

You need to configure a source control solution for Azure Synapse Analytics.

The solution must meet the following requirements:

• Code must always be merged to the main branch before being published, and the main branch must be used for publishing resource

• The workspace templates must be stored in the publish branch.

• A branch named dev123 will be created to support the development of a new feature.

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

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

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

Page 4 of 4

31. You have a Power Bl dataset that has only the necessary fields visible for report development.

You need to ensure that end users see only 25 specific fields that they can use to personalize visuals.

What should you do?

From Tabular Editor, create a new role.

Hide all the fields in the dataset.

Configure object-level security (OLS).

From Tabular Editor, create a new perspective.

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?

parameter rules

selective deployment

auto-binding across pipelines

data source rules

33. Topic 3, Misc. Questions

DRAG DROP

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.

34. DRAG DROP

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.

35. 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 BI 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 denormalizing the data model.

Does this meet the goal?

Yes

Facebook Twitter LinkedIn Google + Email