What High Quality 1z0-931-20 Questions Pool Is

NEW QUESTION 1
What is the role of 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.

Answer: B

NEW QUESTION 2
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 3
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 4
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

• A. Users have OS access to the database machine.
• B. Users can customize the maintenance schedule.
• C. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
• D. Users have SYS privileges in the database.
• E. Users can customize the OS stack and add additional packages

Answer: CD

NEW QUESTION 5
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 6
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 7
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

• A. alter database set application_continuity=true
• B. alter session set application_continuity=true
• C. exec dbms_cloucl_admi
• D. enable_app_cont ( ' <service_name> ' ) ;
• E. alter system set application_continuity=true

Answer: D

NEW QUESTION 8
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 9
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 10
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 11
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 12
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.

Answer: A

NEW QUESTION 13
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

• A. The SQL statement completed its execution.
• B. The SQL statement is executing.
• C. The SQL statement is queued.
• D. The SQL statement did not complete either due to an error.

Answer: C

NEW QUESTION 14
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 15
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 16
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 17
Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

• A. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
• B. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
• C. 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.
• D. 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.

Answer: D

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

Answer: ADE

Explanation:
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-data-intro.html#GUID-5D2F

NEW QUESTION 19
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 the
• B. Associated (non-dependent) resources remain in their current compartments.
• C. Moving an Autonomous Database instance does not include its automatic backups.
• D. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
• E. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.

Answer: A

NEW QUESTION 20
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

• A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
• B. ADW since operational reporting is a higher priority in this scenario.
• C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
• D. AT
• E. Using 'tpurgent' and 'high' TNS services to separate connection types.

Answer: D

Explanation:
Autonomous Transaction Processing provides all of the performance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store.
As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.

NEW QUESTION 21
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 22
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 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
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 25
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

• A. On the Autonomous Database Console.
• B. SSH keys are not required in Oracle Cloud Infrastructure.
• C. SSH keys cannot be added from consol
• D. They have to be added using REST APIs only.
• E. Navigate to Identity, select Users panel on the console and select "Add Public Key".

Answer: D

Explanation:
- In the Console, click Identity, and then click Users. Locate the user in the list, and then click the user's name to view the details.
-Click Add Public Key.
- Paste the key's value into the window and click Add.

NEW QUESTION 26
......