NEW QUESTION 1
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 2
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?

• A. 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.
• B. The base number of OCPU cores allocated to a database is not guaranteed.
• C. 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.
• D. Auto scaling is enabled by default and can be enabled or disabled at any time.

Answer: A

NEW QUESTION 3
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 4
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

Answer: A

NEW QUESTION 5
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 6
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 7
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 8
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

• A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
• B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
• C. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
• D. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure

Answer: A

NEW QUESTION 9
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 10
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 11
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 12
What is the correct way to list all files in the default data pump directory?

• A. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
• B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
• C. Log onto ADW server and issue is -al on the command line.
• D. By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ' ) ;

Answer: A

NEW QUESTION 13
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 14
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data. How does the developer connect to and interact with ADB from Python?

• A. SQL Developer
• B. JAVA JDK
• C. You can't use Python with ADB.
• D. The Oracle Client and the cx_Oracle interface for Python

Answer: B

NEW QUESTION 15
An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.
Other than changing the shared user password, what can the admin do to protect the instance?

• A. Trust the user who left to not access the database.
• B. Shutdown and restart the instance.
• C. Rotate the instance wallet and share the new wallet with the remaining users.
• D. Delete the user.

Answer: B

NEW QUESTION 16
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 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
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 19
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 20
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 21
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 22
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 23
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 24
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 25
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 26
......