You have a report page that contains the visuals 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.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Use the Test as role option to view data as the salesperson's user account.
• B.Use the Test as role option to view data as the Sales role.
• C.Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
• D.Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

Correct Answer: B

Validate the roles within Power BI Desktop
After you've created your roles, test the results of the roles within Power BI Desktop. From the Modeling tab, select View as.

Select a role you created, and then select OK to apply that role. The report renders the data relevant for that role.

Select OK. The report renders based on what that user can see.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Comment: *

Name: *

Email: *

Verification: *

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
• B.a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.
• C.a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.
• D.a pie chart that shows balances by account category without filters.
• E.a ribbon chart that shows balances by quarter and accounts in the legend.

Comment: *

Name: *

Email: *

Verification: *

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

• A.Transform the sales_amount column to replace negative values with 0.
• B.Select Column distribution.
• C.Select the sales_amount column and apply a number filter.
• D.Select Column profile, and then select the sales_amount column.

Comment: *

Name: *

Email: *

Verification: *

You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *