- (Exam Topic 4)
You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?

1. A. In the report, add a DAX calculated column that calculates the length of col1
2. B. In the report, add a DAX function that calculates the average length of col1
3. C. From Power Query Editor, add a column that calculates the length of col1
4. D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

Correct Answer: D
From Power Query.. highlight the column.. from the tab view select Column Profile Option.. in the Value distribution section that appears below, from the 3dots.. you can change to group by text length distribution

- (Exam Topic 4)
You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter. How should you complete the measure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:
Graphical user interface, text, application Description automatically generated
Box 1: CALCULATE
Box 2: DATEADD
Box 3: DIVIDE
Example: NET_SALES QoQ% = IF(
ISFILTERED('Calendar'[Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
VAR PREV_QUARTER =
CALCULATE(
SUM('research ra_qtr_template'[NET_SALES]), DATEADD('Calendar'[Date].[Date], -1, QUARTER)
) RETURN DIVIDE(
SUM('research ra_qtr_template'[NET_SALES]) - PREV_QUARTER,
PREV_QUARTER
)
)
Reference:
https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
Customer ID
Customer Name
Phone
Email Address
Address ID
Address contains the following columns:
Address ID
Address Line 1
Address Line 2
City
State/Region
Country
Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?

1. A. Merge the Customer and Address tables.
2. B. Transpose the Customer and Address tables.
3. C. Group the Customer and Address tables by the Address ID column.
4. D. Append the Customer and Address tables.

Correct Answer: A
There are two primary ways of combining queries: merging and appending.
When you have one or more columns that you’d like to add to another query, you merge the queries.
When you have additional rows of data that you’d like to add to an existing query, you append the query.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

- (Exam Topic 4)
You use Power Bi Desktop to create a Power Bl data model and a blank report You need to add the Word Cloud visual shown in the following exhibit to the report.

The solution must minimize development effort
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.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
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 several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group.
Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A
Statements and questions are tricky and confusing. When the access is granted for the group (all users) for ALL (each) dashboards and ALL (each) reports in the workspace, then the will have read access to the specific (A, one) Dashboard and several reports, because they are part of all dashboards and reports. There is no statement, that for the other dashboards (except the one) and the other reports (except the several) that access must be prevented. They are also accessible (maybe it is not desired but not stated here).