[Dec 24, 2023] Reliable 1z0-931-23 Exam Tips Test Pdf Exam Material [Q35-Q58]

4.7/5 - (3 votes)

[Dec 24, 2023] Reliable 1z0-931-23 Exam Tips Test Pdf Exam Material

New 2023 1z0-931-23 Test Tutorial (Updated 175 Questions)

NO.35 Where can a user’s public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

On the Autonomous Database Console.

SSH keys are not required in Oracle Cloud Infrastructure.

SSH keys cannot be added from console. They have to be added using REST APIs only.

Navigate to Identity, select Users panel on the console and select “Add Public Key”.

NO.36 Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints

An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.

Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.

You can configure Private Endpoints for an Always Free Autonomous Database

NO.37 To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB

Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure

Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB

Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB

NO.38 Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?

You must first manually create your database credentials using dms_cloud.create_credentia before accessing your Oracle Object Storage Bucket

Data can be loaded from a remote database using Database Links (DBLinks)

Data can be loaded from a local data source

Data can be uploaded from several cloud storage sources including 53, Azure, Google Cloud and Oracle Object Storage

Data formats supported include: text, csv, json, avro and parquet

NO.39 Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is stopped.
Which statement is true?

The standby database is terminated.

The standby database is also stopped.

Switchover is automatically initiated.

Failover is automatically initiated.

NO.40 Which two Oracle Cloud Infrastructure (OCI) resources do you need to create before initiating a manual backup of Oracle Autonomous Database?

Backup Job

Service Gateway

Auth Token

Object Storage Bucket

Storage Gateway

NO.41 In which four ways can Oracle Database optimally access data in Object Storage?

optimized data archive using partitioned external tables

optimized data archive using hybrid partitioned tables

scan avoidance using block skipping when reading parquet and ore files

scan avoidance using columnar pruning for columnar stores like parquet and orc

scan avoidance using partitioned external tables

scan avoidance using columnar pruning for .csv files

NO.42 According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.
Which statement is true?

Create a separate VCN that contains only public subnets

Only 1 of each is allowed to be allocated per environment.

Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

Create at least 2 of each resource

NO.43 You enabled Autonomous Data Guard on Autonomous Database on Shared Infrastructure.
Which three statements are true about the standby database after a failover?

Autonomous Data Guard automatically reverts to the primary database when it becomes available again

Autonomous Data Guard automatically creates a new standby database

A new wallet is required to connect to the standby database

The OCPU Count, Storage, Display Name, Database Name, Auto Scaling, Tags, and Licensing options have the same values as the primary

Oracle Machine Learning Notebooks created in the primary database are available in the standby database

NO.44 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

NO.45 When an administrator rotates the instance wallet for an Autonomous Database on Shared Infrastructure, what happens to the regional wallets used with that instance?

They continue to work

They revert to pending

They are also rotated

They become invalid

NO.46 Which three are Oracle-recommended best practices for Autonomous Database alarms?

Create a single alarm for each metric

Suppress alarms during investigations

Tune your alarms routinely

Select the correct alarm interval for your metric

Use a single interval for all alarms

Create multiple alarm metrics

NO.47 Which three operations are available for a quarterly maintenance update on Autonomous Container Database?

Reschedule patching

Skip patching

Apply a partial patch

Patch immediately

Reschedule and patch immediately

NO.48 You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs.
What is the total number of concurrent statements that the TPURGENT service can support?

900

1800

2700

1500

NO.49 Which two of the following statements are correct?

ODI Web Edition is available only on Oracle Linux.

ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.

The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.

All of the capabilities of ODI Classic are available with ODI Web Edition,

NO.50 Which two methods can you use to create database users and grant roles in Autonomous Database services?

the Oracle Cloud Infrastructure A. service console

SQL Developer

the DBMS_CLOUD_ADMIN package

SQL *Plus

NO.51 Which of the following two statements regarding Data Transforms are correct?

Data Transforms provides access to Oracle Data Integrator (ODI) Web Edition

All capabilities to transform data in ODI Classic are available with ODI Web Edition

Workflows for data transforms is only available on the ODI Web Edition

Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows

NO.52 What is the role of a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.

Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.

Fleet Administrators are responsible for patching and backups of all container databases.

Fleet Administrators create, monitor and manage Autonomous Databases.

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

Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

Autonomous Data Warehouse workloads are optimized for mixed workloads.

Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

NO.54 What are the two supported infrastructure options for deploying an Autonomous Database?

VM on Oracle Cloud Infrastructure

Dedicated Exadata Infrastructure

Any Oracle Engineered System

Shared Exadata Infrastructure

Bare-metal on Oracle Cloud Infrastructure

NO.55 How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

It cannot be done.

Using Database Configuration Assistant (DBCA) on the database server.

Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Connecting to the Cloud Infrastructure Command console via SSH wallet.

NO.56 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

NO.57 Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?

Change the Automatic Maintenance Schedule to ‘None’d.

Change the Automatic Maintenance Schedule to ‘Specify a Schedule’ but do not select any month, week or day.

You cannot permanently disable scheduled Automatic Maintenance.

Change the Automatic Maintenance Schedule to ‘No Preference’.

NO.58 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.