最新的Oracle GoldenGate認證 1Z1-947考試題庫

問題1

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 exclude rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000

B. Data processing will include rows for insert if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000

C. Data processing will exclude rows for update 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

正確答案: C

說明：（僅 VCESoft 成員可見）

問題2

Only the EncryptTrail Extract parameter should be used to encrypt/decrypt trail file records.

A. TRUE

B. FALSE

正確答案: B

說明：（僅 VCESoft 成員可見）

問題3

Which statement is not true for a Data Path in the Oracle GoldenGate Microservices architecture environment?

A. The Replicat process reads the trail files that are made available by the Distribution Server.

B. The Replicat process applies all committed changes to the target database.

C. The Extract process stores the captured data in trail files.

D. The Distribution Server accesses the trail files for a defined Path.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題4

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. A Receiver Server can pull trail files from Distribution Server using a single port for Reverse proxy.

B. The Extract will directly send trail files for the Replicat to receive and apply changes.

C. 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.

D. Microservices Architecture Authentication will initiate communication for the Distribution Server.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題5

Identify the scenario in which you cannot configure GoldenGate.

A. Real-time Change Data Capture from transaction logs

B. Initial Load synchronization

C. Batch Data Transfer from table data

D. Snapshot database backups

正確答案: D

說明：（僅 VCESoft 成員可見）

問題6

Which parameter is typically used with data pumps unless transformation is needed?

A. Map

B. PASSTHRU

C. ASSUMETARGETDEFS

D. TrailFile

正確答案: B

說明：（僅 VCESoft 成員可見）

問題7

Suppose your process stops immediately after verifying parameter syntax. What is the most likely reason?

A. The database user has incorrect permissions

B. Oracle GoldenGate reports syntax problems

C. The CheckParams parameter is enabled

D. The group name is spelled wrong

正確答案: C

說明：（僅 VCESoft 成員可見）

問題8

What command options specify Extract and Replicat batch mode for initial load?

A. ADD REPLICAT WITH PASSTHRU

B. ADD EXTRACT WITH SOURCEISTABLE

C. ADD EXTRACT WITH TRANLOGOPTIONS

D. ADD REPLICAT WITH SPECIALRUN

正確答案: B,D

問題9

What is a DiscardFile not used for?

A. File for rejected Replicat data

B. File for rejected Extract data

C. Replacing a trail file on the target system

正確答案: C

說明：（僅 VCESoft 成員可見）

問題10

If you were to create a target-initiated Distribution Path, which of the following must you provide?

A. The name of the GoldenGate deployment

B. The name of the Extract

C. The target URI

D. The name of the database transaction logs where database data changes were recorded

正確答案: C

說明：（僅 VCESoft 成員可見）

最新的Oracle GoldenGate 19c Implementation Professional - 1Z1-947免費考試真題

最新更新

站內鏈接

聯系我們