Free Oracle Autonomous Database Cloud 2021 Specialist Exam 1Z0-931-21 Exam Practice Test

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?

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

Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

• If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
• Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
• You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.
• Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.

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

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

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

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

Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.Which statement is FALSE regarding the auto scaling feature?

• For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands.
• The base number of OCPU cores allocated to a database is not guaranteed.
• For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.
• Auto scaling is enabled by default and can be enabled or disabled at any time.

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

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

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

• Network Security Group
• Security List
• VCN
• Route Table
• Subnet

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

• SQLDEV_ADMIN.GRANT_SCHEMA
• ORDS_ADMIN.ENABLE_SCHEMA
• ORDS_ADMIN.GRANT_SCHEMA
• ORDS_PRIV.ENABLE_SCHEMA

Which statement is true when connecting OCI Marketplace image to shared autonomous database?

• Compute Image and Shared ADB must be in same VCN and Subnet
• ADB must be configured with NSG
• ADB must be configured with Private endpoints
• Cannot connect OCI Market image to shared ADB

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

• The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
• The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
• A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
• The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
• The target table will be created in Autonomous Database if it does not already exist.