1Z0-931-21 Online Practice Questions and Answers

Which four file formats are supported when loading data from Cloud Storage?

A. DOC

B. AVRO

C. JSON

D. DDL

E. Dcsv

F. Parquet

You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.

Which tool would you use to automate data exploration and create pivot tables?

A. Business Models

B. Data Load

C. SQL Developer Web

D. APEX

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 Solutionsand Platform then Platform Services then Autonomous Exadata

C. Under Database then Autonomous Transaction Processing then Autonomous Exadata

D. Under Core Infrastructure then Autonomous Exadata

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. Routinelytune your alarms.

F. Use a single interval for all alarms.

What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

A. Users have OS access to the database machine.

B. Users can customize the maintenance schedule.

C. It offers greater control and isolation starting at theExadata cloud infrastructure level.

D. Users have SYS privileges in the database.

E. Users can customize the OS stack and add additional packages

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'

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'.

Which statement is not correct when the Autonomous Database is stopped?

A. In-flighttransactions 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

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

Which two statements are true about Data Insights?

A. You can retrieve previously executed Data Insights searches.

B. Data Insights is available with on-premises deployments of Oracle Database.

C. Data Insights is an additional priced option.

D. You can search for Data Insights against a base table or business model.