Oracle 1Z1-066 valid exam dumps : Oracle Database 12c: Data Guard Administrator

A customer asks you to propose the most appropriate solution for this set of requirements:
1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. Developers may need to test occasionally on a copy of the live database.
You have already confirmed that there are no unsupported data types on the primary database.
Which two solutions would you recommend? (Choose two.)

• A. a remote physical standby database with RedoRoutes via a far sync instance
• B. a read mostly implementation of a physical standby database
• C. a snapshot standby database with synchronous redo transport
• D. a physical standby database with real-time query enabled
• E. a logical standby database

Which three statements are true about Data Guard configurations? (Choose three.)

• A. Up to 30 physical standby databases may exist within one configuration.
• B. When using the Data Guard Broker, an spfile is not required.
• C. The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread.
• D. For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
• E. VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.
• F. All databases in one Data Guard environment must have the same database name.

Which four statements are true regarding SQL Apply filters for a logical standby database? (Choose four.)

• A. They can be used to skip ALTER TABLE commands on a specific tables.
• B. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).
• C. They can be used to skip CREATE TABLE commands.
• D. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands.
• E. They can only be used to skip DML statements on a table.
• F. They can be used to stop SQL apply if it encounters an error.
• G. They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

Which three are among the various tasks performed by the Data Guard Monitor (DMON) process? (Choose three.)

• A. performing role transitions when switchover requests are made
• B. communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required.
• C. maintaining information about all members of the broker configuration in binary configuration files
• D. activating role-based services appropriately in the various database instances of the configuration, based on the database role
• E. communicating with DMON processes in other database instances that are part of the broker configuration

Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which will fulfill this requirement?

• A. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
• B. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
• C. Set the DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.
• D. Create a database service on each standby database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.