Oracle Autonomous Database Cloud 2024 Professional (1z0-931-24) Free Questions - Part 6
Question No : 76) Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?
A. The Autonomous Database must belong to a Network Security Group (NSG).
B. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure.
C. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.
D. The marketplace OCI image can be used with an Always Free Autonomous Database account.
E. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.
Question No : 77) Which statement is FALSE about Oracle Autonomous JSON Database?
A. JSON data is stored natively in the database
B. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
C. It supports NoSQL-style, document-centric application
D. There is a 20 GB limit on JSON collection
Question No : 78) 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
Question No : 79) Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
A. Current settings for ACLs are cloned.
B. Clone can be in a different region.
C. All OML notebooks are cloned.
D. All underlying data for OML notebooks is cloned.
E. All resource management rules are cloned.
Question No : 80) Which three options are available to access data in an Autonomous JSON Database?
A. Oracle Cloud Infrastructure console using the JSON Online Developer tool
B. Oracle JSON Developer tool downloaded from OTN
C. NOSQL statements using Oracle SODA drivers
D. REST API calls to the database (not enabled by default)
E. Regular Oracle SQL statements using a connection through the listener
Question No : 81) Which workload type does the Autonomous Database on dedicated infrastructure service currently support?
A. Autonomous Transaction Processing only
B. ATP and ADW
C. Autonomous Data Warehouse only
D. Hybrid Columnar compression
Question No : 82) Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
A. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
B. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
C. It is enabled by default.
D. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
E. The indexing feature is implemented as an automatic task that runs at a fixed interval.
Question No : 83) Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?
A. Week of the Quarter, Day of the Week, Start Hour
B. Month of the Year, Week of the Month, Day of the Week, Start Hour
C. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour
D. Month of the Quarter, Week of the Month, Day of the Week, Start Hour
Question No : 84) Which three are Oracle-recommended best practices for Autonomous Database alarms?
A. Suppress alarms during investigations.
B. Create multiple alarm metrics.
C. Create a single alarm for each metric.
D. Select the correct alarm interval for your metric.
E. Routinely tune your alarms.
F. Use a single interval for all alarms.
Question No : 85) In which four ways can Oracle Database optimally access data in Object Storage?
A. optimized data archive using partitioned external tables
B. optimized data archive using hybrid partitioned tables
C. scan avoidance using block skipping when reading parquet and ore files
D. scan avoidance using columnar pruning for columnar stores like parquet and orc
E. scan avoidance using partitioned external tables
F. scan avoidance using columnar pruning for .csv files
Question No : 86) 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
Question No : 87) Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?
A. Oracle Cloud Infrastructure Object Storage
B. Google Cloud Storage
C. Amazon S3
D. Oracle Cloud Infrastructure Object Storage Classic
Question No : 88) What happened with the standby database when disabling Autonomous Data Guard?
A. The standby database is started readwrite
B. The standby database is transformed in a refreshable clone
C. The standby database is terminated
D. The standby database is started read only
Question No : 89)
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
Question No : 90) Which four file formats are supported when loading data from Cloud Storage?
A. DOC
B. AVRO
C. JSON
D. DDL
E. Dcsv
F. Parquet
1z0-931-24 Answers