Oracle Autonomous Database Cloud 2024 Professional (1z0-931-24) Free Questions - Part 4
Question No : 46) 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 default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
C. Oracle Database Result Cache is enabled by default for all SQL statements.
D. You have direct access to the database node.
Question No : 47) What REST verb is used to create an Autonomous Database service using REST APIs?
A. An "INSERT" REST call
B. A "GET" REST call
C. A "POST" REST call
D. A "PUT" REST call
Question No : 48) Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?
A. TPPERFORMANT
B. MEDIUM
C. HIGH
D. LOW
E. TPURGENT
Question No : 49) Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
A. Backup and recovery must be done using Recovery Manager(RMAN).
B. Select the snapshot of the backup.
C. Select the archived redo logs.
D. Select the backup from which restore needs to be done.
E. Specify the point in time (timestamp) to restore.
Question No : 50) While creating a business model what advanced options you can enable or disable? (Choose three)
A. Business Object Security Feature
B. Analytic View Transparency View
C. Autonomous Aggregate Cache
D. Display private tables
E. Analytic View Base Table Query Transformation
Question No : 51) You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
• Autonomous Transaction Processing
• License Included
• Shared Infrastructure
Which parameter would you NOT use?
A. db-workload
B. is-dedicated
C. db-type
D. license-model
Question No : 52) Which three of the following data sources are available when using the Data Load page on Database Actions?
A. Files in Oracle Cloud Storage
B. Backup files in block storage
C. Local Files
D. Files in AWS S3 Storage
E. REST endpoints
Question No : 53) 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
Question No : 54) You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?
A. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database
B. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END"
C. Create a notification alert using DBMS_SNMP package
D. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric
Question No : 55) Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?
A. inside the Autonomous Database wallet
B. inside the backups of the container database
C. In a separate key vault external to the Exadata Infrastructure
D. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted
Question No : 56) Which statement is FALSE about Oracle Data Safe?
A. It supports only Autonomous Databases.
B. It helps you assess the security of your cloud database configurations by analyzing database configurations.
C. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.
D. It evaluates user types, how users are authenticated, and the password policies assigned to each user.
E. It helps you evaluate risks to data, assess user security, monitor user activity, and address data security compliance requirements.
Question No : 57) For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?
A. SQLDEV_ADMIN.GRANT_SCHEMA
B. ORDS_ADMIN.ENABLE_SCHEMA
C. ORDS_ADMIN.GRANT_SCHEMA
D. ORDS_PRIV.ENABLE_SCHEMA
Question No : 58) 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.
Question No : 59) Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?
A. Admin page of the Cloud Service Console
B. OCI CLI
C. OS command line from the database server.
D. SQLDeveloper
Question No : 60) For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?
A. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’
B. Allow group ADB-Admins to manage autonomous-database in tenancy.
C. Allow group ADB-Admins to manage autonomous-database-family in tenancy.
D. Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'
1z0-931-24 Answers