You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

• A.Change the data type of Sales[region_id] to Whole Number.
• B.In the Sales table, add a measure for sum(sales_amount).
• C.Change the data type of sales[sales_id] to Text.
• D.Change the data type of sales [region_id] to Decimal Number.

Correct Answer: A

Explanation
Scenario: Executives require a visual that shows sales by region.
Need to change the sales_id column from Varchar to Whole Number (Integer).
Topic 1, Litware, Inc. Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.
The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
- Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
* Executives require a visual that shows sales by region.
* Regional managers require a visual to analyze weekly sales and returns.
* Sales managers must be able to see the sales data of their respective region only.
* The sales managers require a visual to analyze sales performance versus sales targets.
* The sale department requires reports that contain the number of sales transactions.
* Users must be able to see the month in reports as shown in the following example: Feb 2020.
* The customer service department requires a visual that can be filtered by both sales month and ship month independently.

Comment: *

Name: *

Email: *

Verification: *

You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

• A.Create a horizontal line that has a fixed value of 24,000.
• B.Add a measure to the visual that uses the following DAX expression.
  Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],0.40)
• C.Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
• D.Add a measure to the visual that uses the following DAX expression.
  Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Correct Answer: C

Explanation
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart


Add percentile lines to monitor daily revenue

Comment: *

Name: *

Email: *

Verification: *

You need to create a visual as shown in the following exhibit.

The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

Comment: *

Name: *

Email: *

Verification: *

Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
- Executives require a visual that shows sales by region.
- Regional managers require a visual to analyze weekly sales and
returns.
- Sales managers must be able to see the sales data of their respective region only.
- The sales managers require a visual to analyze sales performance
versus sales targets.
- The sale department requires reports that contain the number of sales transactions.
- Users must be able to see the month in reports as shown in the
following example: Feb 2020.
- The customer service department requires a visual that can be
filtered by both sales month and ship month independently.
You need to create the required relationship for the executive's visual.
What should you do before you can create the relationship?

• A.In the Sales table, add a measure for sum(sales_amount).
• B.Change the data type of sales[sales_id] to Text.
• C.Change the data type of Sales[region_id] to Whole Number.
• D.Change the data type of sales [region_id] to Decimal Number.

Comment: *

Name: *

Email: *

Verification: *

Drag and Drop Question
You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide.
You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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: *