259 Teil 5: Power BI Service and secruity

1. A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements:

✑ Minimize online processing operations.

✑ Minimize calculation times and render times for visuals.

✑ Include data from the current year, up to and including the previous day.

What should you do?

1. DRAG DROP You publish a dataset that contains data from an on-premises Microsoft SQL Server database. The dataset must be refreshed daily. You need to ensure that the Power BI service can connect to the database and refresh the dataset. CertyIQ 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

1. You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions. Each sales region has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

35.

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?

You have the Power BI model shown in the following exhibit

A manager can represent only a single country. You need to use row-level security (RLS) to meet the following requirements:

✑ The managers must only see the data of their respective country.

✑ The number of RLS roles must be minimized.

Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

DRAG DROP You plan to create a report that will display sales data from the last year for multiple regions. You need to restrict access to individual rows of the data on a per region-basis by using roles. 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. Select and Place

1. You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = "Kentucky" Role2 contains the following filter. Date[Calendar Year] = 2020 If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

54.You have the Power BI model shown in the following exhibit

There are four departments in the Departments table. You need to ensure that users can see the data of their respective department only. What should you do?

A. Create a slicer that filters Departments based on DepartmentID. B. Create a row-level security (RLS) role for each department, and then define the membership of the role. C. Create a DepartmentID parameter to filter the Departments table. D. To the ConfidentialData table, add a calculated measure that uses the CURRENTGROUP DAX function

1. You have a Power BI data model that contains a table named Employees. The table has the following columns:

•Employee Name

•Email Address

•Start Date

•Job Title You are implementing dynamic row-level security (RLS).

You need to create a table filter to meet the following requirements:

•Users must see only their own employee data.

•The DAX expression must work in both Power BI Desktop and the Power BI service.

Which expression should you use?

1. DRAG DROP You have the Power BI data model shown in the following exhibit

The Country table contains the following data

You create two row-level security (RLS) roles named Manager and CFO. You plan to publish the dataset to the Power BI service. You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

•Each manager must see only the data in the Sales and Human Resources tables for their own country.

•The CFO must be prevented from seeing the data in the Human Resources table.

•The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression 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.

1. You have a Power BI data model that contains a table named Employees. The table has the following columns:

•Employee Name

•Email Address

•Start Date

•Job Title

You are implementing dynamic row-level security (RLS). You need to create a table filter to meet the following requirements:

•Users must see only their own employee data.

•The DAX expression must work in both Power BI Desktop and the Power BI service.

Which expression should you use?

1. A user creates a Power BI report named ReportA that uses a custom theme. You create a dashboard named DashboardA. You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. DRAG DROP You have a Power BI dashboard named DashboardA that contains a tile named TileA. TileA contains a treemap visual from a report named ReportA. You need to provide the users of DashboardA with additional tiles that relate to the contents of TileA. 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. Select and Place:

1. You are creating a dashboard by using the Power BI service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do?

1. DRAG DROP You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. 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. Select and Place:

1. DRAG DROP You have a Microsoft Excel spreadsheet named Excel1 that contains survey results. You have a Power BI dashboard named DashboardA that has Q&A enabled. You need to ensure that users who can access DashboardA can ask questions based on the contents of Excel1 and pin visuals based on their queries to DashboardA. The solution must minimize development time. 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. Select and Place:

1. You have two Power BI reports named ReportA and ReportB that each uses a distinct color palette. You are creating a Power BI dashboard that will include two visuals from each report. You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

152.. You have a Microsoft Power BI dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.

What occurred at 12:03:06 PM?

1. HOTSPOT You have the Power BI dashboard shown in the Dashboard exhibit. (Click the Dashboard tab.)

You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit. (Click the Mobile tab.)

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

1. You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)

What should you do?

1. You maintain a Power BI workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals. The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

You need to modify the dashboard mobile layout to meet the following requirements:

✑ Only show single-value visuals.

✑ Minimize scrolling.

What should you do?

1. You have a Power BI workspace named Inventory that contains a dataset, a report, and a dashboard. You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. You build a Power BI report that displays IoT temperature data streaming from a refrigerator. You publish the report to the Power BI service. You need to be notified when the temperature rises above four degrees Celsius. What should you do?

1. You have the dashboard shown in the following exhibit

You need to modify the dashboard to display as shown in the following exhibit

What should you do?

1. You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do?

1. You plan to use Power BI to create sales invoices for customers. The solution must meet the following requirements:

•Sales invoices must be exported in a PDF format.

•The PDF exports must show all columns and rows clearly.

What should you create?

1. You have a Power BI report named Report1 and a dashboard named Dashboard1. Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the bar chart displays on Dashboard1. What should you do? A.Refresh the dataset used by Report1 and Dashboard1. B.Pin the Sales by month bar chart to Dashboard1. C.Select Refresh visuals for Dashboard1. D.Edit the details for the dashboard tile of Dashboard1

1. You have a Power BI report named ReportA. You have a Power BI tenant that allows users to export data. You need to ensure that consumers of ReportA cannot export any data from visuals. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

1. You have a Power BI dataset named Finance that is hosted in a Power BI workspace. The finance team at your company is NOT currently a member of any Power BI workspace roles. You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset. What should you do?

1. HOTSPOT You have a Power BI tenant that hosts the datasets shown in the following table

You have the following requirements: The export of reports that contain Personally Identifiable Information (PII) must be prevented. Data used for financial decisions must be reviewed and approved before use. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area

1. You have a Power BI tenant. You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted. What should you implement?

1. You have a Power BI workspace that contains a dataset, a report, and a dashboard. The following groups have access:

✑ External users can access the dashboard.

✑ Managers can access the dashboard and a manager-specific report.

✑ Employees can access the dashboard and a row-level security (RLS) constrained report.

You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised. What should you use?

1. You have a Power BI workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do?

205 DRAG DROP You have a Power BI workspace that contains a single-page report named Sales. You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard. 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. Select and Place:

1. You have a report in Power BI named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report. The solution must prevent other reports from being affected. What should you do?

1. In Power BI Desktop, you are creating visualizations in a report based on an imported dataset. You need to allow Power BI users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data. What should you do?

1. You have a Power BI report that uses row-level security (RLS). You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets, or dashboards. What should you do?

1. You have four sales regions. Each region has multiple sales managers. You implement row-level security (RLS) in a data model. You assign the relevant mail-enabled security group to each role. You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.

1. You have more than 100 published datasets. Ten of the datasets were verified to meet your corporate quality standards. You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets. What should you do?

1. DRAG DROP You have a Microsoft Power BI workspace. You need to grant the user capabilities shown in the following table

The solution must use the principle of least privilege. Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar. NOTE: Each correct selection is worth one point. Select and Place:

1. You create a dashboard by using the Microsoft Power BI Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the Viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?

1. You have a Power BI workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1. A user wants to create a report by using the data in DS1 and publish the report to another workspace. You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user. What should you do?

1. 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 five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports. Solution: You publish an app to the entire organization. Does this meet the goal?

1. 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 five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports. Solution: You enable included in app for all assets. Does this meet the goal?

1. 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 five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports. Solution: You assign all the users the Viewer role to the workspace. Does this meet the goal?

1. From Power BI Desktop, you publish a new dataset and report to a Power BI workspace. The dataset has a row level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?

1. You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:

✑ A line chart that shows the number of defective products manufactured by day

✑ A KPI visual that shows the current daily percentage of defective products manufactured

You need to be notified when the daily percentage of defective products manufactured exceeds 3%. What should you create?

1. You have five sales regions. Each region is assigned a single salesperson. You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson. Salespeople must see only the data from their region. You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople. A salesperson reports that she believes she should see more data. You need to verify what data the salesperson currently sees. What should you do?

1. You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design. What should you use?

1. HOTSPOT You have a dataset that has the permissions shown in the following exhibit.

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

1. 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 five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports. Solution: You create an Azure Active Directory group that contains all the users. You share each selected report and the one dashboard to the group. Does this meet the goal

1. You have a Power BI dataset and a connected report. You need to ensure that users can analyze data in Microsoft Excel only by connecting directly to the dataset. You grant the users the Build permission for the dataset. What should you do next?

1. HOTSPOT CertyIQ You have two Power BI workspaces named WorkspaceA and WorkspaceB. WorkspaceA contains two datasets named Sales and HR. You need to provide a user named User1 with access to the WorkspaceB. The solution must meet the following requirements:

• Create reports that use the HR dataset.

• Publish the reports to WorkspaceB.

• Prevent the ability to modify the HR dataset.

• Prevent the ability to add users to Workspaces.

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point

1. You have a Power BI workspace named BI Data that contains a dataset named BI Finance. CertyIQ You have the Build permission for the BI Finance dataset, but you do NOT have permissions for the workspace. You need to connect to BI Finance and create a report. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.