Microsoft Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI - DP-500 Exam Questions

QUESTION NO: 1
You have a Power Bl tenant that is linked to an Azure AD tenant. The tenant contains a group named Group1.
You create a paginated report that does NOT use row-level security (RLS).
You need to send a copy of the report to Group1 every Monday at 9 AM UTC Which two actions should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

QUESTION NO: 2
You are using DAX Studio to analyze a slow-running report query. You need to identify inefficient join operations in the query. What should you review?

QUESTION NO: 3
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?

QUESTION NO: 4
What should you configure in the deployment pipeline?

QUESTION NO: 5
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.

QUESTION NO: 6
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.

QUESTION NO: 7
Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

QUESTION NO: 8
You need to create Power BI 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.

QUESTION NO: 9
You have five Power Bl reports that contain R script data sources and R visuals.
You need to publish the reports to the Power Bl service and configure a daily refresh of datasets.
What should you include in the solution?

QUESTION NO: 10
You have a shared dataset in Power Bl named Dataset1.
You have an on-premises Microsoft SQL Server database named DB1.
You need to ensure that Dataset1 refreshes data from DB1.
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.

QUESTION NO: 11
You need to recommend a security solution for the Power Bl tenant to control external data sharing. The solution must meet the technical requirements.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION NO: 12
You have a Power BI Premium capacity.
You need to increase the number of virtual cores associated to the capacity.
Which role do you need?

QUESTION NO: 13
You have a Power BI report and dataset in Power BI Desktop. The dataset contains a calculation group named CG1 that contains four calculation items. The Current calculation item is shown in the following exhibit.