Free Preparation Discussions
MENU
Oracle Exam 1Z0-076 Topic 7 Question 32 Discussion
Topic #: 7
You must design an Oracle Data Guard configuration for a DSS database that meets these permanent
requirements:
1. Creating and maintaining bitmap indexes should not impact the performance of the primary database.
2. Creating and maintaining materialized views should not impact the performance of the primary database.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest of databases?
Logical standby databases allow the execution of DDL and DML operations, which makes them suitable for maintaining bitmap indexes and materialized views without affecting the performance of the primary database .
Logical standby databases can be used for performing rolling upgrades and patching with minimum downtime, meeting another requirement .
They also enable the testing of new application software releases against an up-to-date replica of the primary database, fulfilling the last requirement.
Other configurations involving physical standby databases or combinations of logical and physical standby databases might not meet all the specified requirements as efficiently or with the same level of performance isolation for the primary database.
Currently there are no comments in this discussion, be the first to comment!