1Z0-184-25 Question 163
Single answerYou have enabled Select AI in your Autonomous Database to allow business users to query data with natural language prompts. However, users are getting incomplete results when asking for 'sales by region' because the relevant column in the SALES table is named 'Preferred_Territory.' Which action should you take so that queries referring to 'region' correctly match the 'Preferred_Territory' column in your natural language prompts?
- A
Create a custom AI synonym mapping so that references to �region� match the �Preferred_Territory� column.
- B
Rename the �Preferred_Territory� column to �Region� within the table structure to match the user� query.
- C
Instruct users to specify the exact column name �Preferred_Territory� instead of using �region� in their prompts.
- D
Use a database parameter to auto-map any user reference to �region� to �Preferred_Territory� by default.
Show answer and explanation
Correct answer: A
Explanation
Select AI in Autonomous Database allows users to issue plain-English queries. To map user terms (e.g., 'region') to existing schema column names (like 'Preferred_Territory'), you must configure AI synonyms. This ensures that the machine learning engine properly interprets and translates natural language references to the correct columns. For detailed configuration steps, consult the Oracle Autonomous Database documentation on customizing AI synonyms.
- A. Correct.
Correct. By creating a custom AI synonym mapping, you ensure that when users type 'region,' the AI engine maps this to the 'Preferred_Territory' column. This feature allows natural language queries to work properly without renaming columns in the underlying schema.
- B. Incorrect.
Incorrect. Renaming the column would break existing references and might require changes in dependent applications or queries that already refer to �Preferred_Territory.� It's generally better to use synonyms or other mapping features to keep the existing structure intact.
- C. Incorrect.
Incorrect. The goal is to enable natural language queries without forcing users to learn specific column names. The feature of Select AI is designed to interpret common terms like �region.�
- D. Incorrect.
Incorrect. There is no simple database parameter that automatically maps any user reference to a corresponding column name. Synonym mapping is required to ensure the AI engine properly interprets user statements.