1z0-931-20 Free Practice Test

Which statement is true when the Autonomous Database has auto scaling enabled?

1. A. Database concurrency is scaled up when needed by the workload.
2. B. Increases the number of sessions available to the database.
3. C. Scales the PGA and SGA size when needed for the workload.
4. D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

Correct Answer: D

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

1. A. Release Update (RU)
2. B. Prior Release Update Revision (PRUR)
3. C. Prior Release Update (PRU)
4. D. Quarterly Bundle Patch (QBP)

Correct Answer: A

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?

1. A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
2. B. ADW since operational reporting is a higher priority in this scenario.
3. C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
4. D. AT
5. E. Using 'tpurgent' and 'high' TNS services to separate connection types.

Correct Answer: D
Autonomous Transaction Processing provides all of the performance of the market leading Oracle Database in an environment that is tuned and optimized to meet the demands of a variety of applications, including: mission-critical transaction processing, mixed transactions and analytics, loT, and JSON document store.
As a service Autonomous Transaction Processing does not require database administration. With Autonomous Transaction Processing you do not need to configure or manage any hardware, or install any software. Autonomous Transaction Processing handles creating the database, backing up the database, patching and upgrading the database, and growing or shrinking the database.

When enabling auto-scaling, which three options do not change?

1. A. Number of OCPUs displayed in the console.
2. B. Amount of storage
3. C. I/O resources
4. D. parallelism settings
5. E. Level of concurrency

Correct Answer: DE

Which statement is NOT correct when setting up compartment quotas?

1. A. There are three types of quota policy statements which are set, unset and zero.
2. B. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
3. C. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
4. D. Compartment quotas are set by Oracle.

Correct Answer: C