Winter Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 28522818

Home > Oracle > Oracle Autonomous Database > 1z0-931-22

1z0-931-22 Oracle Autonomous Database Cloud 2022 Professional Question and Answers

Question # 4

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

A.

Parallelism is not enabled by default.

B.

Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

C.

Oracle Database Result Cache is enabled by default for all SQL statements.

D.

You have direct access tothe database node.

Full Access
Question # 5

Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?

A.

Current settings for ACLs are cloned.

B.

Clone can be in a different region.

C.

All OML notebooks are cloned.

D.

All underlying data for OML notebooks is cloned.

E.

All resource management rules are cloned.

Full Access
Question # 6

Autonomous Database's auto scaling feature allowsyour database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.

Which statement is FALSE regarding the auto scaling feature?

A.

For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meethigh-load demands.

B.

The base number of OCPU cores allocated to a database is not guaranteed.

C.

For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.

D.

Auto scaling is enabled by default and can be enabled or disabled at any time.

Full Access
Question # 7

Which statement is FALSE about setting up compartment quotas?

A.

Quotas set on a parent compartment override quotas set on childcompartments.

B.

Compartment quotas cannot be set on the root compartment.

C.

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

D.

You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.

Full Access
Question # 8

According to Oracle documentation, it is a best practice whenplanning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.

Which statement is true?

A.

Create a separate VCN that contains only public subnets

B.

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

C.

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

D.

Create at least 2 of each resource

Full Access
Question # 9

What is the default port number for accessing a newly created Autonomous Database?

A.

1524

B.

1522

C.

1521

D.

1523

E.

1526

Full Access
Question # 10

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 pumpdirectory 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 ' ) ;

Full Access
Question # 11

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

A.

Use SFTP to copy CSV files into Autonomous Database

B.

Use Oracle Zero Downtime Migration (ZDM)

C.

Use Recovery Manager (RMAN)

D.

Use GoldenGate

E.

Use Data Pump

Full Access
Question # 12

An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.

Other than changing the shared user password, what can the admin do to protect the instance?

A.

Trust the user who left to not access the database.

B.

Shutdown and restart the instance.

C.

Rotate the instance wallet and share the new wallet with the remaining users.

D.

Delete the user.

Full Access
Question # 13

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

A.

Network Security Group

B.

Security List

C.

VCN

D.

Route Table

E.

Subnet

Full Access
Question # 14

A BusinessAnalyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.

When restoring/cloning the ADB, you must select a backup which is atleast___

hours/minutes old.

A.

24hrs

B.

2 hrs

C.

5 min

D.

1 day

Full Access
Question # 15

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

A.

The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

B.

The source files can reside inOracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.

C.

A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

D.

The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

E.

The target table will be created in Autonomous Database if it does not already exist.

Full Access
Question # 16

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

A.

Suppress alarms during investigations.

B.

Create multiple alarm metrics.

C.

Create a single alarm for each metric.

D.

Select the correct alarm interval for your metric.

E.

Routinelytune your alarms.

F.

Use a single interval for all alarms.

Full Access