Oracle Autonomous Database Cloud 2024 Professional (1z0-931-24) Free Questions - Part 3
Question No : 31) 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
Question No : 32) Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?
A. When you restore a database, the existing ACLs are not overwritten by the restore.
B. An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.
C. ACLs can only be used with private endpoints.
D. An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.
Question No : 33) 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).
Question No : 34) 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'.
Question No : 35) 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
Question No : 36) 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. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.
Question No : 37) Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)
A. Use SFTP to copy CSV files into Autonomous Database
B. Use Oracle Zero Downtime Migration (ZDM)
C. Use Recovery Manager (RMAN)
D. Use GoldenGate
E. Use Data Pump
Question No : 38) Which native data type is used to store spatial information?
A. SDO_RELATE
B. SDO_GEOMETRY
C. SDO_LOCATION
D. GEO_JSON
Question No : 39) 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
Question No : 40) 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
Question No : 41) 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.
Question No : 42) Which statement is not correct when the Autonomous Database is stopped?
A. In-flight transactions queries are stopped
B. Tools are no longer able to connect to a stopped instance
C. User with DWROLE can still access the database
D. CPU billing is halted
Question No : 43) When you are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?
A. 2 hours
B. 30 minutes
C. 1 hours
D. 24 hours
Question No : 44) 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
Question No : 45) Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)
A. RMAN Cross-Platform backup and restore
B. Golden Gate on-premise installation
C. PDB unplug / plug operation
D. Datapump export / import
E. Dataguard Physical Standby
F. Golden Gate Cloud service
1z0-931-24 Answers