The Regenerate Guide To DP-500 Test Preparation

NEW QUESTION 1

You have a Power Bl data model.
You need to refresh the data from the source every 15 minutes. What should you do first?

• A. Enable the XMLA endpoint.
• B. Define an incremental refresh policy.
• C. Change the storage mode of the dataset.
• D. Configure a scheduled refresh.

Answer: A

NEW QUESTION 2

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?

• A. pandas.DataFrame('Unit Price')
• B. dataset['Unit Price']
• C. data = [Unit Price]
• D. ('Unit Price')

Answer: A

NEW QUESTION 3

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 4

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 Datasetl.
In Datasetl, 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 group the measures in a display folder. Does this meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 5

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 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 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 normalizing the data model. Does this meet the goal?

• A. Yes
• B. No

Answer: A

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 have an Azure Synapse workspace named Workspace1.
You need to use PySpark in a notebook to read data from a SQL pool as an Apache Spark DataFrame and display the top five
How should you complete the code? 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 9

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 10

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 11

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 12

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 13

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 14

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 15

You are running a diagnostic against a query as shown in the following exhibit.

What can you identify from the diagnostics query?

• A. All the query steps are folding.
• B. Elevated permissions are being used to query records.
• C. The query is timing out.
• D. Some query steps are folding.

Answer: D

NEW QUESTION 16

You are creating a Power Bl Desktop report. You add a Python visual to the report page.
You plan to create a scatter chart to visualize the data. You add Python code to the Python script editor.
You need to create the scatter chart.
How should you complete the Python code? 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 17

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.

Answer: C

NEW QUESTION 18

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 19

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 20

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 21
......