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

出題：1

Which two statements are true regarding Data Guard environments in an Oracle Muti-tenant architecture?

A. Different redo transport methods can be configured for different pluggable databases within one Data Guard environment.

B. A Data Guard environment with a multi-tenant primary database can operate in any Protection mode.

C. Standby redo log files are required for each pluggable database that is protected with Data Guard.

D. The Data Guard broker may be used for multi-tenant databases.

E. PDB_FILE_NAME CONVERT must be set to enable creation of standby databases if they are created on the same host as the primary.

正解：B,D 解答を投票する

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

出題：2

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?

A. A physical standby database with synchronous redo transport that can be converted regularly into a snapshot standby to do real application testing

B. A far sync instance plus a snapshot standby database and real time apply that can be converted regularly into logical standby database to do real application testing

C. A snapshot standby database with real time query that can be converted regularly into a physical standby database open read write, to do real application testing

D. These requirements cannot be met.

正解：A 解答を投票する

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

出題：3

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 メンバーにのみ表示されます)

出題：4

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

A. You can check if redo apply needs to be tuned.

B. You can monitor the redo apply rate on a logical standby database.

C. You can check the potential data loss in the event of a disaster.

D. You can set a critical threshold on the redo generation rate metric for a primary database.

E. You can monitor the redo apply rate on a snapshot standby database.

F. You can set a warning threshold on the redo generation rate metric for a physical standby database.

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

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

出題：5

Which TWO statements are true about Real-Time Query?

A. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.

B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby databases opened read only.

C. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.

D. Setting standby_max_data_delay=0 requires synchronous redo transport.

E. Real-Time Query sessions can be connected to a Far Sync instance.

正解：B,D 解答を投票する

解説: (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

In Oracle Database 19c, you can set the value of database initialization parameters in a database using the EDIT DATABASE... SET PARAMETER Command:
DGMGRL> EDIT DATABASE 'boston' SET PARAMETER log_archive_trace - 1;
Which THREE statements are TRUE about the command?

A. The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.

B. The value set using this command is directly applied to the boston database.

C. The database must be available when the above command is run.

D. The value set using this command is directly stored in the broker configuration file.

E. The edit database parameter command can only be used to modify the value of a dynamic parameter in a database.

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

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

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