Analyzing and Visualizing Data with Microsoft Excel — Question 63

You have an Excel workbook that contains two tables named User and Activity.
You plan to publish the workbook to the Power BI service.
Users will use Q&A in the Power BI service to perform natural language queries.
You need to ensure that the users can query the term employee and receive results from the User table.
What should you do before you publish to Power BI?

Answer options

• A. From PowerPivot Settings, modify the Language options
• B. From PowerPivot Settings, modify the Categorization options
• C. From the Power Pivot model, edit the Synonyms
• D. From Workbook Connections, add a connection

Correct answer: C

Explanation

Editing the Synonyms in the Power Pivot model allows you to define alternative terms that users can use in their queries, ensuring that 'employee' correctly maps to the User table. The other options do not directly influence how natural language queries relate to the data tables in Power BI.