Oracle Autonomous Database Cloud 2019 Specialist (1Z1-931) Free Practice Test

Question 1

Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)

A. Data Loading

B. Application User Creation

C. Database Upgrades

D. Backups

E. Firmware Patching

Correct Answer: C,D,E

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

Question 2

Which is NOT required to connect to Autonomous Database from SQL developer?

A. Wallet file

B. Database name

C. Service name

D. Username and password

Correct Answer: B

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

Question 3

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 in Oracle 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.

Correct Answer: B,C

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

Question 4

The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?

A. UPDATE_OBJECT_INFO

B. CREATE_BASELINE_TEMPLATE

C. MODIFY_SNAPSHOT_SETTINGS

D. MODIFY_BASELINE_WINDOW_SIZE

Correct Answer: C

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

Question 5

Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)

A. Users are given OS logons or SYSDBA privileges to prevent phishing attacking.

B. Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.

C. Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.

D. Data is encrypted at rest using transparent data encryption.

Correct Answer: B,C,D

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

Question 6

A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.
Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

A. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

B. ADW since operational reporting is a higher priority in this scenario.

C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.

D. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.

Correct Answer: A

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

Question 7

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

A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.

B. Unplug into a pdb archive which can be uploaded to object storage.

C. Unplug to an xml file so database files and xml file can be uploaded to object storage.

D. Create a database link from source database to the ADB environment and clone the PDB.

Correct Answer: A

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

Welcome to TestSimulate

Oracle Autonomous Database Cloud 2019 Specialist (1Z1-931) Free Practice Test