|
Format: Multiple Choice
Duration: 90 Minutes
Exam Price: $
Number of Questions: 60
Passing Score: 65%
Validation: This exam has been validated against Oracle Cloud Infrastructure
2023
Policy: Cloud Recertification
Earn associated certifications
Passing this exam is required to earn these certifications. Select each
certification title below to view full requirements.
Oracle Autonomous Database Cloud 2023 Certified Professional
Prepare to pass exam: 1Z0-931-23
An Oracle Autonomous Database 2023 Certified Professional has demonstrated the
knowledge required to provision, manage, monitor, and migrate workloads to
Autonomous Database, both on shared and dedicated Exadata infrastructure.
Individuals who earn this certification understand and successfully use the
features, workflows, and architecture of an Autonomous Database. In addition,
they are capable of using Autonomous Database tools to develop an Autonomous
Database.
Up-to-date training and hands-on experience or practice in Autonomous
Database is highly recommended.
This certification is available to all candidates, including on-premise DBAs,
Cloud data management professionals, and consultants.
Take recommended training
Complete one of the courses below to prepare for your exam (optional):
Become an Oracle Autonomous Database Cloud Professional (2023)
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs
and/or field experience), in the learning subscription, provides the best
preparation for passing the exam.
Review exam topics
Autonomous Database Technical Overview
Describe Autonomous Database architecture, integrations, and license types
Articulate the key features of Autonomous Database
Understand the Oracle Cloud Infrastructure
Describe the Different Autonomous Database offerings
Autonomous Database (ADB) Shared
Create Autonomous Database Shared Instances - provisioning, scaling OCPU and
storage, start, stop, and cloning and moving refreshable clones
Manage users
Monitor Autonomous Database Shared instances - events 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
Managing and Maintaining Autonomous Database
Manage Autonomous Database instances: REST APIs, OCI CLI, moving resources
Use Access Control Llist (ACL) and Private End Points
Monitor ADB performance and set up service notifications
Monitor ADB auto-scaling
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
Autonomous Database Tools
Describe Autonomous Database Tools
Use Autonomous Database with Oracle Machine Learning, APEX, and SQL Developer
Web (Database actions)
Use Data Load and Data Transforms
Create Business Models
Apply Data Insights
Explore Catalog
Developing an Autonomous Database
Use Autonomous JSON Database
Use Oracle Text
Use Oracle Spatial
Use Graph Studio
Integrate Object Storage data
Migrating to Autonomous Database
Describe the options and considerations for migrating to Autonomous Database
Migrate to Autonomous Database using Data Pump
1Z0-931-23 Brain Dumps Exam + Online / Offline and Android Testing Engine & 4500+ other exams included
$50 - $25 (you save $25)
Buy Now
QUESTION 1
You are the admin user of an Autonomous Database (ADB) instance. A new business
analyst has
joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?
A. Create a database user (with connect, resource, object privileges), enable
the schema to use SQL Developer and provide the user with the user-specific
modified URL.
B. Create a database user with the default privileges.
C. Create a database user with connect, resource, and object privileges.
D. Create an IDCS user. Create a database user with connect, resource, and
object privileges.
Answer: A
QUESTION 2
What is the correct way to list all files in the default data pump
directory?
A. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
B. You cannot list files in the default data pump directory from Autonomous Data
Warehouse (ADW).
C. Log onto ADW server and issue is -al on the command line.
D. By executing select * from utl_file . list ( "?DATA_PUMP_DIR ' ) ;
Answer: A
Explanation:
To list all files in the default data pump directory, you can use the
DBMS_CLOUD.LIST_FILES
procedure with the directory name as the parameter. See Listing Files in a
Directory for more details.
QUESTION 3
What REST verb is used to create an Autonomous Database service using REST APIs?
A. An "INSERT" REST call
B. A "GET" REST call
C. A "POST" REST call
D. A "PUT" REST call
Answer: C
Explanation:
To create an Autonomous Database service using REST APIs, you need to use a POST
method with the
appropriate request body. See Create Autonomous Database for more details.
QUESTION 4
When using Data Pump to migrate your Oracle database to Autonomous Database,
which two objects are imported?
A. Data
B. Schemas
C. Tablespaces
D. Reports
Answer: AB
Explanation:
When using Data Pump to migrate your Oracle database to Autonomous Database, you
can import
data and schemas from Data Pump files. You cannot import tablespaces or reports.
See Export Your
Existing Oracle Database to Import into Autonomous Database for more details.
QUESTION 5
What are two differentiators of Oracle Autonomous Database Dedicated
Infrastructure?
A. Users have OS access to the database machine.
B. Users can customize the maintenance schedule.
C. It offers greater control and isolation starting at the Exadata cloud
infrastructure level.
D. Users have SYS privileges in the database.
E. Users can customize the OS stack and add additional packages
Answer: BC
Explanation:
Certainly, here's a rewritten version of your text:
Holger Schmitz - 1 day ago - Germany
I loved Certkingdom.com very much. The site is so good. I prepared for
1Z0-931-23 exam peacefully without any trouble. I am happy that i know this
site and want to recommend it to all.
Rated 4 out of 5
Darron Sims - 2 weeks ago - United States Mississippi
Certkingdom is providing a support to all of the esteemed customers and so to
met to be Certified professional with an ease! I am much obliged. Because, I was
occupied with professional work, and still, I pass my Certification test and
this happened just because of Certkingdom’s exam experts made preparation
material.
Rated 4 out of 5
Tristan Pillay - 1 week ago - South Africa
Initially, I was so afraid to try exam, because I was running away from
embarrassment.
Rated 5 out of 5
Zeynep Aslan - 3 week ago - Turkey
Hello, I want to say my thanks. I was not prepared for my exam when i came
across your site. It gave me courage to prepare for exam with full effort and
within short time period i got the result that was outstanding.
Rated 5 out of 5
Omkar Harsoo - 4 week ago - South Africa
Certkingdom really helped to have hands-on various technical yet, real-life
1Z0-931-23 simulation questions. I am really thankful to Certkingdom for
boasting up my career.
Rated 5 out of 5