PL-300 · Question #169
You are configuring a Microsoft Power BI 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 =…
The correct answer is A. Add a synonym of "subscriber count" to the Customer Count measure. Power BI's Q&A feature uses synonyms to map alternative terms to existing fields and measures. Adding a synonym 'subscriber count' directly to the 'Customer Count' measure tells the Q&A engine that these phrases are equivalent, so natural language queries using 'subscriber…
Question
You are configuring a Microsoft Power BI 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?
Options
- AAdd a synonym of "subscriber count" to the Customer Count measure.
- BAdd a calculated table named Subscriber that is a duplicate of the Customer table.
- CAdd a description of "subscriber count" to the Customer Count measure.
- DAdd a synonym of "subscriberlD" to the CustomerlD column.
How the community answered
(37 responses)- A81% (30)
- B3% (1)
- C5% (2)
- D11% (4)
Explanation
Power BI's Q&A feature uses synonyms to map alternative terms to existing fields and measures. Adding a synonym 'subscriber count' directly to the 'Customer Count' measure tells the Q&A engine that these phrases are equivalent, so natural language queries using 'subscriber count' will resolve to the correct measure. This is the most efficient solution because it adds metadata only - no additional data is stored. Option B (duplicate table) unnecessarily increases model size, violating the 'minimize the size of the model' constraint. Option C (description) is informational metadata only and is not used by Q&A for matching. Option D (adding a synonym to the CustomerID column) targets the wrong object and would not help users asking about counts.
Topics
Community Discussion
No community discussion yet for this question.