Question 1

You have a Power Bl semantic model named Model! that contains two fields named Sales and Quarter. Model 1 contains a DAX measure that sums the Sales column. You need to create a report that will contain the visual shown in the following exhibit.

The solution must NOT require additional DAX measures. Which type of visual should you use?

Options :

A : ribbon chart

B : line chart

C : 100% stacked area chart

D : area chart

Answer: C

Question 2

Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add?

Options :

A : video

B : custom streaming data

C : text box

D : web content

Answer: D

Question 3

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.

Options :

A : In the Sales table, you can write a DAX expression that uses the RELATED() function to get data from the CityData table.

B : A DAX expression of sales total CALCULATE (SUM(Sales [Sales]), ALL(Sales)) will produce the correct total sales value for each state, based on the data model.

C : A table visualization that uses cityData[state] and Sales [Sales] will contain sales from the state of TX

Answer: A,B

Question 4

The Sales table contains records of sales by day from the last five years up until today's date.

You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.

Which DAX expression should you use?

Options :

A :