Microsoft DP-500 Free Practice Questions

NEW QUESTION 1

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 2

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 3

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 4

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 5

You have the following code in an Azure Synapse notebook.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the code.
NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 6

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 7

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 8

You are configuring a Power Bl report for accessibility as shown in the following table.

You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency. Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. Theme colors
• B. Sentiment colors
• C. Divergent colors
• D. First-level elements colors

Answer: D

NEW QUESTION 9

You have a Power Bl dataset that uses DirectQuery against an Azure SQL database. Multiple reports use the dataset.
A database administrator reports that too many queries are being sent from Power Bl to the database.
You need to reduce the number of queries sent to the database. The solution must meet the following requirements:
• DirectQuery must continue to be used.
• Visual interactions in all the reports must remain as they are configured currently.
• Consumers of the reports must only be allowed to apply filters from the Filter pane. Which two settings should you select? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. Disabling cross highlighting/filtering by default
• B. Add a single Apply button to the filter pane to apply changes at once
• C. Add an Apply button to each slicer to apply changes when you're ready
• D. Add Apply buttons to all basic filters to apply changes when you're ready
• E. Ignore the Privacy Levels and potentially improve performance

Answer: CD

NEW QUESTION 10

You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column.
pfflag = IF('Calendar'[Date] < TOOAYQ>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 11

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 12

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 13

You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. A sample of the data in the Sales table is shown in the following table.

A sample of the data in the Commission table is shown in the following table.

You need to merge the tables by using Power Query Editor without losing any rows in the Sales table. How should you complete the query? 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 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 report that contains one visual.
You need to provide users with the ability to change the visual type without affecting the view for other users. What should you do?

• A. From Report setting, select Personalize visuals.
• B. From Tabular Editor, create a new perspective.
• C. From the Bookmarks pane, select Focus mode, and then select Add.
• D. From Visual options in Report settings, select Use the modern visual header with updated styling options.

Answer: A

NEW QUESTION 16

You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from the Microsoft SQL Server data warehouse.
What should you include in the recommendation?

• A. Azure Purview
• B. Site-to-Site VPN
• C. an XMLA endpoint
• D. the on-premises data gateway

Answer: D

NEW QUESTION 17
......