What Download 1z0-931-20 Questions Pool Is

NEW QUESTION 1
Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

• A. Autonomous Transaction Processing only
• B. ATP and ADW
• C. Autonomous Data Warehouse only
• D. Hybrid Columnar compression

Answer: C

NEW QUESTION 2
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

• A. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
• B. Autonomous Data Warehouse workloads are optimized for mixed workloads.
• C. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
• D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

Answer: D

Explanation:
- Both ADW and ATP share the Autonomous Database platform of Oracle Database on Exadata Cloud infrastructure.
The difference is how the services have been optimized within the database. When you start loading data into the autonomous database, we store the data in the appropriate format for the workload.
* If it is ADW, then we store data in columnar format because that's the best format for analytics processing.
• If it is ATP, then we store the data in row format because that's the best format for fast single row lookups.
- Oracle Autonomous Database is offered in two workload-optimized flavors
* Autonomous Data Warehouse (ADW), which has been optimized for analytic workloads
• Autonomous Transaction Processing (ATP). ATP is optimized for transaction processing or mixed workload https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-414 https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-414

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

• A. Under Core Infrastructure then Compute then Autonomous Exadata
• B. Under Solutions and Platform then Platform Services then Autonomous Exadata
• C. Under Database then Autonomous Transaction Processing then Autonomous Exadata
• D. Under Core Infrastructure then Autonomous Exadata

Answer: A

NEW QUESTION 4
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

• A. Transparent Data Encryption
• B. Database Vault
• C. Customer Managed Keys
• D. Data Redaction
• E. Audit Vault

Answer: ABC

Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472

NEW QUESTION 5
You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
• Autonomous Transaction Processing
• License Included
• Shared Infrastructure
Which parameter would you NOT use?

• A. db-workload
• B. is-dedicated
• C. db-type
• D. license-model

Answer: B

NEW QUESTION 6
Which statement is true when you provision an Autonomous Database using the cloning method?

• A. After an Autonomous database is created using a clone, the network access option can be changed.
• B. A clone database source can be a running database instance.
• C. A clone database source can be from a point-in-time backup that is less than 2 hours old.
• D. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

Answer: D

NEW QUESTION 7
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

• A. It cannot be done.
• B. Using Database Configuration Assistant (DBCA) on the database server.
• C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
• D. Connecting to the Cloud Infrastructure Command console via SSH wallet.

Answer: C

Explanation:
The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.
https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using-oci-curl Examples of using Autonomous Database managing by REST API
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/LabGuide900ConfigureO

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

• A. Backup and recovery must be done 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.

Answer: DE

Explanation:
In the Restore 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/backkup-recover.html#GUID-78

NEW QUESTION 9
Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?

• A. Current settings for ACLs are cloned.
• B. Clone can be in a different region.
• C. All OML notebooks are cloned.
• D. All underlying data for OML notebooks is cloned.
• E. All resource management rules are cloned.

Answer: CE

NEW QUESTION 10
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 in Oracle 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.

Answer: BC

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/file-uri-formats.html#GUID-5D3 https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID-9428EA

NEW QUESTION 11
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

• A. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints
• B. An Autonomous Database with private endpoints can be accessed from the public internet byadding your ip address to an Access Control List.
• C. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
• D. You can configure Private Endpoints for an Always Free Autonomous Database

Answer: BC

NEW QUESTION 12
You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs.
What is the total number of concurrent statements that the TPURGENT service can support?

• A. 900
• B. 1800
• C. 2700
• D. 1500

Answer: C

NEW QUESTION 13
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

• A. Parallelism is not enabled by default.
• B. Compression is enabled by defaul
• C. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
• D. Oracle Database Result Cache is enabled by default for all SQL statements.
• E. You have direct access to the database node.

Answer: AB

NEW QUESTION 14
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

Answer: DE

NEW QUESTION 15
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

• A. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.
• B. The OCI compute instance does not support connecting to a Shared Autonomous Database.
• C. The Autonomous Database must belong to a Network Security Group (NSG).
• D. The OCI compute instance can be used with an Always-Free Autonomous Database account.
• E. A Private Endpoint is required to connect to the Shared-Autonomous Database.

Answer: A

NEW QUESTION 16
During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

• A. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
• B. the Client Credentials wallet which is used to connect to the Autonomous Database
• C. the 'High Availability Container Database' in which the Autonomous instance should run
• D. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
• E. the Listener endpoint where the Autonomous Database should register on

Answer: B

NEW QUESTION 17
Which three event types are supported for Autonomous Database?

• A. Terminate End
• B. Maintenance Begin
• C. Change Compartment Begin
• D. Change Autoscaling Configuration Compartment
• E. Update IORM Begin

Answer: ABC

Explanation:
https://docs.oracle.com/en-us/iaas/Content/Events/Reference/eventsproducers.htm

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

• A. Execute alter database for user MTHEO tablespace DATA quota = 10G;
• B. Execute alter user MTHEO quota unlimited on tablespace DATA;
• C. Execute DBMS_CLOUD_ADMI
• D. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' ,Tablespace___quota => "UNLIMITED*);
• E. Execute alter tablespace DATA set quota = 10G;

Answer: D

NEW QUESTION 19
While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

• A. Release Update (RU)
• B. Prior Release Update Revision (PRUR)
• C. Prior Release Update (PRU)
• D. Quarterly Bundle Patch (QBP)

Answer: A

NEW QUESTION 20
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

Answer: A

Explanation:
Predefined Database Service Names for Autonomous Transaction Processing
The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
• tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
• tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
• high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
• medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
• low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A

NEW QUESTION 21
In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?

• A. Oracle Machine Learning notebook
• B. Compartment quotas
• C. Resource Manager settings
• D. SQL Developer Web Console

Answer: C

NEW QUESTION 22
What is the default port number for accessing a newly created Autonomous Database?

• A. A.-1524B.1522C.1521D.1523E.1526

Answer: B

Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf

NEW QUESTION 23
You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?

• A. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
• B. Create a database user with the default privileges.
• C. Create a database user with connect, resource, and object privileges.
• D. Create an IDCS use
• E. Create a database user with connect, resource, and object privileges.

Answer: A

NEW QUESTION 24
......