You need to design the data model to meet the report requirements.
What should you do in Power BI Desktop?

• A.From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.
• B.From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
• C.From Power Bl Desktop, use the Auto date/time option when creating the reports.
• D.From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

Comment: *

Name: *

Email: *

Verification: *

You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit.

You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model.
What should you do?

• A.Rename the query from Carriers to airlines.
• B.Add airline as a synonym of carrier.
• C.Add a duplicate query named Airline.
• D.Rename the carrier column as airline in the Carriers query.

Comment: *

Name: *

Email: *

Verification: *

You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.Column profile
• B.Column distribution
• C.Show whitespace
• D.Column quality
• E.Monospace

Comment: *

Name: *

Email: *

Verification: *

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a constant line and set the value to .5.
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?

• A.Split the model into multiple models.
• B.Hide unused columns in the model.
• C.Merge tables by using Power Query.
• D.Transpose.

Comment: *

Name: *

Email: *

Verification: *