You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?

• A.one-to-many from Customer to Transaction
• B.one-to-one between Customer and Transaction
• C.one-to-many from Transaction to Customer
• D.many-to-many between Customer and Transaction

Comment: *

Name: *

Email: *

Verification: *

You have a Power Bi report for the procurement department. The report contains data from the following tables.

There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns.
The report contains the visuals shown in the following table.

You need to minimize the size of the dataset without affecting the visuals. What should you do?

• A.Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).
• B.Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month
• C.Remove the Lineitems[Description] column.
• D.Merge Suppliers and Uneltems.

Comment: *

Name: *

Email: *

Verification: *

You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

• A.1318
• B.1319
• C.21318 Lasalle Street
• D.21319 Lasalle Street

Correct Answer: D

Example:
Replace the text "ur" with the text "or" in the table.

Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue

Comment: *

Name: *

Email: *

Verification: *

Drag and Drop Question
You have a Power BI semantic model.
You need to configure row-level security (RLS) to restrict data access for users that have the Viewer permissions.
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:

Comment: *

Name: *

Email: *

Verification: *

The table has the following columns.

You need to add a column that will be used to sort the Year Month column chronologically.

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

Correct Answer: A,D

Answer as.

You publish a dataset lhat contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
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


You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables.
The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?

Comment: *

Name: *

Email: *

Verification: *