Oracle Autonomous AI Database Professional - 1Z0-931-26 Exam Practice Test

Question 1

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

A. Autonomous Data Warehouse only

B. ATP and ADW

C. Hybrid Columnar Compression

D. Autonomous Transaction Processing only

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 2

How many Network Security Groups (NSGs) can you configure for an Autonomous Database?

A. 9

B. 5

C. 7

D. 3

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 3

Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose three.)

A. Suppress alarms during investigations

B. Routinely tune your alarms

C. Create multiple alarm metrics

D. Select the correct alarm interval for your metric.

Correct Answer: A,B,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?

A. JSON

B. Data Insight

C. Data Load

D. Catalog

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 5

When integrating object storage with Autonomous Database, how effectively does Oracle use the files in the object storage?

A. Scan partition tables

B. Prune columns in parquet files

C. Prune columns in CSV files

D. Scan hybrid partition tables

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 6

Which two statements are true regarding active transactions when scaling OCPUs in an Autonomous Database? (Choose two.)

A. Active transactions are paused

B. Scaling can happen while there are active transactions in the database

C. Active transactions continue running unaffected

D. Active transactions are terminated and rolled back

Correct Answer: B,C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 7

Which Autonomous Database Cloud Service ignores hints in SQL statements by default?

A. Neither service ignores hints by default

B. Autonomous Transaction Processing

C. Both services ignore hints by default

D. Autonomous Data Warehouse

Correct Answer: D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 8

You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements: Autonomous Transaction Processing, License Included, Shared Infrastructure. Which parameter would you NOT use?

A. db-type

B. license-model

C. db-workload

D. is-dedicated

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 9

Your customer has upgraded their on-premises 11.2 Database to 12.2. During this migration, the database was migrated to a pluggable database (PDB) and is now in production. How should the customer unplug their database to migrate to an Autonomous Database?

A. PDBs cannot be migrated to an Autonomous Database using plug, unplug, or clone.

B. Create a database link from the source database to the Autonomous Database environment and clone the PDB.

C. Unplug into an XML file so that the database and XML files can be uploaded to Object Storage.

D. Unplug into a PDB archive, which can be uploaded to Object Storage.

Correct Answer: A

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 10

Which two statements are true about using an Oracle Autonomous Database with private endpoints? (Choose two.)

A. You can configure private endpoints for an Always Free Autonomous Database

B. An Autonomous Database with private endpoints can be accessed from the public internet by adding your IP address to an Access Control List (ACL).

C. Private endpoints can be configured when you clone a shared Autonomous Database that was initially created with public endpoints.

D. A Network Security Group is required within your Virtual Cloud Network before you can provision a shared Autonomous Database to use private endpoints.

Correct Answer: C,D

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 11

Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. Which statement is FALSE for Oracle Data Safe?

A. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary

B. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user

C. Oracle Data Safe only supports Autonomous Database

D. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations

Correct Answer: C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 12

You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism. Which service will you need to connect to?

A. LOW

B. TPURGENT

C. TP

D. MEDIUM

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Oracle Autonomous AI Database Professional - 1Z0-931-26 Exam Practice Test

Latest Update

Useful Links

Contact Us