DP-500 | All About Printable DP-500 Practice Question

NEW QUESTION 1

You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly telemetry data. The data is organized in folders by the year, month, and day according to when the telemetry was captured.
You have the following query in Power Query Editor.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 2

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 3

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.

• A. Increase the Max Offline Dataset Size setting.
• B. Invoke a refresh to load historical data based on the incremental refresh policy.
• C. Restart the capacity.
• D. Publish an initial dataset that is less than 10 GB.
• E. Publish the complete dataset.

Answer: CE

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

• A. any users that accessed a report that uses the dataset within the last 30 days
• B. the workspace admins of any workspace that uses the dataset
• C. the Power Bl admins
• D. all the workspace members of any workspace that uses the dataset

Answer: C

NEW QUESTION 5

You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column.
pfflag = IF('Calendar'[Date] < TOOAYQ, "Past", "Future")
You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements:
• Returns the fiscal prior year-to-date value for [sales Amount]
• Uses a fiscal year end of June 30
• Produces no result for dates in the future
How should you complete the DAX expression? 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 6

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

You need to make the visual more accessible to users who have color vision deficiency. What should you do?

• A. Change the font color of values in the Sales column to white.
• B. Change the red background color to orange.
• C. Add icons to represent the sales status of each product.
• D. Add additional measures to the table values.

Answer: B

NEW QUESTION 7

You have new security and governance protocols for Power Bl reports and datasets. The new protocols must meet the following requirements.
• New reports can be embedded only in locations that require authentication.
• Live connections are permitted only for workspaces that use Premium capacity datasets.
Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.
• B. From the Premium per user settings, set XMLA Endpoint to Off.
• C. From Embed Codes, delete all the codes.
• D. From Capacity settings, set XMLA Endpoint to Read Write.
• E. From Tenant settings, set Publish to web to Disable.

Answer: A

NEW QUESTION 8

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 9

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 10

What should you configure in the deployment pipeline?

• A. a backward deployment
• B. a selective deployment
• C. auto-binding
• D. a data source rule

Answer: C

NEW QUESTION 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 Power Bl Desktop, you create a hierarchy. Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 12

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 13

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

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?

• A. the DMV list
• B. a Query Plan trace
• C. an All Queries trace
• D. a Server Timings trace

Answer: D

NEW QUESTION 17

You have a Power Bl workspace named Workspacel that contains five dataflows.
You need to configure Workspacel to store the dataflows in an Azure Data Lake Storage Gen2 account What should you do first?

• A. Delete the dataflow queries.
• B. From the Power Bl Admin portal, enable tenant-level storage.
• C. Disable load for all dataflow queries.
• D. Change the Data source settings in the dataflow queries.

Answer: D

NEW QUESTION 18

You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the Apache Parquet format. A sample of the data is shown in the following table.

You need to create a Transact-SQL query that will return the source IP address.
Which function should you use in the select statement to retrieve the source IP address?

• A. JS0N_VALUE
• B. FOR.JSON
• C. CONVERT
• D. FIRST VALUE

Answer: A

NEW QUESTION 19
......