Oracle Autonomous Database Cloud 2023 Specialist (1z0-931-23) Free Practice Test

Question 1

A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.
When restoring/cloning the ADB, you must select a backup which is atleast___ hours/minutes old.

A. 5 min

B. 24 hrs

C. 1 day

D. 2 hrs

Correct Answer: B

Question 2

Your company has a .NET application and wants to deploy it on Autonomous Database (ADB). What software is used to connect to ADB from the .NET application?

A. SQL*Plus

B. Java

C. You cannot use .NET with ADB.

D. Oracle Data Access Components for Windows

Correct Answer: D

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

Question 3

You are the admin user of an Autonomous Database instance. A new business analyst has joined the team and could like to explore the Autonomous Database tables using Autonomous Database's Data Tools.
Which step should you to perform to enable the new team member?

A. Create a database user with the default privileges

B. Create a database user with connect, resource, and object privileges

C. Create a REST-enabled database user (with connect and object privileges) and grant the U DWROLE role

D. Create an IDCS user Create a database user with connect, resource, and object privileges

Correct Answer: A

Question 4

An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.
Other than changing the shared user password, what can the admin do to protect the instance?

A. Trust the user who left to not access the database.

B. Shutdown and restart the instance.

C. Delete the user.

D. Rotate the instance wallet and share the new wallet with the remaining users.

Correct Answer: D

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

Question 5

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

A. Parquet

B. JSON

C. CSV

D. AVRO

E. DOC

F. DDL

Correct Answer: A,B,C,D

Question 6

Which two are correct actions to take in order to Download the Autonomous Database Credentials?

A. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.

B. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.

C. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.

D. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.

E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

Correct Answer: C,E

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

Question 7

You enabled Autonomous Data Guard on Autonomous Database on Shared Infrastructure.
Which three statements are true about the standby database after a failover?

A. Autonomous Data Guard automatically reverts to the primary database when it becomes available again

B. A new wallet is required to connect to the standby database

C. Oracle Machine Learning Notebooks created in the primary database are available in the standby database

D. The OCPU Count, Storage, Display Name, Database Name, Auto Scaling, Tags, and Licensing options have the same values as the primary

E. Autonomous Data Guard automatically creates a new standby database

Correct Answer: C,D,E

Question 8

A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data.
How does the developer connect to and interact with ADB from Python?

A. You can't use Python with ADB.

B. The Oracle Client and the cx_Oracle interface for Python

C. SQL Developer

D. JAVA JDK

Correct Answer: B

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

Question 9

Which statement is true about OCPUs and storage when you choose to scale your Autonomous Database?

A. Increasing OCPUs will automatically increase storage

B. OCPUs and storage can be scaled independently

C. Use auto scaling to increase storage

D. OCPUs and storage must remain in sync

Correct Answer: B

Question 10

Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?

A. Oracle Cloud Infrastructure Object Storage Classic

B. Amazon S3

C. Oracle Cloud Infrastructure Object Storage

D. Google Cloud Storage

Correct Answer: D

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

Welcome to TestSimulate

Oracle Autonomous Database Cloud 2023 Specialist (1z0-931-23) Free Practice Test