[Apr 19, 2025] ValidExam 1Z0-931-24 dumps & Oracle Cloud sure practice dumps [Q61-Q81]

admin 1Z0-931-24 Oracle April 19, 2025

5/5 - (1 vote)

[Apr 19, 2025] ValidExam 1Z0-931-24 dumps & Oracle Cloud sure practice dumps

Oracle 1Z0-931-24 Actual Questions and Braindumps

NO.61 Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?

TPURGENT

MEDIUM

HIGH

TPPERFORMANT

LOW

NO.62 When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

The SQL statement completed its execution.

The SQL statement is executing.

The SQL statement is queued.

The SQL statement did not complete either due to an error.

NO.63 Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Backup and recovery must be done using Recovery Manager(RMAN).

Select the snapshot of the backup.

Select the archived redo logs.

Select the backup from which restore needs to be done.

Specify the point in time (timestamp) to restore.

NO.64 Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

Undo Management

Index Storage

Memory Usage

Data Organization

Backup Retention

NO.65 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.66 Which two actions can you perform with Autonomous Data Guard enabled on Autonomous Database on Shared Infrastructure?

Switchover

Reinstate

Change Protection Mode

View Apply Lag

Failover

NO.67 For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’

Allow group ADB-Admins to manage autonomous-database in tenancy.

Allow group ADB-Admins to manage autonomous-database-family in tenancy.

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘OLTP’

NO.68 Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.

Moving an Autonomous Database instance does not include its automatic backups.

You do not need to have sufficient access permissions on the compartment that the resource is being moved to.

Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.

NO.69 Which task is NOT automatically performed by the Oracle Autonomous Database?

Backing up the database.

Mask your sensitive data.

Patching the database.

Automatically optimize the workload.

NO.70 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.71 What REST verb is used to create an Autonomous Database service using REST APIs?

A “POST” REST call

A “PUT” REST call

An “INSERT” REST call

A “GET” REST call

NO.72 Which vaults are used for storing customer-managed encryption keys for Autonomous Database on Dedicated Infrastructure?

Oracle Key Vault, Oracle Cloud Infrastructure Vault

Oracle Database Vault, Oracle Key Vault

Oracle Audit Vault, Oracle Key Vault

Oracle Cloud Infrastructure Vault, Oracle Database Vault

NO.73 Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

Place the credential files on a share drive that all users can use to connect to the database.

The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.

Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.

When you share the credential files with authorized users, mail the wallet password and the file in the same email.

NO.74 What is the correct way to list all files in the default data pump directory?

By executing select * from DBMS_CLOUD.LIST_FILES(‘DATA_PUMP_DIR’);

You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).

Log onto ADW server and issue is -al on the command line.

By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ‘ ) ;

NO.75 Which three event types are supported for Autonomous Database?

Terminate End

Maintenance Begin

Change Compartment Begin

Change Autoscaling Configuration Compartment

Update IORM Begin

NO.76 Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

Exadata

Active Data Guard

RAC, but only when scaling beyond 16 OCPUs

Transparent Data Encryption

Multitenant

NO.77 Which statement is correct about managing and monitoring of Autonomous Database?

You can use Service console to move Autonomous DB between compartments.

You can use Service console to create manual backups of Autonomous database.

You can use Service console to enable or disable auto scaling of Autonomous DB.

You can use Service console to manage runaway SQL statements on Autonomous DB.

NO.78 How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

Two. They are called ATP and ADW.

None. There are no pre-defined service names in tnsnames.ora.

Three. They are called high, medium and low.

Five. They are called tpurgent, tp, high, medium and low.

NO.79 When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

Storage in TB cannot be larger than the number of OCPUs.

OCPUs and storage must remain in sync.

Increasing OCPUs will automatically increase storage.

OCPUs and storage can be scaled independently.

NO.80 Which three are use cases for Graph Studio? (Choose three.)

3-D modelling

Churn analysis