Online Access Free 1z0-931-23 Practice Test

As a database architect, you are tasked with configuring a high concurrency, production OLTP (online transaction processing) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?

• A.TP
• B.TPURGENT
• C.HIGH
• D.MEDIUM

Which three operations are available for a quarterly maintenance update on Autonomous Container Database?

• A.Reschedule patching
• B.Patch immediately
• C.Skip patching
• D.Reschedule and patch immediately
• E.Apply a partial patch

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

• A.Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
• B.Autonomous Data Warehouse workloads are optimized for mixed workloads.
• C.Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
• D.Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

• A.It is enabled by default.
• B.You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
• C.You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
• D.The indexing feature is implemented as an automatic task that runs at a fixed interval.
• E.Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

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

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