• ホーム
  • ブログ
  • 検証済みの1Z1-947テスト問題集と解答で正確な147問 [Q56-Q77]

検証済みの1Z1-947テスト問題集と解答で正確な147問 [Q56-Q77]

Share

検証済みの1Z1-947テスト問題集と解答で正確な147問

Oracle 1Z1-947テストエンジンPDFで全問無料問題集

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

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

正解：A、B、D

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


質問 # 57
Integrated delivery works only with trail files from integrated capture.

  • A. FALSE
  • B. TRUE

正解：A

解説：
Integrated delivery can use trail files from classic or integrated capture.


質問 # 58
How should you specify the data source for a secondary Extract functioning as a Data Pump?

  • A. LOCTRAILSOURCE
  • B. EXTTRAILSOURCE
  • C. SOURCEISTRAIL
  • D. SOURCEISSTABLE

正解：B

解説：
For a secondary Extract functioning as a Data Pump, you should specify the data source using EXTTRAILSOURCE. This parameter tells GoldenGate to use the local trail file (created by the primary Extract) as the source for the data pump.


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

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

正解：A

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


質問 # 60
Which parameter gives more accurate timing for lag statistics?

  • A. TCPSourceTimer
  • B. DynamicResolution
  • C. CacheMgr

正解：A

解説：
TCPSourceTimer improves lag timing accuracy.


質問 # 61
Invisible columns are columns that are part of a table but not part of the results in a select. When Data Definition Language (DDL) replication is enabled, invisible and virtual columns created in the source environment are replicated in the target environment. What parameter in Extract will exclude invisible columns from replication when using the Integrated Extract?

  • A. NOHIDDENCOLUMNS
  • B. NOINVISIBLECOLUMNS
  • C. EXCLUDEHIDDENCOLUMNS

正解：C

解説：
"Oracle GoldenGate supports replication of invisible columns in Extract.
If you want to exclude them, use the EXCLUDEHIDDENCOLUMNS parameter."


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

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

正解：C

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


質問 # 63
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 HANDLECOLLISIONS feature to handle errors and resolve the conflict.
  • C. Use the RESOLVECONFLICT feature to handle errors and resolve the conflict.
  • D. Use the SQLEXEC 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.


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

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

正解：A

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


質問 # 65
You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?

  • A. It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.
  • B. It is caused by the thread with the highest thread ID applying barrier transactions.
  • C. It is caused by the use of the MAXTRANSOPS parameter.
  • D. It is caused by barrier transactions in a Coordinated Replicat.

正解：D

解説：
In Coordinated Replicat, a barrier transaction is a transaction that must be applied in commit order, causing all threads to pause until that transaction is completed - leading to the situation where all threads wait for one.


質問 # 66
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 (TargetColumnName=SourceColumnName, ...)
  • C. COLMAP (USEDEFAULTS)...
  • D. ASSUMETARGETDEFS

正解：B

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


質問 # 67
What is the purpose of checkpointing in GoldenGate?

  • A. To view replication progress
  • B. To clean trail files
  • C. To enable recovery of processes in case of failure
  • D. To configure system parameters

正解：C

解説：
To enable recovery if a GoldenGate process, system, or network fails.


質問 # 68
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 from source database DML transactions. Next, it uses standard SQL to apply data directly to the target tables.
  • 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 (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.

正解：D

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


質問 # 69
Which transactions are captured if you ADD EXTRACT with BEGIN NOW at 1:00 PM, but START EXTRACT at 2:00 PM?

  • A. Transactions that started before 1:00 PM and committed after 2:00 PM
  • B. Transactions that started at or after 1:00 PM
  • C. Only transactions that started at or after 2:00 PM
  • D. Only transactions that started before 1:00 PM and committed after 1:00 PM

正解：B

解説：
When you run ADD EXTRACT ... BEGIN NOW at 1:00 PM, GoldenGate records the current CSN/SCN as the starting point. So even if you start the Extract later (e.g., at 2:00 PM), it will capture transactions that started at or after 1:00 PM, ensuring no changes are missed from the defined start point.


質問 # 70
Which components have been made redundant in Oracle GoldenGate 12.2 and later?

  • A. Extract
  • B. Replicat
  • C. SOURCEDEFS
  • D. ASSUMETARGETDEFS

正解：C、D

解説：
From 12.2, ASSUMETARGETDEFS and SOURCEDEFS are no longer needed.


質問 # 71
Oracle GoldenGate Software Command Interface (GGSCI) is the Oracle GoldenGate command-line utility. You use GGSCI commands to configure, control, and monitor Oracle GoldenGate. GGSCI commands can be collected in a text script called an Obey (.oby) file. How can it be run in Obey scripts and also used in Microservices architecture?

  • A. Run it on the OS logged in as user oggadmin.
  • B. Log into source or target database as user oggadmin and run script at SQL prompt.
  • C. Launch GGSCI and run from the GGSCI prompt.
  • D. Run scripts from adminclient.

正解：D

解説：
For Microservices Architecture, run Obey scripts using the adminclient.


質問 # 72
What command options specify Extract and Replicat batch mode for initial load?

  • A. ADD REPLICAT WITH SPECIALRUN
  • B. ADD EXTRACT WITH SOURCEISTABLE
  • C. ADD REPLICAT WITH PASSTHRU
  • D. ADD EXTRACT WITH TRANLOGOPTIONS

正解：A、B


質問 # 73
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.


質問 # 74
GGSCI commands can display:

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

正解：A

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


質問 # 75
SQLEXEC can communicate only via SQL query.

  • A. FALSE
  • B. TRUE

正解：A

解説：
SQLEXEC can run scripts, not just SQL queries.


質問 # 76
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).


質問 # 77
......

100%合格率保証付きの素晴らしい1Z1-947試験問題PDF：https://www.goshiken.com/Oracle/1Z1-947-mondaishu.html

手に入れよう！最新1Z1-947認定有効な試験問題集解答：https://drive.google.com/open?id=1vmEkdbl484BCcQ03qC-2fS0ylv_CryIR

関するブログ

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