You need to create a relationship between the Weekly_Returnstable and the Date table to meet the
reporting requirements of the regional managers. What should you do?
A.
In the Weekly.Returns table, create a new calculated column named date-id in a format of
yyyymmdd and use the calculated column to create a relationship to the Date table.
B.
Add the Weekly_Returns data to the Salestable by using related DAX functions.
C.
Create a new table based on the Date table where date-id is unique, and then create a many-tomany relationship to Weekly_Return.
Correct Answer: A
Explanation:
Scenario: Region managersrequire a visual to analyze weekly sales and returns.
Question #2 (Topic: demo questions)
Whatshould 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])
Correct Answer: C
Explanation:
The sale department requires reports that contain the number ofsalestransactions.
The COUNTROWS function counts the number of rows in the specified table, or in a table defined by
an expression.
Question #3 (Topic: demo questions)
You need to create a relationship between the Weekly_Returnstable and the Date table to meet the
reporting requirements of the regional managers. What should you do?
A.
In the Weekly.Returns table, create a new calculated column named date-id in a format of
yyyymmdd and use the calculated column to create a relationship to the Date table.
B.
Add the Weekly_Returns data to the Salestable by using related DAX functions.
C.
Create a new table based on the Date table where date-id is unique, and then create a many-tomany relationship to Weekly_Return.
D.
Change the data type ofsales [region_id] to Decimal Number.
Correct Answer: A
Explanation:
Scenario: Region managersrequire a visual to analyze weekly sales and returns.
Question #4 (Topic: demo questions)
You need to address the data concerns before creating the data model. Whatshould 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.
Correct Answer: C
Explanation not available for this question.
Question #5 (Topic: demo questions)
You need to create a calculated column to display the month based on the reporting requirements.
Which DAX expression should you use?