Microsoft DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Online Training
Microsoft DP-500 Online Training
The questions for DP-500 were last updated at Oct 28,2024.
- Exam Code: DP-500
- Exam Name: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
- Certification Provider: Microsoft
- Latest update: Oct 28,2024
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
DRAG DROP
You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one report.
You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast.
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.
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.
HOTSPOT
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.
DRAG DROP
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.
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
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’)
DRAG DROP
You are using DAX Studio to query an XMLA endpoint.
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.
HOTSPOT
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.
HOTSPOT
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.