[Q45-Q64] 認証トレーニング1Z0-947試験問題集テストエンジン [2025]

認証トレーニング1Z0-947試験問題集テストエンジン [2025]

2025年12月16日ガイド準備で1Z0-947試験合格

質問 # 45
How can you tell if GoldenGate has been configured for batch processing?

A. The SPECIALRUN parameter is in the GLOBALS parameter file
B. The SPECIALRUN parameter is in the Extract parameter file
C. The SPECIALRUN parameter is in the Replicat parameter file
D. There is a dedicated GoldenGate process called SPECIALRUN

正解：C

解説：
The SPECIALRUN parameter is used in the Replicat parameter file to configure batch-mode processing such as for initial loads or one-time replication. It disables checkpointing and allows processing of a specific data set without ongoing synchronization.

質問 # 46
Which of the following is a typical Oracle GoldenGate Manager parameter?

A. DiscardFile
B. ExtTrail
C. RmtHost
D. Port

正解：D

解説：
Port, DynamicPortList, Autostart, AutoRestart, Lag parameters, PurgeOldExtracts, and others. These can be found in the section titled "Manager Parameter Categories."

質問 # 47
You have a table that has a primary key as well as an additional unique key. Failing to consistently identify a row will result in an error during conflict resolution. Which option solves this?

A. Add unique indexes to the table to resolve the conflict.
B. Use the RESOLVECONFLICT feature to handle errors and resolve the conflict.
C. Use the SQLEXEC feature to handle errors and resolve the conflict.
D. Use the HANDLECOLLISIONS feature to handle errors and resolve the conflict.

正解：A

解説：
Oracle GoldenGate must consistently identify rows during replication using a primary or unique key. If row identification fails, adding or enforcing a unique index is the correct way to resolve the issue-not relying on collision or conflict-handling features.

質問 # 48
You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?

A. Use the command option AFTERCSN.
B. Use the command option RESUME.
C. Use the command option UNTIL CANCEL.
D. Use the command option ATCSN.

正解：A

解説：
"AFTERCSN causes Replicat to start processing at the transaction that occurred after the one with the specified CSN. Any transactions in the trail that have CSN values that are less than, or equal to, the specified one are skipped."

質問 # 49
You find that an Extract's recovery time increases. What caused it?

A. The difference between the start of the oldest open (uncommitted) transaction and current read position in the transaction log stored in the checkpoint file is large.
B. The current read position (RBA) is less than the oldest open (uncommitted) transaction position.
C. The oldest open (uncommitted) transaction is small.
D. There is no oldest open (uncommitted) transaction.

正解：A

解説：
When the difference between the oldest open transaction's start and the current read position is large, Extract must scan more log data, increasing recovery time.

質問 # 50
You need to configure the source database, target database, and Oracle GoldenGate for conflict detection and resolution (CDR). You want the full before image of each record, but your database does not provide a before image in the log record and must be configured to do so with supplemental logging. How should you proceed?

A. Include the USEDELTA command.
B. Include the UPDATAROWEXISTS command.
C. Include the ADD TRANDATA command.
D. Include the OVERWRITE command.

正解：C

解説：
To enable full before images for Conflict Detection and Resolution (CDR), use the ADD TRANDATA command to enable supplemental logging on the source table, ensuring key and changed column data is captured in the redo logs.

質問 # 51
What is implemented by Oracle GoldenGate to be able to obtain trail files from the source when the source Distribution Server cannot initiate communication with the target where the Receiver Server is?

A. Microservices Architecture Authentication will initiate communication for the Distribution Server.
B. The Extract will directly send trail files for the Replicat to receive and apply changes.
C. A Receiver Server can pull trail files from Distribution Server using a single port for Reverse proxy.
D. A secured port must be implemented and opened by the target to enable the source Distribution Server to be able to initiate communication with the target's Receiver Server.

正解：C

解説：
In Oracle GoldenGate Microservices Architecture, when the source Distribution Server cannot initiate outbound communication (e.g., due to firewall or network restrictions), the Receiver Server on the target can be configured to pull trail files using Reverse Proxy mode - establishing a single, secure inbound connection.

質問 # 52
Which utility is used to view the contents of trail files?

A. logdump
B. ggconsole
C. datapump
D. trailreader

正解：A

解説：
logdump is the diagnostic tool to examine trail files at the record level.

質問 # 53
What is not a role used in a Microservices architecture deployment?

A. User
B. Manager
C. Security
D. Administrator

正解：B

解説：
In Oracle GoldenGate Microservices Architecture (MA), roles refer to user roles that define access control and authorization across the different services. Common roles include:

質問 # 54
Using adminclient, you can add a data pump Extract using the command: "ADD EXTRACT <ext name>, EXTTRAILSOURCE <trail file>"

A. TRUE
B. FALSE

正解：B

解説：
adminclient doesn't support EXTTRAILSOURCE; it's not used in Extract setup.

質問 # 55
The IF function is used to test one or more conditions and return a value. The Replicat parameter file has the following entry:

A. Pacific
B. East
C. Mountain
D. Central

正解：B

解説：
The logic in this statement: text Copy Edit @IF(@VALONEOF(STATE, 'CO', 'TX', 'IL'), 'PACIFIC', 'EAST') It checks if the value of STATE is CO, TX, or IL. If true ? returns 'PACIFIC' If false ? returns 'EAST' Since 'CA' is not in that list, the result will be: text Copy Edit TIME ZONE = 'EAST'

質問 # 56
User ______ are a set of variables.

A. Macros
B. Tokens
C. Exits
D. Procedures

正解：B

解説：
Tokens are variable sets used in parameter files.

質問 # 57
You have offloaded data from the source onto a file. What method would you use to perform your initial load onto the target database?

A. GoldenGate Direct Load
B. File to Replicat
C. Direct bulk load to SQL*Loader
D. File to database utility

正解：C

解説：
When data is offloaded to a file, using SQL*Loader for a direct bulk load is the most efficient method. It leverages Oracle's optimized loading capabilities to handle large datasets effectively, minimizing resource usage and time.

質問 # 58
The Integrated Replicat reads the trail, constructs logical change records that represent source DML or DDL transactions, and transmits these records to an inbound server in the Oracle target database. What statement is true about Integrated Replicat?

A. Both source and target can be Oracle and non-Oracle databases.
B. Source must be configured as Integrated Extract.
C. Integrated Replicat does not need a checkpoint or a trace table for its operations.
D. Trail files contain data that must be in logical change records format.

正解：D

解説：
Integrated Replicat processes Logical Change Records (LCRs). These LCRs are read from trail files and passed to the Inbound Server. It supports parallel apply and uses Oracle Streams APIs internally.

質問 # 59
GGSCI commands can display:

A. Lag in the system
B. Statistics (operations processed)
C. All of the above
D. Processing status

正解：C

解説：
GGSCI provides status, statistics, and lag details

質問 # 60
What must be done when adding a new table after GoldenGate has been implemented?

A. Run Add TranData or AddSchemaTranData
B. Restart Oracle GoldenGate
C. Nothing, it auto-detects
D. Restart the database

正解：A

解説：
ADD TRANDATA must be run when adding new tables.

質問 # 61
What detailed information does the Network Statistics tab of the Receiver Server provide for the Data Path configured?

A. The transfer network protocol
B. The IP Address of the sender and the Distribution Path
C. The host of the sender and the Distribution Path
D. The total write time

正解：C

解説：
The Network Statistics tab in the Receiver Server UI displays details about the host of the sender and the configured Distribution Path, which helps in monitoring and troubleshooting replication data flow paths in Oracle GoldenGate Microservices.

質問 # 62
Which option is an invalid GLOBALS parameter?