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

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment. How should the visual interactions be set on the column chart when the bar chart is selected?