• ホーム
  • ブログ
  • 更新された2026年02月テストエンジンに練習1Z1-947テスト問題 [Q69-Q93]

更新された2026年02月テストエンジンに練習1Z1-947テスト問題 [Q69-Q93]

Share

更新された2026年02月テストエンジンに練習1Z1-947テスト問題

1Z1-947リアル試験問題テストエンジン問題集トレーニングには147問あります

質問 # 69
What is the role of the Replicat process?

  • A. Backs up trail files
  • B. Applies captured changes to the target database
  • C. Captures changes from the source DB logs
  • D. Routes data through Distribution Server

正解：B

解説：
Replicat reads change data from Oracle GoldenGate trails and applies it to a target database using SQL commands.


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

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

正解：D

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


質問 # 71
User exits can be used for tables processed by a data pump Extract in passthru mode.

  • A. FALSE
  • B. TRUE

正解：A

解説：
User exits don't work in passthru mode (no transformation).


質問 # 72
A database that requires replication contains sensitive data that is not required on the target. How should you prevent this sensitive data from being replicated?

  • A. Use the COLMAP option in the MAP parameter.
  • B. Use the FILTER option in the MAP parameter.
  • C. Use the COLS and COLSEXCEPT options in the TABLE parameter.
  • D. Do not specify those columns in the ADD TRANDATA command.

正解：C

解説：
To prevent sensitive data from being replicated, you should use the COLS and COLSEXCEPT options in the TABLE parameter. These options allow you to explicitly include or exclude specific columns from the replication process, ensuring that sensitive data is not transferred to the target database.


質問 # 73
What is the purpose of the GoldenGate Initial Load?

  • A. To carry out Performance Load Testing
  • B. To synchronize data in the source and target databases
  • C. To stream change data to a target database
  • D. To create the target database objects

正解：B

解説：
The Initial Load in Oracle GoldenGate is used to: Populate the target database with a baseline copy of data from the source Ensure that both source and target are in sync before real-time replication begins After this load, GoldenGate can start streaming only ongoing changes


質問 # 74
The filter clause provides the ability to include or exclude data to process. What is true with this filter clause: Filter (ON UPDATE, ON DELETE, @Compute(PRODUCT_PRICE * PRODUCT_AMOUNT) > 10000)

  • A. Data processing will include rows for insert if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
  • B. Data processing will exclude rows for update if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
  • C. Data processing will exclude rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
  • D. Data processing will include rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000

正解：B

解説：
The FILTER clause with @Compute and ON UPDATE, ON DELETE includes only those rows where the computed value is greater than 10000. If not, the row is excluded from processing - specifically for UPDATE and DELETE operations.


質問 # 75
What command is used to create the checkpoint table on the target database?

  • A. CONFIGURE CHECKPOINT TABLE
  • B. CREATE TABLE CHECKPOINT
  • C. ADD CHECKPOINTTABLE
  • D. INIT CHECKPOINTTABLE

正解：C

解説：
This command creates a table that tracks Replicat's checkpointing data.


質問 # 76
Which Oracle GoldenGate parameter manages conflicts between initial load and change replication?

  • A. CheckpointTable
  • B. HandleCollisions
  • C. PASSTHRU
  • D. DiscardFile

正解：B

解説：
HandleCollisions, specified in the Replicat parameter file. Should be turned off after initial load is complete.


質問 # 77
Which parameter is typically used with data pumps unless transformation is needed?

  • A. TrailFile
  • B. ASSUMETARGETDEFS
  • C. Map
  • D. PASSTHRU

正解：D

解説：
PASSTHRU (used unless transformation or exit processing is needed)


質問 # 78
Which three products are part of the Oracle GoldenGate product line?

  • A. Oracle GoldenGate Application Adapters
  • B. Oracle GoldenGate Stadium
  • C. Enterprise Manager
  • D. Oracle GoldenGate for Big Data
  • E. Oracle GoldenGate Veridata
  • F. Correct selection
  • G. Oracle Streams

正解：A、D、E

解説：
Veridata, Application Adapters, and Big Data are official GoldenGate products.


質問 # 79
Which three statements are true about Oracle GoldenGate?

  • A. Oracle GoldenGate captures changes from Oracle Redo logs or non-Oracle transaction logs and moves them to another database.
  • B. Oracle GoldenGate is a middleware product that does not require an Oracle database.
  • C. Oracle GoldenGate is an Oracle Database product that supports other Oracle products.
  • D. Oracle GoldenGate can support high availability.

正解：A、B、D

解説：
GoldenGate does not need Oracle DB, reads logs, and supports HA.


質問 # 80
What is the main advantage of using a data pump Extract?

  • A. Secure REST access
  • B. Faster row compression
  • C. Enables load balancing
  • D. Trail retention at source for recovery

正解：D

解説：
It allows recovery if the network or target system fails by maintaining a local trail.


質問 # 81
Oracle GoldenGate is a middleware software and can be used for business intelligence to support a heterogeneous database environment.

  • A. FALSE
  • B. TRUE

正解：B

解説：
GoldenGate is middleware supporting business intelligence across different databases.


質問 # 82
Identify the scenario in which you cannot configure GoldenGate.

  • A. Real-time Change Data Capture from transaction logs
  • B. Snapshot database backups
  • C. Batch Data Transfer from table data
  • D. Initial Load synchronization

正解：B

解説：
Snapshot database backups are not a replication scenario - GoldenGate does not operate on backups. It's designed for live, transactional, and log-based data movement, not static snapshots.


質問 # 83
In integrated mode, the Replicat process leverages the apply processing functionality that is available within the Oracle database. How does it operate?

  • A. It reads the Oracle GoldenGate trail, performs data filtering, mapping and conversion. Then, it transmits the regular change records to the inbound server, which applies the data to the target database.
  • B. It reads the Oracle GoldenGate trail, performs data filtering, mapping, and conversion. Then, it constructs logical change records (LCRs) from source database DML transactions. DDL is applied directly by Replicat. Finally, it transmits the LCRs to the inbound server, which applies the data to the target database.
  • C. It reads the Oracle GoldenGate trail, performs data filtering, mapping, and conversion. Then, it constructs logical change records (LCRs) from source database DML transactions. Then it is attached to a background process in the target database by means of lightweight streaming mechanism, which transmits the LCRs to the inbound server, which applies the data to the target database.
  • D. It reads the Oracle GoldenGate trail, performs data filtering, mapping and conversion. Then, it constructs logical change records from source database DML transactions. Next, it uses standard SQL to apply data directly to the target tables.

正解：B

解説：
Integrated Replicat constructs LCRs for DML, sends them to the inbound server for apply, while DDL is applied directly by Replicat-not through the inbound server.


質問 # 84
Source and target tables have the same column order, data types, and column sizes, yet different table and column naming. Which Replicat parameter will handle this mapping?

  • A. SOURCEDEFS
  • B. COLMAP (USEDEFAULTS)...
  • C. ASSUMETARGETDEFS
  • D. COLMAP (TargetColumnName=SourceColumnName, ...)

正解：D

解説：
When source and target tables have the same column order, data types, and sizes, but different table or column names, you need to explicitly map columns using the COLMAP parameter in the Replicat parameter file.


質問 # 85
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. There is a dedicated GoldenGate process called SPECIALRUN
  • D. The SPECIALRUN parameter is in the Replicat parameter file

正解：D

解説：
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.


質問 # 86
Users of both Extract and Replicat require the DBA role for the database.

  • A. FALSE
  • B. TRUE

正解：A

解説：
Full DBA role is not mandatory for Extract or Replicat.


質問 # 87
DDL can be used in conjunction with filter options. What would be the correct DDL parameter if you need DDL for specific objects?

  • A. DDL Include. <objectname>
  • B. DDL Exclude All, Include ObjName <objectname>
  • C. DDL Include All, Exclude ObjName <objectname>
  • D. DDL <objectname>

正解：B

解説：
This configuration first excludes all DDL operations (EXCLUDE ALL) and then selectively includes DDL for specific objects using INCLUDE OBJNAME. This approach ensures that only the desired DDL operations are replicated, providing precise control over DDL replication.


質問 # 88
Which parameter for GoldenGate 19c enables DDL replication for a Replicat?

  • A. TARGETDDL
  • B. USEDDL
  • C. Enabled by default
  • D. GETDDL

正解：C

解説：
In Oracle GoldenGate 19c, Replicat is indeed configured to process DDL by default. So, if DDL statements are captured by Extract and passed in the trail files, Replicat will apply them without needing extra configuration.


質問 # 89
Where are the Oracle GoldenGate parameters officially documented?

  • A. Oracle Fusion Middleware Reference for Oracle GoldenGate 19c
  • B. Oracle GoldenGate AdminClient Manual
  • C. Oracle Database Concepts Guide
  • D. GoldenGate GGSCI Command Reference

正解：A

解説：
Oracle Fusion Middleware Reference for Oracle GoldenGate 19c


質問 # 90
What is GGSCI in Oracle GoldenGate?

  • A. Extract checkpoint viewer
  • B. Report generation engine
  • C. Command interpreter for managing GG processes
  • D. GUI-based replicat monitor

正解：C

解説：
Oracle GoldenGate Software Command Interpreter (text-based interface)


質問 # 91
Which tools would you use to determine if all Oracle GoldenGate processes are up and running?

  • A. CMDSEC
  • B. tcpers
  • C. Oracle GoldenGate Monitor
  • D. Process report
  • E. GGSCI

正解：C、D、E

解説：
Use GGSCI, process reports, or Monitor to check running processes.


質問 # 92
Which is an invalid combination for EVENTACTIONS with options?

  • A. EVENTACTIONS (CHECKPOINT BEFORE, ABORT)
  • B. EVENTACTIONS (CHECKPOINT AFTER, ABORT)
  • C. EVENTACTIONS (CHECKPOINT BOTH, STOP)
  • D. EVENTACTIONS (CHECKPOINT BOTH, IGNORE)

正解：D

解説：
The combination CHECKPOINT BOTH with IGNORE is invalid because IGNORE tells Replicat to skip the transaction, while CHECKPOINT BOTH implies a complete apply and checkpoint - which contradicts the action of ignoring the transaction.


質問 # 93
......

1Z1-947実際の問題解答PDFには100%カバー率リアル試験問題：https://www.passtest.jp/Oracle/1Z1-947-shiken.html

1Z1-947試験問題解答：https://drive.google.com/open?id=1BLTH0mP71OT2wu3gZpP2T_S9FxPWivLu

関するブログ

もっと
1Z1-947 無料問題集