1Z0-184-25 Question 168
Single answerYou are the lead architect for a retail chain using Oracle Autonomous Database. Your team wants to leverage Select AI with Autonomous to generate sales reports from natural language prompts, such as 'Show me weekly revenue split by store locations, including online and physical stores.' However, the generated SQL queries fail to recognize the custom naming conventions used for store data in your schema, leading to incomplete results. Which action would most effectively ensure that Select AI with Autonomous can interpret the domain-specific terms accurately?
- A
Prompt the AI with the precise table and column names in every query request.
- B
Define synonyms or aliases in the Autonomous Database metadata that map to your custom naming conventions.
- C
Increase the CPU and storage resources allocated to the Autonomous Database instance.
- D
Enable auto-scaling in the Autonomous Database to dynamically handle AI-generated queries.
Show answer and explanation
Correct answer: B
Explanation
For Select AI with Autonomous to interpret custom business or domain terms successfully, those terms must map to the actual database structures. By defining synonyms or aliases in the metadata, you align natural language usage with the underlying schema. Refer to the Oracle Autonomous Database documentation on creating synonyms and managing metadata for AI-based querying to ensure accurate and consistent results.
- A. Incorrect.
Option 1: Prompting the AI with precise table and column names may help temporarily, but it defeats the purpose of natural language prompts and does not scale well if multiple users or changing column names are involved.
- B. Correct.
Option 2 (Correct): Creating synonyms or aliases within the database metadata ensures that custom terms are recognized by the AI feature. By aligning domain-specific language with the underlying schema, the AI can correctly generate SQL queries without confusion.
- C. Incorrect.
Option 3: Increasing CPU and storage resources does not resolve semantic misunderstandings of column naming conventions. This could address performance issues but not AI interpretation.
- D. Incorrect.
Option 4: Enabling auto-scaling might help with workload spikes, but it does not improve the AI feature� understanding of custom naming conventions.