UUS Practice Tests⌕ Search
IT Certifications · 1Z0-1146

Oracle AI Database@AWS Architect Professional Exam Practice Test

Architecting Oracle AI Database@AWS involves connecting AWS-hosted applications to Oracle database services while balancing network design, security, resilience, and operating cost. The practice bank uses scenarios about private connectivity, database lifecycle changes, workload isolation, data migration, encryption, auditing, and application behavior during timeouts or maintenance. These topics provide a practical lens on design decisions that affect database access and service continuity.

Exam overview

Exam providerOracle
Exam code1Z0-1146
CategoryIT Certifications

About the Oracle AI Database@AWS Architect Professional Exam

Architecture work includes selecting connection patterns that keep database traffic on private network paths and avoid brittle dependence on fixed endpoint details. Application design must account for connection-pool recovery after maintenance and for operations that may be retried after a timeout, where idempotency helps prevent duplicate effects. Workload isolation limits the impact of one component’s database demand on others, while safeguards reduce the chance of destructive commands reaching production. Migration planning considers how to load a large baseline dataset before a short final cutover. Security and operations decisions include protecting stored data and backups with encryption, retaining useful audit records, and identifying which deployment choices drive recurring costs. The scenarios are useful for practicing tradeoffs among application behavior, network configuration, data protection, migration approach, and operational control.

Sample Practice Questions

Review a selection from this exam's published US Practice Tests practice bank.

Question 1

A company wants to reduce the chance that an operator accidentally runs a destructive database command against production instead of a test environment. Which measure is most appropriate?

  1. AUse clearly separated environments and reinforce environment identity through access controls and operational safeguards
  2. BGive test and production databases identical names and credentials
  3. CRemove environment labels from database connection settings
  4. DAllow production access from every developer workstation by default
Show answerCorrect answer: A

Distinct environments, clear identification, and appropriately restricted access reduce the chance of confusing test and production targets. Safeguards such as reviewed deployment procedures can add further protection for destructive actions.

Question 2

An application team wants to reduce the chance that excessive database calls from one component consume resources needed by other components. Which design approach is most appropriate?

  1. AUse workload isolation or resource-governance capabilities where supported, and validate limits against service behavior and workload needs.
  2. BGive every component unrestricted access to database resources so no request is delayed.
  3. CIncrease connection counts without monitoring to ensure capacity is always available.
  4. DRun all application components under one identity and rely on naming conventions to separate their workloads.
Show answerCorrect answer: A

Resource governance and workload isolation can help contain the impact of one workload, provided the selected controls are supported and properly tuned. Unrestricted access or simply increasing connection counts can worsen resource contention.

Question 3

A database application hosted in AWS must connect to an Oracle database service over a private network path. Which design principle should guide the connection setup?

  1. AUse an explicitly supported private connectivity path and verify routing, name resolution, and security rules end to end
  2. BAssume that resources in the same AWS Region can communicate privately by default
  3. CExpose the database listener to the public internet to simplify routing
  4. DUse a public endpoint and rely only on application-level passwords
Show answerCorrect answer: A

Private connectivity depends on the supported network architecture and correctly configured routing, DNS, and access controls. Sharing a Region does not automatically establish connectivity, and public exposure is not a substitute for a private design.

Question 4

A company needs to move a large initial dataset to a new database while keeping the final application cutover window short. Which migration strategy is generally suitable for evaluation?

  1. ALoad the initial data ahead of cutover and use a supported method to capture and apply subsequent changes before switching applications
  2. BWait until cutover to begin transferring all data
  3. CStop all writes for several weeks while copying the database
  4. DCopy only database object definitions and assume application data will be recreated automatically
Show answerCorrect answer: A

An initial load followed by change capture and application can reduce the amount of work remaining at cutover. The team must verify that the selected migration tools support the source, target, data types, and required consistency objectives.

Question 5

A team is reviewing the cost of a database deployment and wants to understand which design choices drive ongoing spend. Which approach is most useful?

  1. AEstimate costs using expected resource consumption, service pricing dimensions, and workload patterns, then review actual usage
  2. BAssume database costs are fixed regardless of capacity or utilization
  3. CChoose the largest available configuration because it always has the lowest total cost
  4. DIgnore storage, backups, and data transfer because only compute affects cost
Show answerCorrect answer: A

A practical cost assessment considers applicable pricing dimensions and expected workload behavior, then compares estimates with observed usage. Costs can include more than compute, and oversized capacity may increase rather than reduce spend.

Question 6

An application team is designing how to handle a database operation that might be submitted again after a timeout even though the original request may have succeeded. Which design concern is most relevant?

  1. AMake retryable operations idempotent or otherwise detect duplicate processing
  2. BRetry every request indefinitely without tracking its outcome
  3. CIncrease database storage so duplicate requests consume less space
  4. DDisable transaction boundaries to ensure the request is repeated
Show answerCorrect answer: A

A timeout does not always reveal whether a database operation committed. Idempotency keys, duplicate detection, or other transaction-aware handling can prevent retries from applying the same business action more than once.

Question 7

An application uses a database connection pool. After a database maintenance event, users report stale connections and intermittent failures. Which application behavior is most appropriate?

  1. ADetect failed connections, discard them, and establish fresh connections with bounded retry behavior
  2. BKeep retrying the same failed connection indefinitely
  3. CIncrease the connection pool size without checking connection health
  4. DDisable error handling so the pool can recover automatically
Show answerCorrect answer: A

Connection pools should validate or detect unusable connections, replace them, and use bounded retries to avoid endless loops or retry storms. Simply enlarging a pool does not repair stale connections.

How to use this practice test

Access is free. A session presents up to 20 random questions from the 50-question practice bank, including scenarios on AWS connectivity, migration, cost, security, and application resilience. After the session, review the displayed results to identify which architectural decisions or database behaviors need another pass.

Preparation tips

  • Sketch the application-to-database network path and identify how private routing and changing endpoints affect connection configuration.
  • For timeout and maintenance scenarios, distinguish safe request retries from duplicate database effects, and plan how pooled connections are refreshed or discarded.
  • Compare bulk-load migration with ongoing change capture when evaluating a large initial transfer and a short cutover window.
  • Map risks involving sensitive data and compliance evidence to encryption for stored data and backups, plus appropriately retained database audit records.
  • Break down recurring deployment costs by the design choices that consume resources, then compare alternatives against workload needs.
Official sourceOfficial exam page ↗