You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.
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:

Explanation

Box 1: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.
https://pediaa.com/what-is-the-difference-between-unique-and-distinct-in-sql/#:~:text=Unique%20and%20Distin

Comment: *

Name: *

Email: *

Verification: *

You have the visual shown in the exhibit. (Click the Exhibit tab.)

You need to show the relationship between Total Cost and Total Sales over time.
What should you do?

• A.Add a slicer for the year.
• B.Add a play axis.
• C.From the Analytics pane, add an Average line.
• D.Create a DAX measure that calculates year-over-year growth.

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: *

You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://www.nickyvv.com/2019/08/the-new-power-bi-workspace-viewer-role-explained.html

Comment: *

Name: *

Email: *

Verification: *

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Configure the dataset to use the existing On-premises data gateway.
• B.Deploy an On-premises data gateway in personal mode.
• C.Set the refresh frequency to Daily.
• D.Configure the dataset to use the personal gateway.

Comment: *

Name: *

Email: *

Verification: *