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

• Question 91:

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

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

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

  

  Which stage of the indexingpipeline divides text into tokens?

  A. SECTIONER

  B. FILTER

  C. Otokenizer

  D. LEXER

  Correct Answer: D

• Question 95:

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

  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.

  Correct Answer: BC

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/file-uriformats.html#GUID-5D3E1614-ADF2-4DB5-B2B2-D5613F10E4FA

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms- cloud.html#GUID9428EA51-5DDD-43C2-B1F5-CD348C156122

• Question 97:

  Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

  A. TPPERFORMANT

  B. MEDIUM

  C. HIGH

  D. LOW

  E. TPURGENT

  Correct Answer: A

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

• Question 98:

  What is the roleof a Fleet Administrator in Autonomous Database (ADB) on Dedicated Infrastructure deployments?

  A. Fleet Administrator defines and gains access to the ADMIN administrative user account for the database.

  B. Fleet administrators create, monitor and manage Autonomous Exadata Infrastructure and Autonomous Container Database resources.

  C. Fleet Administrators are responsible for patching and backups of all container databases.

  D. Fleet Administrators create, monitor and manage Autonomous Databases.

  Correct Answer: B

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbah/index.html#articletitle https://docs.oracle.com/en/cloud/paas/autonomous-database/atpfg/index.html

• Question 99:

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

  A. 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.

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

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

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

  Correct Answer: A

  https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/databaseoverview.htm#moveRes

• 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