(2023) 1z0-931-23 Dumps and Practice Test (175 Questions) [Q72-Q88] : Actual Test Materials : http://blog.actualtests4sure.com

NO.72 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.73 Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

Undo Management

Index Storage

Memory Usage

Data Organization

Backup Retention

NO.74 Which statement is FALSE about Oracle Text?

It provides indexing, word and theme searches

It is suited to search document collections

It requires an Oracle Text license for Autonomous Database

t uses standard SQL queries

NO.75 As a database architect, you are tasked with configuring a high concurrency, production OLTP (online transaction processing) 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?

MEDIUM

HIGH

TP

TPURGENT

NO.76 Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

Data Pump Export File

Avro

Parquet

Text

JSON

Microsoft SQL Server (.mdf)

NO.77 You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?

TPURGENT

TP

MEDIUM

LOW

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

NO.79 What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

alter database set application_continuity=true

alter session set application_continuity=true

exec dbms_cloucl_admin. enable_app_cont ( ‘ <service_name> ‘ ) ;

alter system set application_continuity=true

NO.80 Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

Network Security Group

Security List

VCN

Route Table

Subnet

NO.81 Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?

Maximum Continuity

Maximum Availability

Maximum Performance

Maximum Protection

NO.82 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.83 Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

Autonomous Transaction Processing

Autonomous Data Warehouse

Neither service ignores hints by default

Both services ignore hints by default

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

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

NO.86 Which two actions are available to perform when an Autonomous Database is stopped?

Start

Update Network Access

Change administrator password

Update License Type

NO.87 Which statement is NOT correct when setting up compartment quotas?

There are three types of quota policy statements which are set, unset and zero.

Compartment quotas use policies that allow allocation of resources with a high level of flexibility.

Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.

Compartment quotas are set by Oracle.

NO.88 Which statement is true when the Autonomous Database has auto scaling enabled?

Database concurrency is scaled up when needed by the workload.

Increases the number of sessions available to the database.

Scales the PGA and SGA size when needed for the workload.

Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.