1z0-076 Exam Question 6

A customer asks for your recommendation regarding this requirement:
1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.
2. We want zero data loss in case of a disaster involving the loss of one component.
3. We want to do Real Application Testing occasionally on the Standby Database.
Which solution, if any, satisfies these requirements?
  • 1z0-076 Exam Question 7

    Which TWO are benefits of using Transaction Guard in a Data Guard environment?
  • 1z0-076 Exam Question 8

    Your Data Guard environment contains a four-instance RAC primary database whose SID is PROD and a RAC physical standby database whose std is PROD_SBY.
    Examine the command executed on a node of the primary database cluster to create a service OLTPWORKLOAD that the applications will use to connect to the database when it is in the FRlMARYTclatabase role:
    srvctl add service -db PROD -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150 The service is then started Consider this list of tasks:
    1. On a node of the standby database cluster execute:
    srvctl add service -db PROD_SBY -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150
    2. On the primary database, create the oltpworkload database service using the dbms_service.create_service procedure.
    3. Configure tap for clients in the tnsnames.ora files.
    4. Make sure clients use the OLTPWORKLOAD service to connect to the database instances.
    5. On the standby database, create the oltpworkload database service using the dbms_service.create_servi;l procedure.
    Identify the required steps to configure and use Transparent Application Failover (taf).
  • 1z0-076 Exam Question 9

    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?
  • 1z0-076 Exam Question 10

    Which two are true concerning the configuring of Flashback database in a Data Guard environment?