Latest Oct-2022 Oracle 1z0-931-22 Dumps Updated 115 Questions [Q67-Q81]

October 21, 2022 1z0-931-22, Oracle 0 Comments

Latest Oct-2022 Oracle 1z0-931-22 Dumps Updated 115 Questions [Q67-Q81]

4.5/5 - (11 votes)

Latest Oct-2022 Oracle 1z0-931-22 Dumps Updated 115 Questions

PDF Download Free of 1z0-931-22 Valid Practice Test Questions

Oracle 1z0-931-22 Exam Syllabus Topics:

Topic	Details
Topic 1	Manage Autonomous Database instances: REST APIs, OCI CLI, moving resources Understand the Oracle Cloud Infrastructure
Topic 2	Monitor Autonomous Database Shared instances – events and alarms Autonomous Database Dedicated & Autonomous Database Cloud @ Customer
Topic 3	Use services in ADB: auto indexing, data safe, compartment quotas Managing and Maintaining Autonomous Database
Topic 4	Create Autonomous Database Shared Instances – provisioning, scaling OCPU and storage Use Access Control List (ACL) and Private End Points
Topic 5	Monitor ADB performance and set up service notifications Autonomous Database Technical Overview
Topic 6	Use Marketplace Developer image to connect to ADB, use ADW with third party tools Describe the Different Autonomous Database offerings
Topic 7	Describe ADB Dedicated and ADB Cloud@Customer resources, workflows, and functionality Migrate to Autonomous Database using Data Pump
Topic 8	Use Autonomous Database with Oracle Machine Learning, APEX, and SQL Developer Web (Database actions) Articulate the key features of the Autonomous Database

QUESTION 67
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.

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

QUESTION 68
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 69
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?

Oracle Data Safe only supports Autonomous Databases.

Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.

Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.

https://www.oracle.com/database/technologies/security/data-safe.html
https://www.oracle.com/a/tech/docs/dbsec/data-safe/faq-security-data-safe.pdf Data Safe works with the following Oracle Databases Oracle on-Premises Databases Oracle Cloud Databases
− Autonomous Database on Shared Exadata Infrastructure
− Autonomous Database on Dedicated Exadata Infrastructure
− Exadata DB systems
− Database Cloud Service on Virtual Machine
− Database Cloud Service on Bare Metal
− Oracle Database on Compute

QUESTION 70
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 71
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’

https://docs.oracle.com/en-us/iaas/Content/Identity/Reference/adbpolicyreference.htm

QUESTION 72
Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?

RMAN

Logs

OCI Metrics

Performance Hub

Enterprise Manager Cloud Control

QUESTION 73
Which two are correct actions to take in order to Download the Autonomous Database Credentials?

Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.

Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.

Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.

Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.

Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1

QUESTION 74
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?

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

You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.

You cannot configure the scheduling for your Autonomous Databases on shared Exadata 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.

QUESTION 75
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?

Execute alter database for user MTHEO tablespace DATA quota = 10G;

Execute alter user MTHEO quota unlimited on tablespace DATA;

Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => ‘MTHEO’ , tablespace__quota => “UNLIMITED*);

Execute alter tablespace DATA set quota = 10G;

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0

QUESTION 76
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

Under Core Infrastructure then Compute then Autonomous Exadata

Under Solutions and Platform then Platform Services then Autonomous Exadata

Under Database then Autonomous Transaction Processing then Autonomous Exadata

Under Core Infrastructure then Autonomous Exadata

https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adbmanaginginfrastructure.htm#viewmaintenancehistory.
Even though the UI has changed recently, this documentation has the user go to Menu -> Database

QUESTION 77
Which statement is correct about the Service console in an 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

You can use Service console to move Autonomous DB between compartments

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

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

QUESTION 79
Which three are use cases for Graph Studio? (Choose three.)

3-D modelling

Churn analysis

Pattern matching

Facial recognition

Clustering

QUESTION 80
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

You can use the dbms_auto_index package to report on the automatic task and to set your preferences.

It is enabled by default.

You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.

The indexing feature is implemented as an automatic task that runs at a fixed interval.

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-index.html#GUID-D51A4F85-3AE5-4B7D-9B27-32CEDE8DBD79 – Auto Indexing is disabled by default in Autonomous Database

QUESTION 81
A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.
What should they do to remove this bottleneck?

Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

Remove any non-JSON data from the database.

Increase the number of OCPUs allocated to the database.

Ask Support to migrate their setup to a node without noisy neighbors.

Loading …