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.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

• A.A user pressed F5
• B.A new transaction was added to the data source.
• C.A user added a comment to a tile.
• D.The dashboard tile cache refreshed.

Comment: *

Name: *

Email: *

Verification: *

You use Power 81 Desktop to load data from a Microsoft SQL Server database.
While waiting for the data to load, you receive the following error.

You need to resolve the error.
What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

• A.Use Power Query to combine long running queries into one query.
• B.Reduce number of rows and columns returned by each query.
• C.Split long running queries into subsets Of columns and use power Query to the queries
• D.Disable query folding on long running queries

Comment: *

Name: *

Email: *

Verification: *

You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
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 order.

Correct Answer:

1 - Pin items from report to Dashboard.
2 - Open Dashboard.
3 - Change the dashboard view to Phone view.
4 - Rearrange, resize the visuals.

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

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 - From Power BI Desktop, import the date form Excel, and select Table1 and Table2.
2 - From Power Query Editor, append Table2 to Table1.
3 - From Power Query Editor, select Table1, and then select Remove duplicates.

Comment: *

Name: *

Email: *

Verification: *