Hotspot Question
You are creating a Microsoft Power BI data model that has the tables shown in the following table.

The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
One-to-many from Product Category to Products, and single direction, as depicted in the snowflake dimensions design.
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

Comment: *

Name: *

Email: *

Verification: *

You have an API that returns more than 100 columns. The following is a sample of column names.
client_notified_timestamp
client_notified_source
client_notified_sourceid
client_notified_value
client_responded_timestamp
client_responded_source
client_responded_sourceid
client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

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.Set Summarize By to None for the CustomerlD column.
• B.Add a description of "Subscriber" to the Customer table.
• C.Add a synonym of "subscriber" to the Customer table.
• D.Add a description of "subscriber count" to the Customer Count measure.

Comment: *

Name: *

Email: *

Verification: *

You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?

• A.comments
• B.tiles
• C.Microsoft Information Protection sensitivity labels
• D.Active Directory groups

Comment: *

Name: *

Email: *

Verification: *

Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.

You need to develop a measure to support the visual.
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:

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

Comment: *

Name: *

Email: *

Verification: *