DP-500 Exam - Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

NEW QUESTION 1

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?

• A. PBIDS
• B. PBIX
• C. PBIT

Answer: A

NEW QUESTION 2

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 3

You have a Power Bl dataset that contains the following measure.

You need to improve the performance of the measure without affecting the logic or the results. What should you do?

• A. Replace both calculate functions by using a variable that contains the calculate function.
• B. Remove the alternative result of blank( ) from the divide function.
• C. Create a variable and replace the values for [sales Amount].
• D. Remove "calendar'[Flag] = "YTD" from the code.

Answer: A

NEW QUESTION 4

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.

Answer: A

NEW QUESTION 5

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 6

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?

• A. Yes
• B. No

Answer: B

NEW QUESTION 7

You have an Azure Synapse Analytics dedicated SQL pool.
You need to ensure that the SQL pool is scanned by Azure Purview. What should you do first?

• A. Register a data source.
• B. Search the data catalog.
• C. Create a data share connection.
• D. Create a data policy.

Answer: B

NEW QUESTION 8

You are building a Power Bl dataset that will use two data sources.
The dataset has a query that uses a web data source. The web data source uses anonymous authentication. You need to ensure that the query can be used by all the other queries in the dataset.
Which privacy level should you select for the data source?

• A. Public
• B. Organizational
• C. Private
• D. None

Answer: C

NEW QUESTION 9

You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the visual. What should you do?

• A. Replace long text with abbreviations and acronyms.
• B. Configure a unique marker for each series.
• C. Configure a distinct color for each series.
• D. Move important information to a tooltip.

Answer: B

NEW QUESTION 10

You are configuring an aggregation table as shown in the following exhibit.

The detail table is named FactSales and the aggregation table is named FactSales(Agg). You need to aggregate SalesAmount for each store.
Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the appropriate options in the answer area,
NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 11

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?

• A. freqltems
• B. explain
• C. rollup
• D. summary

Answer: D

NEW QUESTION 12

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 define the collation for businessName and surveyName as Latim_Generai_100_BiN2_UTF8.
Does this meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 13

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?

• A. Yes
• B. No

Answer: B

NEW QUESTION 14

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 15

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 16

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.

• A. Create a managed identity in Azure Active Directory (Azure AD).
• B. 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.
• C. Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.
• D. Register a data source.
• E. Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.

Answer: ACD

NEW QUESTION 17

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

Answer: B

NEW QUESTION 18

You have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains a dataset. During a scheduled refresh, you receive the following error message: "Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB."
You need to ensure that you can refresh the dataset.
What should you do?

• A. Turn on Large dataset storage format.
• B. Connect Workspace1 to an Azure Data Lake Storage Gen2 account
• C. Change License mode to Premium per user.
• D. Change the location of the Premium capacity.

Answer: A

NEW QUESTION 19

You need to populate the CustomersWithProductScore table.
How should you complete the stored procedure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 20
......