Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? 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 - From powerbi.com, add role members to the roles.
2 - From Power Bl Desktop, add a Table Filter DAX Expression to the roles.
3 - From Power Bl Desktop, create four roles.
Explanation:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Comment: *

Name: *

Email: *

Verification: *

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl.
You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access and prevent end users from viewing the development assets.
What should you recommend?

• A.In the same workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.
• B.Create one workspace for development. From the workspace, publish an app for production.
• C.Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
• D.Create separate workspaces for development and production. Grant the end users access to the production workspace.

Comment: *

Name: *

Email: *

Verification: *

You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
CustomerID
Customer City
Customer State
Customer Name
Customer Address 1
Customer Address 2
Customer Postal Code
The Invoice table contains the following fields:
Order ID
Invoice ID
Invoice Date
Customer ID
Total Amount
Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
The number of customers invoiced in each state last month
The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
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://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

Comment: *

Name: *

Email: *

Verification: *

You need to create a relationship in the dataset for RLS.
What should you do? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
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:

Explanation
1) Duplicate Customer query
2) Group by CustId by Max ModifiedDate (only 2 columns to keep)
3) Merge two queries on CustId and ModifiedDate inner join (to retreive other customer informations related to latest Date)

Comment: *

Name: *

Email: *

Verification: *