Oracle Autonomous AI Database Professional (1Z0-931-26) - Practice Exam 1

1. A business needs a continuously updated disaster-recovery peer with faster recovery than restoring backups alone. Which option should be evaluated?
2. A client must connect using mTLS. Which supplied material should be handled as sensitive connection configuration?
3. A cloud administrator can view the database resource but should not read sensitive SQL tables. What should be maintained?
4. A compliance team asks who is responsible for limiting application access to business data in an autonomous service. What is the best answer?
5. A COPY_DATA load reports rejected records. Which evidence should the author inspect first?
6. A CSV load maps values to the wrong columns because the source layout changed. What should be corrected before retrying?
7. A database must be accessible only through the organization's private VCN connectivity. Which option should be evaluated?
8. A development team needs the production schema definitions but must not copy production rows. Which clone type is the closest fit?
9. A document assistant should retrieve passages with similar meaning rather than rely solely on exact keywords. Which database capability supports this?
10. A growing data load needs more database storage, but only compute auto scaling is enabled. What should be reviewed?
11. A JSON source must be loaded into an existing table using a supported DBMS_CLOUD path. Which approach is appropriate?
12. A large one-time load is slow when streamed from a remote workstation. Which option should be evaluated?
13. A lower-cost backup-based recovery option is compared with a continuously maintained standby. Which tradeoff should be reviewed?
14. A migration plan includes unsupported source features. What should occur before the production cutover?
15. A periodic workload briefly needs more CPU and IO than the configured base. Which feature should be evaluated?
16. A planned maintenance exercise should exchange primary and standby roles while both are healthy. Which operation is the appropriate concept?
17. A platform team creates the database through OCI IAM. An application still cannot log into its schema. What distinction matters?
18. A private-endpoint client resolves the correct private address but cannot establish an mTLS connection. Which control should be checked?
19. A private Object Storage load fails with an authorization error. What should be checked?
20. A RAG application changes its embedding model. What should be evaluated before searching existing document vectors with new query embeddings?
21. A reporting query became slow after an application release. Which evidence should be examined before increasing compute?
22. A reporting team needs a read-only copy that can be refreshed from the source. Which clone type should it evaluate?
23. A security review requires longer-term analysis of database user activity. What should be evaluated?
24. A Select AI integration should use only an approved reporting schema. What should be configured in addition to a useful AI profile?
25. A team assumes an external table will remain readable even after its source files are removed. What should an architect clarify?
26. A team claims that encrypted connections alone prevent an authorized user from reading inappropriate tables. What should be clarified?
27. A team estimates cost for a new ECPU-based database. Which factor must be included beyond the configured base compute?
28. A team expects Autonomous AI Database to make an unbounded Cartesian join efficient without query review. What is the best guidance?
29. A team moves every analytical request to the highest-priority service and experiences queuing. What should it examine?
30. A team wants a compatible JDBC Thin client to connect with TLS without downloading an mTLS wallet. What must be verified?
31. A team wants cloning permissions without unrelated database-management rights. Which approach should be evaluated?
32. A test team needs realistic application data without exposing production personal information. Which Data Safe capability is most relevant?
33. A valid database password works from one application host but connections time out from a newly created subnet. Which area should be examined first?
34. An application needs access to one reporting view. Which database identity design is most appropriate?
35. An application opens a new database connection for every small query. What should be evaluated?
36. An application uses frequent short transactions while a separate workload performs large analytical scans. What should an architect assess when provisioning Autonomous AI Database?
37. An external MCP-compatible assistant needs controlled access to approved Autonomous database tools. Which design is appropriate?
38. An incident occurred two hours ago but current utilization is normal. Which Performance Hub capability is relevant?
39. An on-premises Oracle database must migrate with a very short outage. Which approach should be evaluated after compatibility assessment?
40. Analysts need SQL access to object-store data without first copying all rows into database tables. Which feature fits?
41. Analysts want to inspect natural-language-generated SQL before running it. Which Select AI action fits?
42. Compute auto scaling is enabled with a base of eight ECPUs. Ignoring other limits, what documented upper multiplier should the planner consider?
43. CSV files in a private object store must be loaded into an existing Autonomous table. Which operation is the direct bulk-loading choice?
44. Developers want to commit an mTLS wallet with their application source. What is the correct response?
45. Many short application requests use a service intended for a different concurrency and parallelism tradeoff. What should be reviewed?
46. Operations needs notifications when database failover begins or ends. Which OCI integration should be evaluated?
47. Operators need to stop and start databases but should not broadly administer unrelated tenancy resources. What is the correct policy direction?
48. Regional failure is in scope for disaster recovery. What should the architecture evaluate?
49. Security officers need data discovery, risk assessment, user assessment, and activity auditing for the database. Which integrated service should they evaluate?
50. Several sessions wait on locks while CPU use stays modest. What is the best initial response?

Comments — 0