Question 81
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.

What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 82
You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.

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

Question 83
You have a Power Bl workspace that contains several reports.
You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.
What should you do?
You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.
What should you do?
Question 84
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.


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.

Question 85
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

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

You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

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





