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 need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/dax/endofquarter-function-dax

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft Exert spreadsheet named Excel1 that contains survey results.
You have a Power Bl dashboard named DashboardA that has Q&A enabled.
You need to ensure that users who can access DashboardA can ask Questions based on the contents of Excel 1 and pm visuals based on their queries to DashboardA. The solution must minimize development time.
Which three 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:

Explanation:

Comment: *

Name: *

Email: *

Verification: *

You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.

You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.
Which three 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:

Explanation:

Step 1: Select Use Header as First Row.
Step 2: Select Department and Product and Unpivot Other Columns
Unpivot Other Columns: This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted.
Step 3: Rename the Attribute column to Year and the Value column to Revenue.
You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.

When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the new columns and re-orient them into flattened columns:
Values (in blue on the left) are unpivoted into a new column (in blue on the right).
Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column.
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95- f588221c7098

Comment: *

Name: *

Email: *

Verification: *

You plan to use Power Query Editor to get data from an API.
The API returns a JSON response.
You have a username and password tor the AP I.
Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *