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?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value 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.

Correct Answer:

Explanation:
Box 1: CALCULATE
CALCULATE rvaluates an expression in a modified filter context.
Box 2: DIVIDE
As a data modeler, when you write a DAX expression to divide a numerator by a denominator, you can choose to use the DIVIDE function or the divide operator (/ - forward slash).
When using the DIVIDE function, you must pass in numerator and denominator expressions.
Box 3: ALLSELECTED
ALLSELECTED removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.
The ALLSELECTED function gets the context that represents all rows and columns in the query, while keeping explicit filters and contexts other than row and column filters. This function can be used to obtain visual totals in queries.
Example:
measure 'Reseller Sales'[Reseller Visual Total]=calculate(sum('Reseller Sales'[Sales Amount]), ALLSELECTED()) Reference:
https://docs.microsoft.com/en-us/dax/allselected-function-dax

Comment: *

Name: *

Email: *

Verification: *

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
* First name
* Last name
* Email address
* State/Region
* Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Open the Advanced Editor.
• B.Select Column quality.
• C.Enable Column profiling based on entire dataset.
• D.Select Column distribution.
• E.Select Column profile.

Correct Answer: D,E

Data Profiling, Quality & Distribution in Power BI / Power Query features To enable these features, you need to go to the View tab Data Preview Group Check the following:
* Column quality
* Column profile
* Column distribution

* Column profile
Turn on the Column Profiling feature.


Can use it to visually realize that your query is missing some data because of distinct and uniqueness counts.

Reference:
https://www.poweredsolutions.co/2019/08/13/data-profiling-quality-distribution-in-power-bi-power-query/
https://www.altentertraining.com/microsoft/power-bi/column-profiling-is-good/

Comment: *

Name: *

Email: *

Verification: *

You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)

What should you do?

• A.Edit the details of each tile.
• B.Change the report theme.
• C.Change the dashboard theme.
• D.Create a custom CSS file.

Comment: *

Name: *

Email: *

Verification: *