O R A C L E C E R T I F I C A T I O N
1Z0-931 Oracle Autonomous Database Cloud 2022 Professional Practice Exam
Exam Number: 4834 | Last updated April 19, 2026 | 700+ questions across 4 vendor-aligned objectives
The 1Z0-931 Oracle Autonomous Database Cloud 2022 Professional exam targets database administrators, data engineers, and cloud architects who deploy and operate Oracle Autonomous Database. Candidates validate command of provisioning, scaling, backup and recovery, security, and the developer tools baked into Autonomous Database on shared and dedicated Exadata infrastructure, plus migration paths from on-prem and other clouds.
The heaviest content is Provisioning, Scaling, and Lifecycle Management (roughly 30%), covering Autonomous Data Warehouse, Autonomous Transaction Processing, Autonomous JSON Database, cloning, refresh clone, auto-scaling, and lifecycle events. Security and Network Access contributes another 25% with Transparent Data Encryption, OCI Vault customer-managed keys, Data Safe, and private endpoints.
Tools, Development, and Load Integration sits near 25% and drills into SQL Developer Web, APEX on Autonomous Database, Oracle Machine Learning Notebooks, Database Actions, and Data Studio for data loading. Migration, Monitoring, and Performance rounds out the remaining weight with Data Pump, Zero Downtime Migration, Performance Hub, and auto-indexing.
Every answer links to the source. Each explanation below includes a hyperlink to the exact Oracle documentation page the question was derived from. PowerKram is the only practice platform with source-verified explanations. Learn about our methodology →
540
practice exam users
90.9%
satisfied users
89.3%
passed the exam
4.3/5
quality rating
Test your 1Z0 931 Autonomous DB Pro knowledge
10 of 700+ questions
Question #1 - Provisioning, Scaling, and Lifecycle Management
A data architect is spinning up a new Autonomous Database for a JSON-heavy document workload. The team queries documents with SQL-over-JSON, stores large BLOBs, and does not need traditional relational workloads.
Which Autonomous Database workload type fits best?
A) Autonomous JSON Database (AJD).
B) Base Database VM with manual configuration.
C) Autonomous Data Warehouse (ADW).
D) Autonomous Transaction Processing (ATP).
Show solution
Correct answers: A – Explanation:
Autonomous JSON Database is purpose-built for document-heavy JSON workloads at lower cost than ATP or ADW. Option D is tuned for OLTP relational. Option C is tuned for analytics. Option B is self-managed. Source: Check Source
Question #2 - Provisioning, Scaling, and Lifecycle Management
A DBA wants to create a read-only clone of a production Autonomous Database that tracks the parent’s changes with periodic refresh, so the reporting team can run analytics without impacting production.
Which Autonomous Database feature fits an ongoing refreshed read-only clone of a production database?
A) Manually retyping the schema each week.
B) Refreshable clone that periodically pulls changes from the source parent.
C) A one-time full clone with no refresh.
D) An Object Storage export refreshed nightly.
Show solution
Correct answers: B – Explanation:
Refreshable clones periodically synchronize from a source Autonomous Database, which is exactly the described pattern. Option C is a point-in-time copy. Option D is lagging. Option A is manual. Source: Check Source
Question #3 - Tools, Development, and Load Integration
A data engineer needs a browser-based SQL tool for Autonomous Database that supports query execution, explain plans, and data modeling — without installing anything locally.
Which tool fits?
A) A mobile app store download.
B) A desktop terminal with sqlplus only.
C) SQL Developer Web accessed via Database Actions.
D) The OCI Console billing page.
Show solution
Correct answers: C – Explanation:
SQL Developer Web (via Database Actions) is the browser-based SQL tool delivered with Autonomous Database — no install needed. Option D is billing, not SQL. Option B requires local install. Option A is not the supported tool. Source: Check Source
Question #4 - Security and Network Access
A compliance officer at a healthcare client requires Autonomous Database reachable only from the customer VCN, with all public internet access disabled.
Which configuration fits?
A) Store the wallet in a public bucket.
B) Leave default public endpoint access and add an IP allowlist only.
C) Disable TLS on the connection.
D) Configure a private endpoint for the Autonomous Database attached to the customer VCN.
Show solution
Correct answers: D – Explanation:
A private endpoint makes the Autonomous Database reachable only via the attached VCN, with no public IP — the required private-access design. Option B still keeps public endpoint exposure. Option C breaks TLS. Option A leaks credentials. Source: Check Source
Question #5 - Security and Network Access
An architect wants customer-managed master keys in OCI Vault for TDE on Autonomous Database, with keys rotated every 90 days.
Which combination supports customer-managed TDE keys with rotation?
A) OCI Vault master encryption keys referenced by the Autonomous Database with scheduled rotation.
B) Oracle-managed keys only with no customer involvement.
C) Disabling encryption entirely.
D) A plain text key in a Git repo.
Show solution
Correct answers: A – Explanation:
OCI Vault holds customer-managed master keys that TDE uses for data encryption, with scheduled rotation supported — the regulated-workload pattern. Option B does not meet compliance. Option D is a severe security violation. Option C violates encryption policy. Source: Check Source
Question #6 - Tools, Development, and Load Integration
A data scientist wants a notebook experience inside Autonomous Database for running Python and SQL against the database’s own tables, with models later deployable to production.
Which Autonomous Database tool fits an in-database Python and SQL notebook experience for ML?
A) A separate Jupyter install on a compute instance with no integration.
B) Oracle Machine Learning Notebooks included with Autonomous Database.
C) A manually authored SQL*Plus script only.
D) Excel spreadsheets pointed at the database.
Show solution
Correct answers: B – Explanation:
OML Notebooks are bundled with Autonomous Database and support Python/SQL/R against in-database data with in-database model training — the designed experience. Options A, C, and D lack the integrated OML experience. Source: Check Source
Question #7 - Tools, Development, and Load Integration
A data engineer wants to load 500 GB of CSV files from OCI Object Storage into an Autonomous Data Warehouse without writing custom ETL code.
Which Autonomous Database capability fits?
A) Manual INSERT statements typed by hand.
B) A print-and-retype workflow.
C) Data Studio Load Data (or DBMS_CLOUD.COPY_DATA) for bulk loading from Object Storage.
D) A FTP transfer into a local directory on the database server.
Show solution
Correct answers: C – Explanation:
Data Studio (and DBMS_CLOUD.COPY_DATA under the hood) bulk-loads from Object Storage into Autonomous Database without custom code — the designed path. Option A does not scale. Option D is not the Autonomous Database access model. Option B is absurd at 500 GB. Source: Check Source
Question #8 - Migration, Monitoring, and Performance
A DBA migrating a 1 TB on-prem Oracle database to Autonomous Database wants Data Pump to read directly from Object Storage rather than landing dumps on the database server.
Which PL/SQL API supports Object Storage-backed Data Pump imports?
A) A local filesystem dump copied via scp.
B) Emailing the .dmp file to Oracle support.
C) Pasting the dump file into a SQL*Plus session.
D) DBMS_CLOUD combined with impdp using a credential to Object Storage.
Show solution
Correct answers: D – Explanation:
DBMS_CLOUD impdp allows Data Pump to read from Object Storage directly using credentials, the Autonomous Database migration pattern. Options A, B, and C are not supported paths for Autonomous. Source: Check Source
Question #9 - Provisioning, Scaling, and Lifecycle Management
A DBA wants Autonomous Database CPU to scale up during peak hours and back down overnight, saving cost while maintaining performance when load spikes.
Which Autonomous Database feature fits automatic CPU elasticity for daily peak spikes?
A) Auto Scaling on CPU allowing up to 3x the base OCPU count as demand spikes.
B) Keeping peak OCPUs always allocated.
C) Manual size changes each day.
D) A second database for off-hours only.
Show solution
Correct answers: A – Explanation:
Auto Scaling lets Autonomous Database elastically grow up to 3x base OCPU on demand, shrinking back automatically — the designed elasticity. Option C is toil. Option D duplicates data. Option B wastes spend. Source: Check Source
Question #10 - Migration, Monitoring, and Performance
A performance engineer notices that an Autonomous Database query has been repeatedly slow. She wants an AWR-style view of wait events, top SQL, and concurrent sessions over the last 24 hours.
Which Autonomous Database tool fits AWR-style 24-hour wait event and top-SQL analysis?
A) An email alert every hour.
B) A custom Python script against V$SESSION.
C) Performance Hub in the OCI Console for Autonomous Database.
D) The OCI Console billing page.
Show solution
Correct answers: C – Explanation:
Performance Hub surfaces AWR-style insights for Autonomous Database: wait events, top SQL, concurrent sessions, and I/O patterns over time. Option D is not performance data. Option B is not the intended path on Autonomous. Option A is lagging. Source: Check Source
Get 700+ more questions with source-linked explanations
Every answer traces to the exact Oracle documentation page — so you learn from the source, not just memorize answers.
Exam mode & learn mode · Score by objective · Updated April 19, 2026
Learn more...
What the 1Z0 931 Autonomous DB Pro exam measures
- Provisioning, scaling, and lifecycle management (30%) — provision Autonomous Data Warehouse, Autonomous Transaction Processing, and Autonomous JSON Database, and use cloning, refresh clone, and auto-scaling.
- Security and network access (25%) — apply Transparent Data Encryption, OCI Vault customer-managed keys, Data Safe, and private endpoints for regulated workloads.
- Tools, development, and load integration (25%) — use SQL Developer Web, APEX, Oracle Machine Learning Notebooks, Database Actions, and Data Studio.
- Migration, monitoring, and performance (20%) — migrate with Data Pump and Zero Downtime Migration, tune with Performance Hub, and operate the auto-indexing feature.
How to prepare for this exam
- Review the official 1Z0-931 exam page for the current objectives and weights.
- Complete the Oracle University Oracle Autonomous Database Cloud Professional learning path on MyLearn.
- In an OCI always-free tenancy, provision Autonomous Data Warehouse, load data with Data Studio, enable auto-indexing, and clone the instance into a read-only copy for reporting.
- Apply the skills on real work: migrate a lab database with Data Pump, register a staging Autonomous Database with Data Safe, or write a SQL Developer Web notebook for a team dashboard.
- Master one objective at a time, starting with provisioning, scaling, and lifecycle management since it carries the most weight.
- Run PowerKram learn mode to see feedback after every question with sourced links back to Oracle documentation.
- Finish with PowerKram exam mode across all objectives until you clear the threshold three times in a row.
Career paths and salary outlook
Autonomous Database skills support senior DBA and data-platform careers:
- Cloud Database Administrator (Autonomous Database) — $115,000–$160,000 (Glassdoor).
- Senior Oracle DBA — $125,000–$175,000 (PayScale).
- Data Platform Architect — $140,000–$195,000 (U.S. Bureau of Labor Statistics).
Official resources
Anchor your study in the Oracle Autonomous Database Cloud Professional Learning Path on Oracle MyLearn. Reinforce with the Oracle Autonomous Database documentation and the Oracle LiveLabs hands-on workshops.