ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-931 All Questions

View all questions & answers for the 1z0-931 exam
Go to Exam

Exam 1z0-931 topic 1 question 38 discussion

Actual exam question from Oracle's 1z0-931
Question #: 38
Topic #: 1
[All 1z0-931 Questions]

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. MEDIUM
  • D. TPURGENT
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Reference:
https://github.com/oracle/cloudtestdrive/blob/master/ATP/LabGuideOSC200Connect.md
by victor007 at June 20, 2020, 12:06 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
sri882
4 years, 7 months ago
C IS RIGHT ANSWER TP NOT SUPPORTED PARALLESM.TPAGENT SUPPORT MANUAL PARALLESM
upvoted 1 times
adesmaster
4 years, 7 months ago
C is HIGH.... so the right is TPURGENT (D) not AGENT
upvoted 1 times
...
...
sebas880316
4 years, 8 months ago
D is right Answer
upvoted 2 times
...
Prhira85
4 years, 9 months ago
D is the right answer tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism. tp: A typical application connection service for transaction processing operations. Queries run serially. high: A high priority application connection service for reporting and batch operations with low concurrency requirements. All operations run in parallel (if you have multiple OCPU assigned to your instance) and are subject to queuing. medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. low: A lowest priority application connection service for high concurrency reporting or batch processing operations. Queries run serially.
upvoted 4 times
...
ecc_ar
4 years, 9 months ago
D, TP urgent run manual parallelism, highest priority, and unlimited concurrency.
upvoted 2 times
...
Midou
4 years, 9 months ago
Ans D TP is run in serial, only valid answer is then TPURGENT because the DB is OLTP.
upvoted 4 times
...
Scunningham99
4 years, 9 months ago
Correct answer is a high parallelism
upvoted 1 times
...
Alejandro333
4 years, 10 months ago
why is not the A???????
upvoted 1 times
n00pster
4 years, 9 months ago
A has low concurrency.
upvoted 1 times
...
...
victor007
4 years, 10 months ago
C is right answer
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago