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 that each 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?

• A.Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
• B.Publish the reports to a different workspace other than the one hosting the datasets.
• C.Publish the reports in an app and grant the HR managers access permission.
• D.Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Comment: *

Name: *

Email: *

Verification: *

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

• A.Remove the QuantityPerUnit column from the Products table
• B.Filter out discontinued products while importing the Product table.
• C.Change lite OrderlD column in the Orders table to the text data type.
• D.Group the Categories table by the CategorylD column.

Comment: *

Name: *

Email: *

Verification: *

You import a large dataset to Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point

• A.Show whitespace
• B.Column quality
• C.Column distribution
• D.Monospaced
• E.Column profile

Comment: *

Name: *

Email: *

Verification: *

Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?

• A.Create a new aggregation that summarizes by state.
• B.Create a new aggregation that summarizes by employee.
• C.Create a new group on the state column and set the Group type to Bin.
• D.Create a new group on the state column and set the Group type to List.

Comment: *

Name: *

Email: *

Verification: *

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.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *