1z1-076試験無料問題集（72題）「Oracle Database 19c: Data Guard Administration 認定」

出題：1

Suppose that you manage the following databases in your environment:
* boston: Primary database with a single PDB called DEVI
* london: Physical standby database protecting the PDB called DEVI
* orcl: Stand-alone database with a single PDB called PDB1 as a remote clone source You are planning to run the following command to create a remote clone in the primary database (boston) using pdbi in orcl:
Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (london)?

A. Set STANDBY_FILE_MANAGEMENT to auto in the london database.

B. Open PDBI (remote clone source) in Read Only.

C. Set STANDBY_PDB_SOURCE_FILE_DIRECTORY to <location of the PDB> in the london database.

D. Enable Active Data Guard in the _ondon database.

E. Set standby_pdb_source_file_dblink to clone_link in the london database.

F. Open PDBI (remote clone source) in Read Write.

正解：A,B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Which three types of backups offload ........ with the primary database in a data Guard

A. Control files

B. Password files

C. Data files

D. Archive logs

E. Broker configuration files

F. Online logs

正解：A,C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

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?

A. a primary database with one logical standby database

B. a primary database with one physical standby database

C. a primary database with two logical standby databases

D. A primary database with one logical and one physical standby database

E. a primary database with two physical standby databases

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which THREE steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

A. Establish user equivalence for the database software owner between the primary host and standby host.

B. Put the primary database into archivelog mode.

C. startup nomount the standby database instance.

D. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME name parameter.

E. Configure Oracle Net connectivity on the primary host to the standby database instance.

正解：A,C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Your Data Guard environment contains a primary database and three standby databases with these attributes:
1. prod : Primary database
2. prod_prq : Physical standby database with real-time query enabled used by reporting applications
3. prod_lsby: Logical standby database used by DSS
4. PROD_SSBY: Snapshot standby database used for Real Application Testing Which TWO can be used to prevent clients from connecting to the wrong database instance?

A. Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.

B. Establish Oracle Net connectivity to the primary database instance from all the standby database instances.

C. Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.

D. Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.

E. Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.

正解：A,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

You created a physical standby database prodsbyi from the primary database prod using SQL and RMAN.
Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases?

A. The primary database must have supplemental logging enabled.

B. The DG_BROKER_START parameter must be set to TRUE for both database instances.

C. A local net service name to enable connectivity to the PRODSBYI database instance must be defined on the primary database host.

D. The LOG_ARCHIVE_DEST_n parameters with the service attribute set must be cleared.

E. The primary database must have FORCE LOGGING enabled.

F. The standby database must have supplemental logging enabled.

正解：A,B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Which THREE are always benefits of using a logical standby database?

A. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.

B. It can be used for database rolling release upgrades.

C. It can be used for reporting workloads requiring additional indexes or materialized views or both.

D. It can be used for testing patchsets without affecting the primary database.

E. It can be used as an updatable database for Real Application Testing and then converted back to a standby database without affecting the updates.

F. It can be used to replicate a single pluggable database (PDB) in a multitenant container database.

正解：A,B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1z1-076試験無料問題集「Oracle Database 19c: Data Guard Administration 認定」