You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A.
You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A.
The solution must minimize the size of the model.
What should you do?

• A.Add a description of "subscriber count" to the Customer Count measure.
• B.Set Summarize By to None for the CustomerlD column.
• C.Add a description of "Subscriber" to the Customer table.
• D.Add a synonym of "subscriber" to the Customer table.

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:

Comment: *

Name: *

Email: *

Verification: *

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the following format:
2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do?

• A.Change the data type of the Logged column to
• B.Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
• C.Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
  .
• D.Apply a transform to extract the first 11 characters of the Logged column.

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: TOPN
TOPN returns the top N rows of the specified table.
Box 2: SUMMARIZE
SUMMARIZE returns a summary table for the requested totals over a set of groups.
Box 3: DESC
Sort in descending order.
It is last in the TOPN command.
TOPN syntax:
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]...]) Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax

Comment: *

Name: *

Email: *

Verification: *

You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

• A.Create a horizontal line that has a fixed value of 24,000.
• B.Add a measure to the visual that uses the following DAX expression.
  Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],0.40)
• C.Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
• D.Add a measure to the visual that uses the following DAX expression.
  Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Correct Answer: C

Explanation
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart


Add percentile lines to monitor daily revenue

Comment: *

Name: *

Email: *

Verification: *