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.Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
• D.Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

Comment: *

Name: *

Email: *

Verification: *

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)

• A.DBNAME_MEDIUM
• B.DBNAME_HIGH
• C.DBNAME_CONCURRENT
• D.DBNAME_LOW

Comment: *

Name: *

Email: *

Verification: *

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

• A.Number of OCPUs displayed in the console.
• B.Amount of storage
• C.I/O resources
• D.parallelism settings
• E.Level of concurrency

Correct Answer: B,D,E

https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141

Comment: *

Name: *

Email: *

Verification: *

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.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.
• B.The base number of OCPU cores allocated to a database is not guaranteed.
• C.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.
• D.Auto scaling is enabled by default and can be enabled or disabled at any time.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Data Insights?

• A.You can search for Data Insights against a base table or business model.
• B.You can retrieve previously executed Data Insights searches.
• C.Data Insights is an additional priced option.
• D.Data Insights is available with on-premises deployments of Oracle Database.

Comment: *

Name: *

Email: *

Verification: *