- (Topic 3)
You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

1. A. Change lite OrderlD column in the Orders table to the text data type.
2. B. Filter out discontinued products while importing the Product table.
3. C. Remove the QuantityPerUnit column from the Products table
4. D. Group the Categories table by the CategorylD column.

Correct Answer: C

DRAG DROP - (Topic 4)
You use Power Query Editor to preview the data shown in the following exhibit

You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative 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

- (Topic 4)
You are building a Power Bl report.
Users will view the report by using their mobile device.
You need to configure the report to display data based on each user s location.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. A. For the relevant columns, set synonyms to match common geographical terms.
2. B. From Power Query Editor, detect the data types of the relevant columns.
3. C. Use the columns of the geography data type in all visuals.
4. D. Create a hierarchy for columns of the geography data type.
5. E. In Data Category, set the geographic data category for the relevant columns.

Correct Answer: CE

- (Topic 4)
You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns:
• Date
• Fiscal year
• Fiscal Quartet
• Month Name
• Calendar Year
• Week Number
• Month Number
• Calendar Quarter
You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?

1. A. DATATABLE
2. B. ADDCOLUMS
3. C. SUMMARIZE
4. D. CALCULATE

Correct Answer: C

HOTSPOT - (Topic 4)
You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables. The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: AD