Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Monthly_returns table and Date[Date_ID].
What should you do before you create the relationship?

• A.In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
• B.In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
• C.To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
• D.To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.

Comment: *

Name: *

Email: *

Verification: *

You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.

Which type of visual should you use?

• A.Q&A
• B.decomposition tree
• C.smart narrative
• D.key influencers

Comment: *

Name: *

Email: *

Verification: *

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?

• A.Dataverse
• B.Microsoft Teams Personal Analytics
• C.Dataflows
• D.SQL Server database

Comment: *

Name: *

Email: *

Verification: *

You have a report page that contains the visuals shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions

Comment: *

Name: *

Email: *

Verification: *

You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

You need to prepare the data to support the following:
Visualizations that include all measures in the data over time
Year-over-year calculations for all the measures
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.

Correct Answer:

1 - Use first row as header
2 - Unpivot all columns other than "Measure"
3 - Rename "Attribute" to "Year"
4 - Change data type of "Year" to date (Date > Year)

Comment: *

Name: *

Email: *

Verification: *