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

Question 1

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

A. tcpers

B. Process report

C. CMDSEC

D. GGSCI

E. Oracle GoldenGate Monitor

Correct Answer: B,D,E

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

Question 2

You can connect to the Receiver Server to manage (start and stop) the configured data paths.

A. FALSE

B. TRUE

Correct Answer: B

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

Question 3

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

Correct Answer: D

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

Question 4

Which valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column?

A. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));

B. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));

C. FILTER (@RANGE 2, 2, ID);

D. TABLE fin.Sales, FILTER (@RANGE (1, 2));

E. FILTER (@RANGE (2, 2, AccountID));

Correct Answer: B

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

Question 5

You were assigned to install the Oracle GoldenGate 19c Microservices architecture software. There are three things that need to be done for the installation process: Install the software using the Oracle Universal Installer. Set the necessary environment variables. Deploy an Oracle GoldenGate instance using the configuration assistant, oggc a. What will running the oggca.sh utility do?

A. Configure the Service Manager and the other Microservices architecture servers.

B. Create a database user for the GoldenGate instance.

C. Create the administration user for the GoldenGate instance.

D. Launch GoldenGate instance wizard to guide you through creating an Extract and a Replicat.

Correct Answer: A

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

Question 6

A Distribution Path sends the transaction of data from Extract to Replicat. How can you create a Distribution Path?

A. From Cloud Shell with REST APIs

B. At OS prompt with run preceding the GoldenGate commands

C. In GGSCI with GoldenGate commands

D. From the Service Manager home page

Correct Answer: D

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

Welcome to TestSimulate

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