1z0-931 Free 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?

1. A. MEDIUM
2. B. TP
3. C. HIGH
4. D. TPURGENT

Correct Answer: C

Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low.
Which statement about these consumer groups is correct?

1. A. High provides highest concurrency and lowest resources, and DoP is i.
2. B. Medium provides intermediate resource and concurrency, and queries run in a serial.
3. C. High provides highest resources, lowest concurrency, and DoP is 1.
4. D. Low provides highest concurrency, lowest resources, and DoP =1.

Correct Answer: D

Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import.
Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading?

1. A. SQL Developer can only export/move/import files using datapump from databases running on Linux systems.
2. B. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.
3. C. SQL Developer can be used to export/move/import of a database to ADB in l set of wizard steps.
4. D. SQL Developer can be started from the ADB Cloud console but only for data loading scenarios.
5. E. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.

Correct Answer: ABD

Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's?

1. A. Create, Query, Update, List, Start
2. B. Create, Query, List, Stop, Restore
3. C. Create, Get, List, Stop, Restore
4. D. Start, Delete, Update, Query, Stop

Correct Answer: B

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

Correct Answer: D