You plan to create a database by using the Database Configuration Assistant (DBCA), with the
following specifications:
Applications will connect to the database via a middle tier.
The number of concurrent user connections will be high.
The database will have mixed workload, with the execution of complex BI queries scheduled at
night.
Which DBCA option must you choose to create the database?
A.
a General Purpose database template with default memory allocation
B.
a Data Warehouse database template, with the dedicated server mode option and AMM
enabled
C.
a General Purpose database template, with the shared server mode option and Automatic
Memory Management (AMM) enabled
D.
a default database configuration
Explanation:
http://www.oracledistilled.com/oracle-database/administration/creating-a-databaseusing-database-configuration-assistant/
C
Sayed why is C and not B correct? It’s obvious that A and D can not fullfill the requieremets.
Thanks
Why not B:
> The number of concurrent user connections will be high.
“dedicated server mode” as stated in B is not the best option for that requirement.
I have checked C and on my fail feedback objectives for which i anwsered incorrectly i have: Manage database design templates by using DBCA
Answer C: a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
Applications will connect to the database via a middle tier: This More over Middleware component like WebLogic , WebSphere or any other middleware tool – Mostly for Transactional Application ( OLTP)
The number of concurrent user connections will be high : OLTP ( Default/General Purpose DB is for high transnational application / for high #connections/users (Login from Middleware – Or might be suing connection pooling in Middleware component)
The database will have mixed workload, with the execution of complex BI queries scheduled at
night. : There are some adhoc or daily to door reports runs in OLTP, also might be some kind of data transfer from OLTP to DW (reporting)
C
Sorry Antilope……I did not get back to this site for a long….however I believe you have got the answer from others above
C
C
C