Oracle Autonomous Database Cloud 2024 Professional (1z0-931-24) Free Questions - Part 7
Question No : 91) 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 console. They have to be added using REST APIs only.
D. Navigate to Identity, select Users panel on the console and select "Add Public Key".
Question No : 92) Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
A. Undo Management
B. Index Storage
C. Memory Usage
D. Data Organization
E. Backup Retention
Question No : 93) 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.
Question No : 94) Which three are use cases for Graph Studio? (Choose three.)
A. 3-D modelling
B. Churn analysis
C. Pattern matching
D. Facial recognition
E. Clustering
Question No : 95) 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
Question No : 96) 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)
Question No : 97) 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 them. Associated (non-dependent) resources remain in their current compartments.
B. Moving an Autonomous Database instance does not include its automatic backups.
C. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
D. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.
Question No : 98) What is the default port number for accessing a newly created Autonomous Database?
A. 1524
B. 1522
C. 1521
D. 1523
E. 1526
Question No : 99) 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.
Question No : 100) 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.
Question No : 101) 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.
Question No : 102) Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?
A. RMAN
B. Logs
C. OCI Metrics
D. Performance Hub
E. Enterprise Manager Cloud Control
Question No : 103) Which option is not available to pick ( no.of days ) when configuring the backup retention for Oracle Container Database.
A. 120
B. 60
C. 15
D. 7
Question No : 104) 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.
Question No : 105) While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?
A. 60 days
B. 7 days
C. 15 days
D. 120 days
1z0-931-24 Answers