The Down To Date Guide To 1z0-931-20 Question

NEW QUESTION 1
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?

• A. Change the Automatic Maintenance Schedule to 'None’d.
• B. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.
• C. You cannot permanently disable scheduled Automatic Maintenance.
• D. Change the Automatic Maintenance Schedule to 'No Preference'.

Answer: B

NEW QUESTION 2
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 3
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 4
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 5
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 a high 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.

Answer: C

NEW QUESTION 6
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?

• A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
• B. Create a database link from source database to the ADB environment and clone the PDB.
• C. Unplug to an xml file so database files and xml file can be uploaded to object storage.
• D. Unplug into a pdb archive which can be uploaded to object storage.

Answer: A

Explanation:
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.

NEW QUESTION 7
Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?

• A. Admin page of the Cloud Service Console
• B. OCI CLI
• C. OS command line from the database server.
• D. SQLDeveloper

Answer: B

NEW QUESTION 8
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 9
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

• A. through the Oracle Cloud Infrastructure service console
• B. through SQL/Developer s
• C. using DBMS_CLOUD_ADMIN package
• D. through SQLPIus

Answer: BD

Explanation:
https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-create-service https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A30 https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sql-dev.html#GUID-FB6 https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud-admin.html#GUID-D

NEW QUESTION 10
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 11
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

• A. Data Pump Export File
• B. Avro
• C. Parquet
• D. Text
• E. JSON
• F. Microsoft SQL Server (.mdf)

Answer: B

NEW QUESTION 12
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 13
You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?

• A. TPURGENT
• B. TP
• C. MEDIUM
• D. LOW

Answer: A

Explanation:
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8

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

• A. You can skip a scheduled maintenance ru
• B. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.
• C. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
• D. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
• E. You can perform a "rolling restart" on all the Autonomous Database
• F. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.

Answer: D

NEW QUESTION 15
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 16
Which statement is true when the Autonomous Database has auto scaling enabled?

• A. Database concurrency is scaled up when needed by the workload.
• B. Increases the number of sessions available to the database.
• C. Scales the PGA and SGA size when needed for the workload.
• D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

Answer: D

NEW QUESTION 17
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 18
Which two are correct actions to take in order to Download the Autonomous Database Credentials?

• A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
• B. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
• C. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
• D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
• E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

Answer: AE

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

Answer: BC

NEW QUESTION 20
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

• A. Data
• B. Schemas
• C. Tablespaces
• D. Reports

Answer: AB

NEW QUESTION 21
Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

• A. Network Security Group
• B. Security List
• C. VCN
• D. Route Table
• E. Subnet

Answer: ACE

Explanation:
To provision an Autonomous Database with a private endpoint, you must have the following resources alrea created:
A VCN within the region that will contain your Autonomous Database with shared Exadata infrastructure. Cannot be changed after provisioning.
A private subnet within your VCN configured with default DHCP options. Cannot be changed after provisioning.
At least 1 network security group (NSG) within your VCN for the Autonomous Database. Can be changed or edited after provisioning.
https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adbsprivateaccess.htm

NEW QUESTION 22
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 23
......