1Z0-931-20 by Oracle Actual Free Exam Q&As

Question 1

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

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

Discussion 0

Correct Answer: D Vote an answer

Question 2

Which two system privileges does a user need to create analytic views? (Choose two.)

A. CREATE ANALYTIC HIERARCHY B. CREATE ANALYTIC MEASURE C. CREATE ATTRIBUTE DIMENSION D. CREATE ANALYTIC LEVEL E. CREATE ANALYTIC VIEW

Discussion 0

Correct Answer: C,E Vote an answer

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

Question 3

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

A. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default. B. Oracle Database Result Cache is enabled by default for all SQL statements. C. Parallelism is not enabled by default. D. You have direct access to the database node.

Discussion 0

Correct Answer: A,C Vote an answer

Question 4

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

A. TPPERFORMANT B. MEDIUM C. HIGH D. LOW E. TPURGENT

Discussion 0

Correct Answer: A Vote an answer

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

Question 5

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

A. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls. B. Connecting to the Cloud Infrastructure Command console via SSH wallet. C. It cannot be done. D. Using Database Configuration Assistant (DBCA) on the database server.

Discussion 0

Correct Answer: A Vote an answer

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

Question 6

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?

A. You cannot permanently disable scheduled Automatic Maintenance. B. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day. C. Change the Automatic Maintenance Schedule to 'No Preference'. D. Change the Automatic Maintenance Schedule to 'None'd.

Discussion 0

Correct Answer: B Vote an answer

Question 7

Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

A. Audit Vault B. Database Vault C. Customer Managed Keys D. Data Redaction E. Transparent Data Encryption

Discussion 0

Correct Answer: B,C,E Vote an answer

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

Question 8

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

A. One Year B. 30 days C. 7 days D. 90 days E. 60 days

Discussion 0

Correct Answer: E Vote an answer

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

Question 9

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

A. The OCI compute instance does not support connecting to a Shared Autonomous Database. B. A Private Endpoint is required to connect to the Shared-Autonomous Database. C. The OCI compute instance can be used with an Always-Free Autonomous Database account. D. The Autonomous Database must belong to a Network Security Group (NSG). E. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.

Discussion 0

Correct Answer: E Vote an answer

Question 10

You have provisioned an Autonomous Data Warehouse (ADW) database with 16 enabled OCPUs and need to configure the consumer group for your application.
Which two are true when deciding the number of sessions for each application? (Choose two.)

A. The HIGH consumer group can run up to 16 concurrent SQL statements in addition to 32 concurrent SQL statements in MEDIUM and LOW consumer group each B. The HIGH consumer group can run 3 concurrent SQL statements when MEDIUM consumer group has
0 SQL statements C. The MEDIUM consumer group can run 20 concurrent SQL statements when HIGH consumer group has 0 SQL statements D. The MEDIUM and LOW consumer group can run up to 16 concurrent SQL statements if HIGH consumer group has 0 SQL statements E. The HIGH consumer group can run up to 16 concurrent SQL statements as long as MEDIUM and LOW consumer groups have 0 SQL statements

Discussion 0

Correct Answer: B,C Vote an answer

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