Free Oracle Database 19c: Data Guard Administration Exam 1Z0-076 Exam Practice Test

Which THREE statements are true about snapshot standby databases?

• A snapshot standby database may be opened read-only.
• FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled.
• FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled.
• A snapshot standby database can have Real-Time apply enabled.
• A snapshot standby database may be opened read-write.
• FLASHBACK DATABASE must be manually enabled on a physical standby database before converting it into a snapshot standby database.

You created two remote physical standby databases using SQL and RMAN.The primary database is a four-instance RAC database and each physical standby database has two instances.Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.Consider these operational requirements:The ability to manage multiple standby databases with a single toolThe simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databasesThe automation of failovers to a specified target standby database Which TWO tools can be used to fulfill these requirements7

• RMAN
• SQL*Plus
• CRSCTL
• Enterprise Manager Cloud Control
• DGMGRL
• SRVCTL
• GDCCTL

Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

• You can monitor the redo apply rate on a logical standby database.
• You can set a critical threshold on the redo generation rate metric for a primary database.
• You can set a warning threshold on the redo generation rate metric for a physical standby database.
• You can check if redo apply needs to be tuned.
• You can check the potential data loss in the event of a disaster.
• You can monitor the redo apply rate on a snapshot standby database.

You are using Data Guard in conjunction with Global Database Services.You have a Data Guard Broker configuration called Sales and a GDS pool called Prod.Which three are true concerning the management of the broker configuration when using GDS?

• DGMGRL may be used to add the Sales configuration to the Prod pool in gds.
• Performing a role change with DGMGRL automatically notifies GDS which in turn activates the appropriate services.
• DGMGRL may be used to add a single database to the Sales configuration even if Sales is a member of the Prod pool.
• Adding a database to the Sales configuration with DGMGRL automatically adds the database to the Prod Pool.
• Adding a database to the Sales configuration with DGMGRL requires that the Sales configuration be disabled first. It must then be enabled after the new database is added to the configuration.

A customer has these requirements for their proposed Data Guard implementation:

• Zero data loss must still be guaranteed through the loss of any one configuration component.
• The primary database must be protected against a regional disaster.
• Performance overheads on the primary should be minimized as much as possible given these requirements.
• Downtime on the primary database for any reason must be kept to a minimum. Components referred to in the broker commands are:
• B)C)D)
• Option A
• Option B
• Option C
• Option D

Which THREE statements are TRUE about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

• Their usage will always have a performance impact on the primary database.
• Their creation requires that a LOG archive_dest_n parameter be defined in the standby that points back to the primary.
• If the CACHE option is set then the size of the cache must be at least 100.
• Their usage may have a performance impact on the physical standby database if the CACHE size is too small.
• They must have the NOORDEK and CACHE options set.

You must configure on Oracle Data .......

• A primary database
• Three Physical Standby Databases Examine these requirements:
• A designated physical standby database should become the primary database automatically whenever the primary database fails.
• The chosen protection mode should provide the highest level of protection possible without violating the other requirement.Which redo transport mode and protection mode would you configure to meet these requirements?
• FASTSYNC and Maximum Protection
• ASYNC and Maximum Performance
• FASTSYNC and Maximum Availability
• SYNC and Maximum Protection

Which TWO statements are true about Real-Time Query?

• Setting standby_max_data_delay=0 requires synchronous redo transport.
• Real-Time Query has no limitations regarding the protection level of the Data Guard environment.
• Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby databases opened read only.
• Real-Time Query sessions can be connected to a Far Sync instance.
• A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the
• Data Guard configuration.

Which four requirements can be met by deploying a logical standby database?

• Support for workloads requiring additional materialized views.
• It must have the same physical structure as the primary database.
• It can be used to create additional tables.
• It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
• It can be used for Real Application Testing without affecting the disaster recovery capabilities.
• Support for workloads requiring additional indexes.
• It can be used to create additional schemas.

Which four statements are true regarding SQL Apply filters for a logical standby database?

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