Microsoft Azure Enterprise Data Analyst DP-500 Updated Dumps

test2023-01-17T08:43:51+00:00

By test DP-500 free questions, Microsoft Azure Enterprise Data Analyst DP-500 Updated Dumps 0 Comments

Are you preparing for the Microsoft DP-500 certification exam? If so, you’ll be happy to know that the Microsoft Azure Enterprise Data Analyst DP-500 Dumps have been recently updated to ensure that you have the most current and accurate information for your test preparation.To help you pass the exam, it is important that you have a good understanding of the exam content and format, as well as the types of questions that will be asked. This is where the Microsoft Azure Enterprise Data Analyst DP-500 Dumps come in.

The Microsoft Azure Enterprise Data Analyst DP-500 Dumps provide you with a realistic representation of the types of questions you will encounter on the actual exam. They cover a wide range of topics, from basic to advanced, and are designed to test your knowledge and understanding of the key concepts.The Microsoft Azure Enterprise Data Analyst DP-500 Dumps are also an excellent tool for testing your readiness for the exam. They allow you to identify areas where you need to focus your studying, and give you an idea of what to expect on test day.

Page 1 of 3

1. You have a Power Bl tenant that contains 10 workspaces.

You need to create dataflows in three of the workspaces. The solution must ensure that data engineers can access the resulting data by using Azure Data Factory.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point

Associate the Power Bl tenant to an Azure Data Lake Storage account.

Add the managed identity for Data Factory as a member of the workspaces.

Create and save the dataflows to an Azure Data Lake Storage account.

Create and save the dataflows to the internal storage of Power BI

2. You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure.

Which function should you use in the query?

PIVOT

GROUPING

PREDICT

CAST

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

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

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

the workspace admins of any workspace that uses the dataset

the Power Bl admins

all the workspace members of any workspace that uses the dataset

5. 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()

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

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

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

9. You have a Power Bl report that contains the table shown in the following exhibit.

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency.

What should you do?

Add alt text to explain the information that each color conveys.

Move the conditional formatting icons to a tooltip report.

Change the icons to use a different shape for each color.

Remove the icons and use red, yellow, and green background colors instead.

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

Page 2 of 3

11. DRAG DROP

You have an Azure Synapse Analytics serverless SQL pool.

You need to return a list of files and the number of rows in each file.

How should you complete the Transact-SQL statement? 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.

12. You need to recommend a solution to resolve the query issue of the serverless SQL pool.

The solution must minimize impact on the users.

What should you in the recommendation?

Update the statistics for the serverless SQL pool.

Move the data from the serverless SQL pool to a dedicated Apache Spark pool.

Execute the sp_sec_process_daca_limic stored procedure for the serverless SQL pool.

Move the data from the serverless SQL pool to a dedicated SQL pool.

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

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

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

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

Enable the large dataset storage format for workspace.

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

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

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

Option A

Option B

Option C

Option D

17. Your company is migrating its current, custom-built reporting solution to Power BI.

The Power BI tenant must support the following scenarios:

✑ 40 reports that will be embedded in external websites. The websites control their own security. The reports will be consumed by 50 users monthly.

✑ Forty-five users that require access to the workspaces and apps in the Power BI Admin portal. Ten of the users must publish and consume datasets that are larger than 1 GB.

✑ Ten developers that require Text Analytics transformations and paginated reports for datasets. An additional 15 users will consume the reports.

You need to recommend a licensing solution for the company. The solution must minimize costs.

Which two Power BI license options should you include in the recommendation? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

70 Premium per user

one Premium

70 Pro

one Embedded

35 Pro

35 Premium per user

18. You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)

The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)

You need to reduce the model size by eliminating invalid relationships.

Which column should you remove?

Sales[Sales Amount]

Sales[RowlD]

Sales[Sales ID]

Plan[RowlD]

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

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

Page 3 of 3

21. You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses Import storage mode. You need to ensure that the report page updates all the visuals every 30 minutes.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Enable Power Bl embedded.

Configure the data sources to use DirectQuery.

Configure the data sources to use a streaming dataset

Select Auto page refresh.

Enable the XMIA endpoint.

Add a Microsoft Power Automate visual to the report page.

22. You are optimizing a dataflow in a Power Bl Premium capacity. The dataflow performs multiple joins. You need to reduce the load time of the dataflow.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Reduce the memory assigned to the dataflows.

Execute non-foldable operations before foldable operations.

Execute foldable operations before non-foldable operations.

Place the ingestion operations and transformation operations in a single dataflow.

Place the ingestion operations and transformation operations in separate dataflows.

23. 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')

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

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

26. You have a Power Bl data model.

You need to refresh the data from the source every 15 minutes.

What should you do first?

Enable the XMLA endpoint.

Define an incremental refresh policy.

Change the storage mode of the dataset.

Configure a scheduled refresh.

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

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

29. 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 defining an external table for the Parquet files and updating the query to use the table

Does this meet the goal?

Yes