QUESTION 74
You have the visual shown in the exhibit. (Click the Exhibit tab.)

You need to show the relationship between Total Cost and Total Sales over time.
What should you do?

QUESTION 75
You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?

QUESTION 76
HOTSPOT
You are creating a Microsoft Power BI data model that has the tables shown in the following table.

The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

QUESTION 77
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

QUESTION 78
In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset.
You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data.
What should you do?

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

QUESTION 80
HOTSPOT
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.

QUESTION 81
HOTSPOT
You have the Power BI data model shown in the following exhibit.

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 82
HOTSPOT
You are creating a quick measure as shown in the following exhibit.

You need to create a monthly rolling average measure for Sales over time.
How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

QUESTION 83
HOTSPOT
You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

QUESTION 84
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?

QUESTION 85
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?

QUESTION 86
HOTSPOT
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.

QUESTION 87
HOTSPOT
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

QUESTION 88
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

QUESTION 89
DRAG DROP
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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.

QUESTION 90
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a constant line and set the value to .5.
Does this meet the goal?

QUESTION 91
You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?

QUESTION 92
You have a Microsoft Power Bl dashboard.
You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.
What should you use?

QUESTION 93
You have the visual shown in the Original exhibit. {Click the Original tab.)

You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

What should you add to the visual?

QUESTION 94
HOTSPOT
You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

QUESTION 95
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.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?

QUESTION 96
You need to design the data model to meet the report requirements .
What should you do m Power Bl Desktop?