1Z0-184-25 Question 165
Select 2Your retail company stores sales data in an Oracle Autonomous Database. The business analysts want to retrieve monthly sales figures by region using natural language prompts through Select AI with Autonomous, but you must ensure they only see the necessary fields and that the queries correctly match column names. Which two actions should you take to achieve this goal?
- A
Create synonyms for key tables and columns so business analysts can reference them in natural language queries.
- B
Enable PUBLIC grants on all tables containing sales data, ensuring queries can be processed without privilege issues.
- C
Use Oracle REST Data Services (ORDS) to expose the entire schema to the analysts, bypassing the need for explicit table privileges.
- D
Grant the analysts only the roles and privileges needed for querying the specific sales columns while restricting sensitive data.
Show answer and explanation
Correct answers: A, D
Explanation
When using Select AI with Autonomous, natural language queries are translated into SQL behind the scenes. Providing synonyms for tables and columns improves the AI engine� ability to match user prompts to database objects. Additionally, aligning with minimum necessary privileges, often referred to as 'least privilege', is crucial to enforce security for sensitive data. For more information, refer to Oracle� Autonomous Database documentation on synonyms, privileges, and data security best practices.
- A. Correct.
Synonyms help the AI engine match natural language terms to underlying database objects. By creating synonyms that map common business terms to actual table and column names, analysts' natural language prompts are more likely to be correctly interpreted and translated into SQL statements.
- B. Incorrect.
Granting PUBLIC privileges on entire tables containing sensitive data is a risky move because it grants everyone full access, violating data governance and security requirements. This is a common misconception that it might 'simplify' queries, but it causes security breaches.
- C. Incorrect.
Exposing the entire schema through ORDS bypasses fine-grained privilege management, making it impossible to restrict queries to the necessary columns only. This approach can inadvertently reveal sensitive data to users who do not need it.
- D. Correct.
Limiting privileges ensures analysts can query the non-sensitive columns they need while protecting any restricted information. Granting the least privilege required is a fundamental best practice in Oracle Cloud Infrastructure and aligns with data security guidelines.