Oracle Oracle Certifications 1Z0-931-22 Questions & Answers

• Question 81:

  Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?

  A. The Autonomous Database must belong to a Network Security Group (NSG).

  B. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.

  C. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.

  D. The marketplace OCI image can be used with an Always Free Autonomous Database account.

  E. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.

  Correct Answer: E

• Question 82:

  In Graph Studio which you can use to create a graph?

  A. A graph license key

  B. Tables in an Autonomous Database instance

  C. NoSQL configuration

  D. Graph analytics algorithms

  E. Graph created by a special tool downloaded from Oracle.com

  Correct Answer: B

• Question 83:

  

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

  A. 3-D modelling

  B. Churn analysis

  C. Pattern matching

  D. Facial recognition

  E. Clustering

  Correct Answer: ACE

  

  

• Question 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?

  A. Business Models

  B. Data Load

  C. SQL Developer Web

  D. APEX

  Correct Answer: B

  

• Question 85:

  Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

  A. IOPS, Storage Space Used By Tablespace, Applyand Transport Lag

  B. CPU Utilization, Storage Utilization

  C. Query Latency, User Calls, Execute Count

  D. Transaction Count, Sessions, Running Statements

  Correct Answer: B

• Question 86:

  Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

  A. inside the Autonomous Database wallet

  B. inside the backups of thecontainer database

  C. In a separate key vault external to the Exadata Infrastructure

  D. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted

  Correct Answer: C

• Question 87:

  When enabling auto-scaling, which three options do not change?

  A. Number of OCPUs displayed in the console.

  B. Amount of storage

  C. I/O resources

  D. parallelism settings

  E. Level of concurrency

  Correct Answer: BDE

  Explanation: https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/autonomous-autoscale.html#GUID-27FAB1C1-B09F-4A7A-9FB9- 5CB8110F7141

  

• Question 88:

  While creating a business model what advanced options you can enable or disable? (Choose three)

  A. Business Object Security Feature

  B. Analytic View Transparency View

  C. Autonomous Aggregate Cache

  D. Display private tables

  E. Analytic View Base Table Query Transformation

  Correct Answer: BCE

  

• Question 89:

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

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

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

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

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

  Correct Answer: A

  https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbddoverview.htm

• Question 90:

  When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?(Choose the best answer.)

  A. DBNAME_MEDIUM

  B. DBNAME_HIGH

  C. DBNAME_CONCURRENT

  D. DBNAME_LOW

  Correct Answer: D

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/managepriorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7

  https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID- 80E464A7-8ED445BB-A7D6-E201DD4107B7