Exact2Pass
The group registers the Power Bl tenant as a data source1.
You need to ensure that all the analysts can view the assets in the Power Bl tenant The solution must meet the technical requirements for Microsoft Purview and Power BI.
What should you do?
You need to ensure that the new process for deploying reports and datasets to the User Experience workspace meets the technical requirements.
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.
The enterprise analytics team needs to resolve the DAX measure performance issues.
What should the team do first?
The enterprise analytics team needs to notify the report owners of the planned changes. The solution must minimize administrative effort.
What should the team do?
The enterprise analytics team needs to create a view for the survey response data. The solution must meet the technical requirements.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to recommend a solution for the analysts in the Finance and Accounting business unit to mitigate the increase in maintenance of their assets in the Power Bl tenant.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to recommend changes to the Power Bl tenant to meet the technical requirements for external data sharing. Which tenant setting should you recommend disabling?
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.
You need to optimize the workflow for the creation of reports and the adjustment of tables by the enterprise analytics team.
What should you do?
You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the following requirements:
• Code must always be merged to the main branch before being published, and the main branch must be used for publishing resource
• The workspace templates must be stored in the publish branch.
• A branch named dev123 will be created to support the development of a new feature.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
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?
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?
You need to save Power Bl dataflows in an Azure Storage account.
Which two prerequisites are required to support the configuration? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
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.
You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in the following table.
Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each pool type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You are creating a Power B1 single-page report.
Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.
You need to ensure that the users can consume content on a report page in a logical order.
What should you configure on the report page?
You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode.
A database administrator reports a drastic increase in the number of queries sent from the Power BI service to an Azure SQL database since the creation of the deployment pipeline.
An investigation into the issue identifies the following:
You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production.
What should you recommend?
You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips.
You need to create a chart that will show the total trip distance according to the number of passengers as shown in the following exhibit.
How should you configure the chart? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
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 Premium capacity.
From the Power Bl Premium Capacity Metrics app, you discover the following:
• There is insufficient CPU to execute dataset refreshes.
• Out-of-memory throttling occurs when the dataset is waiting.
You need to recommend a solution to resolve the performance issues.
Solution: You move the datasets to a larger capacity.
Does this meet the goal?
You have a Power Bl report that contains a card. The card displays the value for year-to-date revenue.
You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed.
What should you do?
You have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset.
You need to recommend an Azure Synapse Analytics pool for the data scientists. The solution must minimize costs.
Which type of pool should you recommend?
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.
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.
You need to create the customized Power Bl usage reporting. The Usage Metrics Report dataset has already been created. The solution must minimize development and administrative effort.
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 need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements.
What should you do?
