Which four requirements can be met by deploying a logical standby database?
A.
Support for workloads requiring additional indexes.
B.
It can be used to create additional schemas.
C.
It can be used to create additional tables.
D.
It must have the same physical structure as the primary database.
E.
it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
F.
Support for workloads requiring additional materialized views.
G.
It can be used for Real Application Testing without affecting the disaster recovery capabilities.
Explanation:
A: DDL Statements supported by a Logical Standby Database include:
ALTER INDEX
CREATE INDEX
DROP INDEX
C: DDL Statements supported by a Logical Standby Database include:
CREATE TABLE
DROP TABLE
Incorrect Answers:
D: The physical organization in a logical standby database is different from that of the primary database, even though the logical standby database is created from a
backup copy of the primary database.
F: DDL Statements not supported by a Logical Standby Database include:
CREATE MATERIALIZED VIEWhttps://docs.oracle.com/cd/E11882_01/server.112/e41134/create_ls.htm#SBYDB4731
https://docs.oracle.com/cd/B28359_01/server.111/b28294/data_support.htm
A key benefit of logical standby is that significant auxiliary structures can be created to optimize the reporting workload; structures that could have a prohibitive impact on the primary’s transactional response time. A logical standby can have its data physically reorganized into a different storage type with different partitioning, have many different indexes, have on-demand refresh materialized views created and maintained, and can be used to drive the creation of data cubes and other OLAP data views.
A,B,C,F
A,B,C,F
G: RAT could change data, so no DRP anymore
D: by design
A, B, C, F
Additional Schemas can be added (just google for steps needed)
E: Not all datatypes are supported – so not all data is protected
F: “Logical Standby supports the creation and maintenance of new materialized views locally on the logical standby database in addition to other kinds of auxiliary data structure.”
“Materialized views that denormalize the replicated data for more efficient query support on the logical standby database can be created (…)”
https://docs.oracle.com/database/121/SBYDB/manage_ls.htm#SBYDB4833
A,B,C,F