1Z0-447 | All About Downloadable 1Z0-447 exam

New Questions 2

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.

Answer: C

New Questions 3

Which option is an invalid GLOBALS parameter?

A. DISCARDFILE

B. GGSCHEMA

C. MGRSERVNAME

D. CHECKPOINTTABLE

Answer: A

New Questions 4

Identify the correct statement regarding Trails.

A. Extract and Pump are different OS level executable binary files.

B. Extracts cannot perform filtering, mapping, and transformations.

C. RMTTRAILis for remote trails andEXTTRAILis for local trails.

D. Extract is typically used to produce local trail files over a TCP/IP connection.

Answer: B

New Questions 5

Which method in GoldenGate should you use to undo DML changes previously made to a target database?

A. Run Extract and Replicat from the command line.

B. Use Extract and Replicat with the GoldenGate Logdump utility.

C. Run the Reverse Utility on the target database transaction logs.

D. Use Extract and Replicat with the GoldenGate Reverse utility.

Answer: D

New Questions 6

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.

Answer: B

New Questions 7

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);

Answer: A B C

New Questions 8

In which process should you configure the warning for long-running transactions?

A. Jagent

B. Extract

C. Replicat

D. Manager

Answer: B

New Questions 9

What is the key purpose of GoldenGate trail files?

A. They are a persistent storage area for captured transactions.

B. They are configuration files for the GoldenGate processes.

C. They are checkpoint files for the GoldenGate processes.

D. They are database auditing logs where GoldenGate captures changes.

Answer: C

New Questions 10

When would you use the PASSTHRU parameter?

A. When using a data pump to distribute all of the trail data "as is" to a remote system.

B. When Extract is processing database transaction logs where you have a remote database connection.

C. For a SPECIALRUN one-time processing task that is doing an initial load.

D. When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat.

Answer: A

New Questions 11

How can you tell if GoldenGate has been configured for batch processing?

A. TheSPECIALRUNparameter is in the Replicat parameter file.

B. Replicat is started with theINITIALLOADtask.

C. There is a dedicated GoldenGate process calledSPECIALRUN.

D. TheSPECIALRUNparameter is in theGLOBALSparameter file.

Answer: B