1z0-931-23 Free Certification Exam Material from VCEPrep with 183 Questions [Q60-Q80]

July 11, 2024 admin 0

Categories : 1z0-931-23 , Oracle

Rate this post

1z0-931-23 Free Certification Exam Material from VCEPrep with 183 Questions

Use Real 1z0-931-23 – 100% Cover Real Exam Questions

QUESTION 60
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

Transparent Data Encryption

Database Vault

Customer Managed Keys

Data Redaction

Audit Vault

https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472B-8287-41682C2B61B3

QUESTION 61
Which is a feature of a graph query language?

Scripting language

Run key-value queries

Object-oriented language

Ability to specify patterns

QUESTION 62
Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

Parallelism

Storage

Concurency

Memory

Sessions

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A-84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

QUESTION 63
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?

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.

Create a database user with the default privileges.

Create a database user with connect, resource, and object privileges.

Create an IDCS user. Create a database user with connect, resource, and object privileges.

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-database-actions.html#GUID-55BA432E-098A-48ED-B2EA-F2960A9EF586 To enable a user to access SQL Developer Web, you need to create a database user with the appropriate privileges, enable the schema for SQL Developer Web, and provide the user with the modified URL that includes the schema name. See Enabling Users to Access SQL Developer Web for more details.

QUESTION 64
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator

the Client Credentials wallet which is used to connect to the Autonomous Database

the ‘High Availability Container Database’ in which the Autonomous instance should run

the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment

the Listener endpoint where the Autonomous Database should register on

https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adb_dedicated_creating.htm

QUESTION 65
Which two methods can you use to define Oracle Machine Learning users?

SQL Developer

the DBMS_CLOUD_ADMIN package

Oracle Cloud Infrastructure Console

Service Console

QUESTION 66
Which four file formats are supported when loading data from Cloud Storage?

Parquet

DOC

DDL

JSON

CSV

AVRO

QUESTION 67
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,

Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure

https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/components.html#GUID-
268B36E1-87D8-4649-A370-226E2AE3FC5C

QUESTION 68
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.
How does the developer connect to and interact with ADB from Python?

SQL Developer

JAVA JDK

You can’t use Python with ADB.

The Oracle Client and the cx_Oracle interface for Python

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connecting-nodejs.html#GUID-AB1E323A-65B9-47C4-840B-EC3453F3AD53
https://developer.oracle.com/databases/database-for-python-developers-1.html

QUESTION 69
Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

RMAN Cross-Platform backup and restore

Golden Gate on-premise installation

PDB unplug / plug operation

Datapump export / import

Dataguard Physical Standby

Golden Gate Cloud service

Reference:
https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud-optionsdata-pump-sql-loader-dbms_cloud-goldengate/

QUESTION 70
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

Users have OS access to the database machine.

Users can customize the maintenance schedule.

It offers greater control and isolation starting at the Exadata cloud infrastructure level.

Users have SYS privileges in the database.

Users can customize the OS stack and add additional packages

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbat/index.html#articletitle

QUESTION 71
Which two statements are true about Oracle Cloud Infrastructure (OCI)?

An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region

A single fault domain can be associated with multiple regions and availability domains

Regions are dependent on other regions and must be located within five thousand kilometers of each other

Because availability domains do not share infrastructure, such as power or cooling, or the Internal availability domain network, a failure at one availability domain within a region is u likely to impact the availability of the there within the same region

QUESTION 72
Which two statements are true about Data Insights?

You can retrieve previously executed Data Insights searches.

Data Insights is available with on-premises deployments of Oracle Database.

Data Insights is an additional priced option.

You can search for Data Insights against a base table or business model.

QUESTION 73
Which statement is FALSE regarding database links?

You can call PL/SQL procedures and functions by using a database link

You can connect to an Autonomous Database from a remote database using a database link

You can create a database link from one Autonomous Database to another Autonomous Database instance

You can connect to a remote database from an Autonomous Database by using a database line

QUESTION 74
When enabling auto-scaling, which three options do not change?

Number of OCPUs displayed in the console.

Amount of storage

I/O resources

parallelism settings

Level of concurrency

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141

QUESTION 75
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

through the Oracle Cloud Infrastructure service console

through SQL/Developer s

using DBMS_CLOUD_ADMIN package

through SQLPIus

https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-service
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB611317-2999-4C8C-8A3B-B3B3D3C5B417
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D76B229E-781E-45C0-9F14-CAF30F9E6E3B
“To create users in your database, connect to the database as the ADMIN user using any SQL client tool.” https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-users-create.html#GUID-54CA837B-CD6A-4ED2-A960-5874535818CB

QUESTION 76
Which statement is correct about management operations on Autonomous Database on Shared. Infrastructure?

You can perform a “rolling restart” on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available

You can skip a scheduled maintenance run. For Autonomous Databases on Shared Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed

You cannot configure the scheduling for your Autonomous Databases on Shared Infrastructure

You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your Autonomous Databases on Shared Infrastructure

QUESTION 77
Which three are Oracle-recommended best practices for Autonomous Database alarms?

Suppress alarms during investigations.

Create multiple alarm metrics.

Create a single alarm for each metric.

Select the correct alarm interval for your metric.

Routinely tune your alarms.

Use a single interval for all alarms.

QUESTION 78
Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

Use SFTP to copy CSV files into Autonomous Database

Use Oracle Zero Downtime Migration (ZDM)

Use Recovery Manager (RMAN)

Use GoldenGate

Use Data Pump

https://www.oracle.com/sa/database/technologies/cloud-migration.html

QUESTION 79
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

Autonomous Transaction Processing only

ATP and ADW

Autonomous Data Warehouse only

Hybrid Columnar compression

QUESTION 80
You are requested to analyze a year’s stock purchase data which is stored in Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and create pivot tables?

Business Models

Data Load

SQL Developer Web

APEX

Loading …

Oracle 1z0-931-23 Exam Syllabus Topics:

Topic	Details
Topic 1	Use ADB connectivity: Wallets, service handles Manage Autonomous Database instances: REST APIs, OCI CLI, moving resources
Topic 2	Monitor Autonomous Database Shared instances – events and alarms Describe Autonomous Database architecture, integrations, and license types
Topic 3	Monitor ADB performance and set up service notifications Describe ADB Dedicated and ADB Cloud@Customer resources, workflows, and functionality
Topic 4	Understand the Oracle Cloud Infrastructure Manage Autonomous Database Shared Backups and Restores
Topic 5	Managing and Maintaining Autonomous Database Create Autonomous Database Shared Instances – provisioning, scaling OCPU and storage
Topic 6	Describe the Different Autonomous Database offerings Articulate the key features of Autonomous Database
Topic 7	Use Access Control Llist (ACL) and Private End Points Configure Disaster Recovery (Data Guard) – both Shared and Dedicated
Topic 8	Use services in ADB: auto-indexing, data safe, compartment quotas Migrate to Autonomous Database using Data Pump