Oracle GoldenGate 19c Implementation Professional (1Z0-947) Free Practice Test

Question 1

Why might you use multiple data pumps for one source trail?

A. Send to multiple targets and improve parallelism

B. Encrypt extract data

C. Minimize CPU usage

D. Reduce redo generation

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

A Pump can push data to:

A. Only a source system

B. Multiple target systems

C. Only one target system

D. A target database directly

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

Can ogggsa.sh utility configure only the Service Manager?

A. No, it must also configure at least one deployment

B. Yes, and also the AdminClient

C. Yes, it configures only Service Manager

D. No, it is used only for viewing logs

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

What Oracle GoldenGate component sends trail files over the network to the Receiver Server?

A. The Extract

B. The Trail File Server

C. The GoldenGate source Data Pump

D. The Distribution Server on the source

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

Which formats can extract trails be written in?

A. Binary, CSV, JSON

B. LOB, RAW, JSON

C. Only Canonical and SQL

D. Canonical, LCR, Text (ASCII/UTF), SQL, XML

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

Which of these can you not do from the main page of the MA Administration Server web page?

A. See the lag time of currently configured Extracts and Replicats.

B. Create an Extract or Replicat.

C. Fix the situation of what caused the Extract or Replicat to be down from the Critical Event box.

D. Restart configured Extracts and Replicats.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

You have configured and added the Extract and Replicat tasks by using the Direct Load method. What do you need to do to get the processes up and running?

A. Start the Extract task

B. Start the Extract task and then start the Replicat task

C. Start the Replicat task

D. Start the Extract task, wait for it to stop, and then start the Replicat task

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

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

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle GoldenGate 19c Implementation Professional (1Z0-947) Free Practice Test