You need to address the data concerns before creating the data model .
What should you do in Power Query Editor?
A . Select Column distribution.
B . Select the sales_amount column and apply a number filter.
C . Select Column profile, and then select the sales_amount column.
D . Transform the sales_amount column to replace negative values with 0.
Answer: C
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four 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.
Answer: 
Explanation:
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
Answer: A
Explanation:
The WHERE clause has its effects before the data is imported.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You modify the source step of the queries to use DataSourceExcel as the file path.
Does this meet the goal?
A . Yes
B . No
Answer: A
Explanation:
Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.
Reference: https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
What should you create to meet the reporting requirements of the sales department?
A . a measure that uses a formula of SUM (Sales [sales_id])
B . a calculated column that use a formula of COUNTA(sales [sales_id])
C . a measure that uses a formula of COUNTROWS (Sales)
D . a calculated column that uses a formula of SUM (Sales [sales_id])
Answer: C
Explanation:
The sale department requires reports that contain the number of sales transactions.
The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.
Reference: https://docs.microsoft.com/en-us/dax/countrows-function-dax
You have a query that returns the data shown in the following exhibit.
You need to configure the query to display the data as shown in the following exhibit.
Which step should you use in the query?
A . =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes". Splitter.SplitTextByDelimiter(”,”, QuoteStyle.None), let itemType – (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")
B . = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
C . = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None), {"classes.1"})
D . = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
Answer: B
Explanation:
Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.
Chart
Description automatically generated
Note:
Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table
Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.
Reference:
https://docs.microsoft.com/en-us/power-query/unpivot-column
https://docs.microsoft.com/en-us/powerquery-m/table-unpivot
HOTSPOT
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales.
CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Answer: 
Explanation:
Text
Description automatically generated
Box 1: Yes
The Related function returns a related value from another table.
The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table. If a relationship does not exist, you must create a relationship.
Box 2: Yes
Box 3: No
TX only occurs in the Sales table, but not in the CityData table.
You need to create a calculated column to display the month based on the reporting requirements .
Which DAX expression should you use?
A . FORMAT(‘Date'[date], "MMM YYYY")
B . FORMAT(‘Date’ [date], "M YY")
C . FORMAT(‘Date'[date_id], "MMM") ""& & FORMAT(‘Date'[year], "#")
D . FORMAT(‘Date’ [date_id], "MMM YYYY")
Answer: A
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?
A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
B . an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
C . a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
D . a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many
relationship from Sales[sales_ship_date_id] to Date[date_id]
E . a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]
Answer: A
Explanation:
Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?
A . Create a security role that has a table filter on the Sales_Manager table where username = UserName()
B . Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
C . Create a security role that has a table filter on the Sales_Manager table where name = UserName().
D . Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.
Answer: A
Explanation: https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/