Oracle Autonomous Database Cloud 2024 Professional - 1Z0-931-24 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and create pivot tables?

A. Data Load B. Business Models C. SQL Developer Web D. APEX

Discussion 0

Correct Answer: A Vote an answer

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

Question 2

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

A. Load data using Data Pump B. Import Table C. Create a Data Set D. Replicate the table using Golden Gate

Discussion 0

Correct Answer: C Vote an answer

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

Question 3

What REST verb is used to create an Autonomous Database service using REST APIs?

A. A "PUT" REST call B. A "GET" REST call C. A "POST" REST call D. An "INSERT" REST call

Discussion 0

Correct Answer: C Vote an answer

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

Question 4

Which option should you use to create a graph with Graph Studio?

A. A graph license key B. Graph analytics algorithms C. NoSQL configuration D. Graph created by a special tool downloaded from oracle.com E. Tables in an Autonomous Database instance

Discussion 0

Correct Answer: E Vote an answer

Question 5

Which two statements are true about using an Oracle Autonomous Database with private endpoints?

A. You can configure private endpoints for an Always Free Autonomous Database B. Private endpoints can be configured when you clone an Autonomous Database on Shared Infrastructure that was initially created with public endpoints C. An Autonomous Database with private endpoints can be accessed from the public Internet by adding your IP address to an Access Control List (ACL) D. A Network Security Group (NSG) is required within your virtual cloud network before you can provision a Shared Autonomous Database to use private endpoints

Discussion 0

Correct Answer: B,D Vote an answer

Question 6

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

A. The target table will be created in Autonomous Database if it does not already exist. B. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store. C. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage. D. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure. E. The source file will be automatically removed after the DBMS_CLOUCOPY_DATA procedure finishes successfully.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question 7

You have been tasked with analyzing a year's worth of sales data stored in an Autonomous Data Warehouse instance.
Which tool would you use to automate data exploration and create pivot tables?

A. Data Load B. Business Models C. SQL Developer Web D. APEX

Discussion 0

Correct Answer: B Vote an answer

Question 8

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

A. 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. B. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory. C. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter. D. 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.

Discussion 0

Correct Answer: D Vote an answer

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

Question 9

What can you do with graphs? (Choose two)

A. 3-D modeling B. Facial recognition C. Find patterns that are anomalous and use that to detect fraud. D. Product recommendations

Discussion 0

Correct Answer: C Vote an answer

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