You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.

You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.
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.

Correct Answer:

1 - Select Use First Row as Headers.
2 - Select Department and Product and Unpivot Other Columns.
3 - Rename the Attrubute column to Year...
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

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

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 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 81 Desktop and the Power BI service.
Which expression should you use?

• A.Option D
• B.Option A
• C.Option C
• D.Option B

Comment: *

Name: *

Email: *

Verification: *

You have a Power B1 model that contains a table named Date. The table has the following columns.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Group the impressions by Ad_id, Site_name, and Impression_date.
  Aggregate by using the CountRows function.
• B.Create one-to-many relationships between the tables.
• C.Create a calculated measure that aggregates by using the COUNTROWS function.
• D.Create a calculated table that contains Ad_id, Site_name, and Impression_date.

Comment: *

Name: *

Email: *

Verification: *