You have a Power BI model that has the following tables:
Product (Product_id, Product_Name)
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
Sales to Product
Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold
by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in
the answer area.
NOTE: Each correct selection is worth one point.

ou have a Power Bl report that uses row-level security (RLS).
You need to transfer RLS membership maintenance to an Azure network security team.
The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards.
What should you do?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
From Power Query Editor, you profile the data shown in the following exhibit.

The IoT GUID and IoT ID columns are unique to each row in query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You split the loT DateTime column into a column named Date and a column named Time.
Does this meet the goal?

You have a Power Bl query named Sates that imports the columns shown in the following table.

Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.
You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTL Each correct selection is worth one pant.

You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.
A user wants to create a report by using the data In DS1 and publish the report to another workspace.
You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.
What should you do?

You have a report that contains four pages. Each page contains slicers for the same four
fields. Users report that when they select values on a slicer on one page, the visuals are
not updated on all the pages. You need to recommend a solution to ensure that users can
select a value once to filter the results on all the pages. What are two possible
recommendations to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

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.)

In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.
Every Product has a ProductSubCategory.
Not every ProductsubCategory has a parent ProductCategory.
You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.
How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.