Exam Syllabus: 1Z0-931-22 Oracle Autonomous Database Cloud

2022 Professional

Autonomous Database Technical Overview

- Describe Autonomous Database architecture, integrations, and license types

- Articulate the key features of the Autonomous Database

- Understand the Oracle Cloud Infrastructure

- Describe the Different Autonomous Database offerings

- Create Autonomous Database shared Instancesprovisioning, scaling OCPU and storage, start. stop, and cloning and moving, refreshable clones

Autonomous Database (ADB) Shared

- Manage users

- Monitor Autonomous Database Shared instancesevents and alarms

- Manage Autonomous Database Shared Backups and Restores

Autonomous Database Dedicated & Autonomous Database Cloud @ Customer

- Describe ADB Dedicated and ADB Cloud@Customer resources, workflows, and functionality

- Provision Dedicated ADB (ADB, Exadata, Container DB, VM Cluster for Cloud @ Customer)

- Monitor Dedicated Infrastructure

- Manage maintenance scheduling (patching)

- Manage encryption keys

- Manage Autonomous Database instances: REST APIs, OCI CLI, moving resources

- Use Access Control List (ACL) and Private End Points

- Monitor ADB performance and set up service notifications

- Monitor ADB auto scaling

Managing and Maintaining Autonomous Database

- Use services in ADB: auto indexing, data safe, compartment quotas

- Use ADB connectivity: Wallets, service handles

- Use Marketplace Developer image to connect to ADB, use ADW with third party tools

- Configure Disaster Recovery (Data Guard) - both Shared and Dedicated

- Describe Autonomous Database Tools

- Use Autonomous Database with Oracle Machine Learning, APEX, and SQL Developer Web (Database actions)

Autonomous Database Tools

- Use Data Load and Data Transforms

- Create Business Models

- Apply Data Insights

- Explore Catalog

Developing on Autonomous Database

Migrating to Autonomous Database

- Use Autonomous JSON Database

- Use Oracle Text

- Use Oracle Spatial

- Use Graph Studio

- Integrate Object Storage data

- Describe the options and considerations for migrating to Autonomous Database

- Migrate to Autonomous Database using Data Pump

Oracle 1Z0-931-22 Certification Sample Questions and Answers

To make you familiar with the structure of the Oracle Autonomous Database Cloud 2022 Professional (1Z0-931-22) certification exam, we have prepared this sample question set. We suggest you try our Sample Questions for Oracle 1Z0-931-22 Certification to test your understanding of Oracle 1Z0-931-22 process with the real Oracle certification exam environment.

1Z0-931-22 Oracle Autonomous Database Cloud 2022 Professional Sample Questions

01. Which statement is true in regards to database links?

a) Connect from Autonomous Database to remote database using a database link.

b) Connect to Autonomous Database from remote database using a database link.

c) You can call PL/SQL procedures and functions using a database link.

d) Create a database link from one Autonomous Database to another Autonomous Database instance.

02. Which can be Scaled independently of the number of CPUs in an Autonomous Database?

a) Concurency b) Memory c) Parallelism d) Storage e) Sessions a) Transportable Tablespace b) Oracle Data Pump c) RMAN Restore d) Oracle GoldenGate e) SQL*Loader

03. What are three methods to load data into the Autonomous Database?

1Z0-931-22: Oracle Autonomous Database Cloud 2022 Professional 4 a) TPURGENT b) TP c) HIGH d) MEDIUM a) OJDBC.PROPERTIES b) TNSNAMES.ORA c) SQLNET.ORA d) CWALLET.SSO a) SCOTT b) ADMIN c) SYS d) DWDEV a) Autonomous Data Warehouse workloads are optimized for mixed workloads. b) Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake. c) Data that Is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format Is columnar. d) Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

04. As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which connection service is appropriate for such a workload?

05. When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?

06. What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?

07. While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

08. Given the steps:

1. Create Oracle Machine Learning User

2. Create projects

3. Create workspaces

4. Create Notebooks

5. Run SQL Scripts a) Run SQL Scripts b) Create Notebooks c) Create workspaces d) Create projects

Which two steps are out of order when working with Oracle Machine learning?