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

• Question 91:

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

  A. Undo Management

  B. Index Storage

  C. Memory Usage

  D. Data Organization

  E. Backup Retention

  Correct Answer: BC

• Question 92:

  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?

  A. Oracle Data Safe only supports Autonomous Databases.

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

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

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

  Correct Answer: A

  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 93:

  

  Which stage of the indexingpipeline divides text into tokens?

  A. SECTIONER

  B. FILTER

  C. Otokenizer

  D. LEXER

  Correct Answer: D

• Question 94:

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

  A. Exadata

  B. Active Data Guard

  C. RAC, but only when scaling beyond 16 OCPUs

  D. Transparent Data Encryption

  E. Multitenant

  Correct Answer: CE

  Refer to https://www.oracle.com/autonomous-database/autonomous-data- warehouse/pricing/

  If you run Oracle Database EnterpriseEdition and the required options listed below, then your BYOL

  requirements are as follows:

  For 1-16 OCPUs of a single Oracle Autonomous Data Warehouse instance:

  For each supported Processor license of Oracle Database Enterprise Edition plus Options:

  Multitenant, you may activate up to 2 OCPUs of the BYOL Cloud Service. For every 25 supported Named

  User Plus licenses of Oracle Database Enterprise Edition plus Options: Multitenant, you may activate 1

  OCPU of the BYOL Cloud Service. For 17 OCPUs or more of a single Oracle Autonomous Data

  Warehouse:

  For each supported Processor license of Oracle Database Enterprise Edition plus Options:

  Multitenant and Real Application Clusters, you may activate up to 2 OCPUs of the BYOL Cloud Service.

  For every 25 supportedNamed User Plus licenses of Oracle Database Enterprise Edition plus Options:

  Multitenant and Real Application Clusters, you may activate 1 OCPU of the BYOL Cloud Service.

  https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html "Docustomers need

  Exadata licenses to benefit from BYOL?"

• Question 95:

  Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?

  A. Week of the Quarter, Day of the Week, Start Hour

  B. Month of the Year, Week of the Month, Day of the Week, Start Hour

  C. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour

  D. Month of the Quarter, Week of the Month, Day of the Week, Start Hour

  Correct Answer: D

• Question 96:

  What are three methods to load data into the Autonomous Database?

  A. Oracle GoldenGate

  B. Transportable Tablespace

  C. RMAN Restore

  D. Oracle Data Pump

  E. SQL*Loader

  Correct Answer: ADE

  https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb- faqs.html#ATPD

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-dataintro.html#GUID-5D2F70D8-4FA1-482C-BFB0-43441FB897F3

• Question 97:

  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 theydo to remove this bottleneck?

  A. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

  B. Remove any non-JSON data from the database.

  C. Increase the number of OCPUs allocated to the database.

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

  Correct Answer: D

• Question 98:

  Which statement is NOT correct when setting up compartment quotas?

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

  B. Compartment quotas use policies that allow allocation of resources with ahigh level of flexibility.

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

  D. Compartment quotas are set by Oracle.

  Correct Answer: D

  https://docs.oracle.com/enus/iaas/Content/General/Concepts/resourcequotas.htm

  

• Question 99:

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

  A. Backup and recovery must bedone using Recovery Manager(RMAN).

  B. Select the snapshot of the backup.

  C. Select the archived redo logs.

  D. Select the backup from which restore needs to be done.

  E. Specify the point in time (timestamp) to restore.

  Correct Answer: DE

  In theRestore prompt, select Specify Timestamp or Select Backup to restore to a point in time or to restore from a specified backup.

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backkuprecover.html#GUID-78C28C41-AA87-4AD7-BEB6-693235C73F3C

  

• Question 100:

  Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?

  A. Oracle Cloud Infrastructure Object Storage

  B. Google Cloud Storage

  C. Amazon S3

  D. Oracle Cloud Infrastructure Object Storage Classic

  Correct Answer: B