How Many Questions Of DP-500 Latest Exam

NEW QUESTION 1

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 2

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

• A. Associate the Power Bl tenant to an Azure Data Lake Storage account.
• B. Add the managed identity for Data Factory as a member of the workspaces.
• C. Create and save the dataflows to an Azure Data Lake Storage account.
• D. Create and save the dataflows to the internal storage of Power BL

Answer: AB

NEW QUESTION 3

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?

• A. DirectQuery for the external customers and import for the security team.
• B. DirectQuery for the external customers and DirectQuery for the security team.
• C. Import for the external customers and DirectQuery for the security team.
• D. Import for the external customers and import for the security team.

Answer: A

NEW QUESTION 4

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 5

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

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

You have a 2-GB Power Bl dataset.
You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize how long it will take to apply changes to the dataset from powerbi.com.
Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point

• A. Enable service principal authentication for read-only admin APIs.
• B. Turn on Large dataset storage format.
• C. Connect the target workspace to an Azure Data Lake Storage Gen2 account.
• D. Enable XMLA read-write.

Answer: D

NEW QUESTION 9

You use Azure Synapse Analytics and Apache Spark notebooks to You need to use PySpark to gain access to the visual libraries. Which Python libraries should you use?

• A. Seaborn only
• B. Matplotlib and Seaborn
• C. Matplotlib only
• D. Matplotlib and TensorFlow
• E. TensorFlow only
• F. Seaborn and TensorFlow

Answer: E

NEW QUESTION 10

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 11

You need to recommend a solution for the customer workspaces to support the planned changes.
Which two configurations should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. Set Use datasets across workspaces to Enabled
• B. Publish the financial data to the web.
• C. Grant the Build permission for the financial data to each customer.
• D. Configure the FinData workspace to use a Power Bl Premium capacity.

Answer: C

NEW QUESTION 12

You are using DAX Studio to analyze a slow-running report query. You need to identify inefficient join operations in the query. What should you review?

• A. the query statistics
• B. the query plan
• C. the query history
• D. the server timings

Answer: B

NEW QUESTION 13

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 14

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.

• A. Yes
• B. Not Mastered

Answer: A

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

• A. From Tabular Editor, create a new role.
• B. Hide all the fields in the dataset.
• C. Configure object-level security (OLS).
• D. From Tabular Editor, create a new perspective.

Answer: B

NEW QUESTION 16

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 17

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 18

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?

• A. JSON
• B. Apache Parquet
• C. CSV
• D. Delta

Answer: C

NEW QUESTION 19
......