Microsoft DP-500 Real Exam Questions
The questions for DP-500 were last updated at Sep 05,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: Sep 05,2024
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 need to recommend a solution to ensure that sensitivity labels are applied. The solution must minimize administrative effort.
Which three actions should you include in the recommendation? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . From the Power Bl Admin portal, set Allow users to apply sensitivity labels for Power Bl content to Enabled.
- B . From the Power Bl Admin portal, set Apply sensitivity labels from data sources to their data in Power Bl to Enabled.
- C . In SQLDW. apply sensitivity labels to the columns in the Customer and Customers With Product Score tables.
- D . In the Power Bl datasets, apply sensitivity labels to the columns in the Customer and Customers With Product Score tables.
- E . From the Power Bl Admin portal, set Make certified content discoverable to Enabled.
You are planning a Power Bl solution for a customer.
The customer will have 200 Power Bl users.
The customer identifies the following requirements:
• Ensure that all the users can create paginated reports.
• Ensure that the users can create reports containing Al visuals.
• Provide autoscaling of the CPU resources during heavy usage spikes.
You need to recommend a Power Bl solution for the customer. The solution must minimize costs.
What should you recommend?
- A . Power Bl Premium per user
- B . a Power Bl Premium per capacity
- C . Power Bl Pro per user
- D . Power Bl Report Server
What should you configure in the deployment pipeline?
- A . a backward deployment
- B . a selective deployment
- C . auto-binding
- D . a data source rule
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’)
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.
Topic 4, Misc. Questions
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.
You have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains a dataset.
During a scheduled refresh, you receive the following error message: "Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB."
You need to ensure that you can refresh the dataset.
What should you do?
- A . Turn on Large dataset storage format.
- B . Connect Workspace1 to an Azure Data Lake Storage Gen2 account
- C . Change License mode to Premium per user.
- D . Change the location of the Premium capacity.