Tips to Pass 1Z0-447 Exam (4 to 13)

Question No: 4

You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover From this?

A. Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files.

B. Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn to HANDLECOLLISIONS in the Replicat.

C. Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and regenerate the checkpoint table.

D. Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files.

Question No: 5

Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?

A. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater

B. any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater

C. Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater

D. Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

Question No: 6

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, wait for it to stop, and then start the Replicat task.

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

D. Start the Replicat task.

Question No: 7

Which three are types of encryption supported by OGG?

A. Parameter file encryption

B. Password

C. Trial file encryption

D. Message encryption

Question No: 8

Which statement regarding the GoldenGate Data Pump is incorrect?

A. Data Pump is a separate process.

B. Data Pump can be used to pump trail records to multiple locations.

C. Data Pump has distance limitations.

D. Data Pump uses TCP/IP to route the trail records.

Question No: 9

What is the default threshold for message compression in OGG?

A. 1000

B. 100

C. O

D. By default, messages are not compressed.

Question No: 10

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 byTHREAD and THREADRANGEbeing 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 theMAXTRANSOPSparameter.

D. It is caused by barrier transactions in a Coordinated Replicat.

Question No: 11

You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT

<extractgroup> SHOWCH. How should you proceed?

A. Use the Read Startup Checkpoint.

B. Use the Read Recovery Checkpoint.

C. Use the Write Startup Checkpoint.

D. Use the Read Current Checkpoint.

Question No: 12

Which three are valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column? (Select three.)

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

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

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

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

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

Question No: 13

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-tou2013database utility. How should you configure GoldenGate in order to accomplish this?

A. Configure Replicat with theFORMATASCII SQLLOADER OPTION.

B. Configure Extract with theFORMATSQL SQLLOADER OPTION.

C. Configure Extract with theFORMATASCII SQLLOADER OPTION.

D. Configure Replicat with theFORMATXML OPTION.