Oracle Database@AWS Architect Professional study plan

Map every component of the Oracle Database@AWS reference architecture (ODB network, VPC peering, Exadata infrastructure, VM cluster, container database, pluggable databases) into a single labeled diagram you draw from memory

Explain out loud, in under five minutes, how OCI-hosted Exadata hardware is presented inside an AWS account and which party owns each layer of the stack

Compare Oracle Database@AWS with self-managed RDS for Oracle and with running Oracle on EC2, listing at least six decision criteria such as latency, licensing, and operational ownership

Identify the shared-responsibility split for patching, backups, network controls, and identity, and record it in a table

Design two candidate solutions for a given workload (one latency-sensitive OLTP, one consolidation/DR scenario) and justify the choice of Exadata shape, storage, and availability domain placement

Calculate capacity and licensing implications for a stated workload, including core counts, storage headroom, and the effect of Auto Scaling or elastic configuration where available

Draft a migration-readiness and sizing checklist that a customer would complete before committing to a design

Present a 10-minute design review to a peer or rubber-duck recording, defending trade-offs on cost, resilience, and complexity

Write a step-by-step provisioning runbook covering prerequisites, IAM permissions, ODB network creation, Exadata infrastructure, VM cluster, and CDB/PDB creation

List the exact order of operations and the failure modes that occur when steps are performed out of order

Enumerate the configuration parameters that most affect performance and availability, and state a recommended default for each

Document how to validate a completed deployment with connectivity, listener, and database health checks

Automate a repeatable deployment using infrastructure-as-code or CLI scripting, parameterizing network CIDRs, credentials references, and cluster sizing

Tear down and rebuild the environment at least once to prove the automation is idempotent and complete

Reconcile your runbook against the automation and correct every discrepancy

Review the domain 1 and 2 objectives and rewrite your notes into question-and-answer form for self-testing

Design the network topology end to end: VPC and subnet layout, ODB network peering, route tables, security groups, and DNS resolution paths between AWS and the database

Trace a client connection hop by hop and identify every control point where traffic could be blocked

Define an identity model covering AWS IAM principals, Oracle Cloud Identity, database users, and how federated access is granted and audited

Specify encryption in transit and at rest, key management, and audit logging destinations, then verify each control is configurable

Implement and test least-privilege access for three personas (DBA, application, auditor), proving each can do its job and nothing more

Configure and verify audit logging and alerting, then confirm logs reach the intended destination with the expected retention

Document a break-glass procedure for emergency access including approval, time limits, and review

Run a connectivity failure test (blocked route or security group change) and record detection and recovery time

Define recovery objectives (RPO/RTO) for a stated business case and select the matching HA and DR pattern, including Data Guard or backup-based strategies

Write and execute a backup and restore test, measuring actual restore time and data loss against the stated objectives

Document patching, scaling, and maintenance workflows including who initiates them and what the expected impact is

Build a monitoring plan covering database, host, and network metrics with thresholds and escalation paths

Produce a migration plan for one workload using a phased cutover, including assessment, data movement method, validation, and rollback triggers

Complete two timed practice exams or a large self-written question set covering all four domains, and score above 80 percent

Review every missed item and write a one-line correction for each into a personal error log

Re-read only the highest-risk notes and confirm each domain's objectives are covered by your materials