Online Access Free 1Z0-931 Practice Test

As a database architect you are tasked with configuring a high concurrency, production OLTP 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.HIGH
• B.TP
• C.TPURGENT
• D.MEDIUM

When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?

• A.CWALLET.SSO
• B.OJDBC.PROPERTIES
• C.SQLNET.ORA
• D.TNSNAMES.ORA

A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back.
Which statement about the migration using Golden Gate is correct?

• A.The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.
• B.Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.
• C.Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this.
• D.Only the migration to ADB is possible from an on-premise installation of Golden Gate.
• E.The described scenario is correct, can be used for migration and fallback scenarios.

Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?

• A.18.1 onwards
• B.Any version
• C.17.4 onwards
• D.12c Release 2 onwards

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?

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