1Z0-184-25 Question 162
Single answerYour retail organization has deployed Oracle Autonomous Database with the Select AI feature enabled. Business analysts are now typing natural language prompts to query sales data. However, when they enter a prompt like: 'Show me the top five products sold last quarter in each region in descending order of revenue,' the system incorrectly interprets 'last quarter' and returns incomplete results. Which action should you take to ensure Select AI accurately recognizes this time-based reference?
- A
Create a user-defined mapping or synonym in Select AI for the phrase 'last quarter' so it translates correctly to the relevant date range in your dataset.
- B
Rebuild the entire table schema with synonyms in the physical column names for better AI comprehension of time expressions.
- C
Grant the SELECT_CATALOG_ROLE to all business analysts so they can query the underlying data dictionary more effectively.
- D
Disable all existing indexes on the sales table to allow the AI model to interpret natural language references without constraints.
Show answer and explanation
Correct answer: A
Explanation
To effectively use Select AI with Autonomous Database for natural language queries, you must ensure that domain-specific or business-specific terminology�such as 'last quarter' or 'Q4'�is defined in the AI� reference. This involves configuring synonyms and mappings that help the system recognize and interpret natural language phrases accurately. Refer to Oracle documentation on customizing domain knowledge within Autonomous Database for guidance on registering synonyms or language patterns for AI-driven queries.
- A. Correct.
Correct. Select AI relies on a language understanding model that can be customized with user-defined synonyms or domain-specific terms. By explicitly defining how 'last quarter' should map to a specific date range (for example, 2025 Q1), you ensure analysts get the desired results.
- B. Incorrect.
Incorrect. Renaming physical columns can cause confusion and does not necessarily improve AI-based natural language interpretation. The correct approach is to add or update the AI� domain knowledge or synonyms, not rename database objects.
- C. Incorrect.
Incorrect. Granting broader database privileges does not improve the AI� ability to parse time-related phrases. Security roles do not affect how natural language queries are interpreted.
- D. Incorrect.
Incorrect. Removing indexes can negatively impact query performance and does not help the AI understand business-specific time references. The indexing strategy is separate from how the AI maps natural language to SQL.