Oracle Autonomous Database Cloud 2020 Specialist

Question 1

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?

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

B. Oracle Data Safe only supports Autonomous Databases.

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

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

Correct Answer: B

Question 2

Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

A. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.

B. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.

C. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.

D. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.

Correct Answer: C

Question 3

Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

A. RMAN backup & restore

B. Physical migration method like database cloning

C. Original Import/Export tools

D. Data Pump

Correct Answer: D

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

Question 4

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

A. The SQL statement did not complete either due to an error.

B. The SQL statement is executing.

C. The SQL statement is queued.

D. The SQL statement completed its execution.

Correct Answer: C

Question 5

As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?

A. TPURGENT

B. HIGH

C. TP

D. MEDIUM

Correct Answer: A

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

Question 6

Which statement is true when the Autonomous Database has auto scaling enabled?

A. Scales the PGA and SGA size when needed for the workload.

B. Increases the number of sessions available to the database.

C. Database concurrency is scaled up when needed by the workload.

D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

Correct Answer: D

Question 7

What is the default retention period for both Automatic and Manual Autonomous Database Backups?

A. 7 days

B. 30 days

C. 90 days

D. One Year

E. 60 days

Correct Answer: E

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

Question 8

When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

A. Schemas

B. Reports

C. Tablespaces

D. Data

Correct Answer: A,D

Question 9

Given the steps:
1. Create Oracle Machine Learning User
2. Create projects
3. Create workspaces
4. Create Notebooks
5. Run SQL Scripts
Which two steps are out of order when working with Oracle Machine learning? (Choose two.)

A. Create Notebooks

B. Create workspaces

C. Create Oracle Machine Learning User

D. Create projects

E. Run SQL Scripts

Correct Answer: D,E

Question 10

According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.
Which statement is true?

A. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

B. Create a separate VCN that contains only public subnets

C. Only 1 of each is allowed to be allocated per environment.

D. Create at least 2 of each resource

Correct Answer: A

Oracle Autonomous Database Cloud 2020 Specialist - 1Z0-931-20 Exam Practice Test

Latest Update

Useful Links

Contact Us