1Z0-931-22 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

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

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.

What are three methods to load data into the Autonomous Database?

A. Oracle GoldenGate

B. Transportable Tablespace

C. RMAN Restore

D. Oracle Data Pump

E. SQL*Loader

When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?

A. Scan partition tables

B. scan hybrid partition tables

C. prun column in parquet files

D. prun columns in csv files

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.

Which native data type is used to store spatial information?

A. SDO_RELATE

B. SDO_GEOMETRY

C. SDO_LOCATION

D. GEO_JSON

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'