1Z0-931-21 Exam Training Practice Tests (Oracle Autonomous Database Cloud 2021 Specialist)]

Question 1

Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?

A. The Autonomous Database must belong to a Network Security Group (NSG). B. The marketplace OCI image can be used with an Always Free Autonomous Database account. C. A Private Endpoint is required to connect to the Autonomous Database on shared Exadata infrastructure. D. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure. E. The Autonomous Database can only be in the same virtual cloud network (VCN) and subnet as the marketplace OCI image.

Correct Answer: E

Question 2

A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.
What should they do to remove this bottleneck?

A. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure. B. Remove any non-JSON data from the database. C. Ask Support to migrate their setup to a node without noisy neighbors. D. Increase the number of OCPUs allocated to the database.

Correct Answer: C

Question 3

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

A. Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous Database STOP END" B. Create a notification alert using DBMS_SNMP package C. Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database D. Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

Correct Answer: A

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

Question 4

Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand increases,
auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.
Which statement is FALSE regarding the auto scaling feature?

A. The base number of OCPU cores allocated to a database is not guaranteed. B. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meet high-load demands. C. Auto scaling is enabled by default and can be enabled or disabled at any time. D. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.

Correct Answer: A

Question 5

You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.
What statement describes the step to provide the developer a new workspace in APEX?

A. Create an IDCS user with the APEX role. B. Create a new developer account. C. Create a database user with the APEX role. D. Access the APEX Administration Services and create the workspace for the developer.

Correct Answer: D

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

Question 6

Which statement is FALSE about Oracle Autonomous JSON Database?

A. There is a 20 GB limit on JSON collection B. It supports NoSQL-style, document-centric application C. JSON data is stored natively in the database D. You can promote Autonomous JSON Database to Autonomous Transaction /Processing

Correct Answer: A

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

Oracle Autonomous Database Cloud 2021 Specialist - 1Z0-931-21 Exam Practice Test