All About Pinpoint 1Z0-447 Preparation Labs

NEW QUESTION 1
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 QUESTION 2
You want to eliminate the reporting output from processing a Macro. How should you proceed?

• A. Use the optional parameterNOLIST.
• B. Use the optional parameterUNLIST.
• C. Use the optional parameterNOREPORT.
• D. Use the optional parameterNOMACROOUTPUT.

Answer: A

NEW QUESTION 3
What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

• A. KEYGEN file in the GoldenGate data location
• B. COBGEN file in the GoldenGate installation location
• C. GGSKEY file in the GoldenGate data location
• D. GGSKEY file in the GoldenGate installation location
• E. ENCKEYS file in the GoldenGate installation location

Answer: E

NEW QUESTION 4
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 QUESTION 5
Your Replicat performance seems slow. Which Replicat parameter can be used to improve performance?

• A. DEFERAPPLYINTERVAL
• B. BATCHSQL
• C. ASSUMETARGETDEFS
• D. SPECIALRUN

Answer: B

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

• A. Jagent
• B. Extract
• C. Replicat
• D. Manager

Answer: B

NEW QUESTION 7
You must synchronize tables with Large Object data types. Which Initial Load method supports this process?

• A. File to Replicat
• B. GoldenGate Direct Load
• C. File to database utility
• D. Direct bulk load to SQL*Loader

Answer: D

NEW QUESTION 8
A database that requires replication contains sensitive data that is not required on the target. How should you prevent this sensitive data from being replicated?

• A. Use theFILTERoption in theMAPparameter.
• B. Use theCOLMAPoption in theMAPparameter.
• C. Do not specify those columns in theADD TRANDATAcommand.
• D. Use theCOLSandCOLSEXCEPToptions in theTABLEparameter.

Answer: B

NEW QUESTION 9
Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?

• A. The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.
• B. The Extract will revert to single-row fetch mode for all tables.
• C. The Extract will abend unless LOBMEMORY is increased.
• D. The Extract will perform poorly due to paging unless LOBMEMORY is increased.

Answer: A

NEW QUESTION 10
How should you configure Replicat to control how errors are handled in one-way replication?

• A. UseREPERRORin the Replicat parameter file.
• B. UseHANDLECOLLISIONin the Replicat parameter file.
• C. Use Conflict Detection and Resolution in the Replicat parameter file.
• D. UseMAPEXCEPTIONin the Replicat parameter file.

Answer: A

NEW QUESTION 11
Which option is an invalid GLOBALS parameter?

• A. DISCARDFILE
• B. GGSCHEMA
• C. MGRSERVNAME
• D. CHECKPOINTTABLE

Answer: A

NEW QUESTION 12
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

Answer: C

NEW QUESTION 13
Your Goldengate deployment is using a shared wallet, and older versions of the master key should be retained after the master key is renewed until all processes are using the newest version.
How should you determine whether all of the processes are using the newest version so that you can delete older versions of the master key?

• A. GoldenGate deployments cannot use a shared wallet.
• B. View the GoldenGate log files to monitor Replicat report files to verify that the SCN was applied by allReplicat groups.
• C. View the report file of the newest Extract after renewing the master key to confirm the last SCN that was mined with old key.
• D. View the report file of each Extract immediately after renewing the master key to confirm the last SCN that was mined with the old ke
• E. Then, monitor the Replicat report files to verify that this SCN was applied by all Replicat groups.

Answer: D

NEW QUESTION 14
If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

• A. Manager
• B. Replicat
• C. Extract
• D. Extract and Replicat

Answer: A

NEW QUESTION 15
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: ABC

NEW QUESTION 16
What is the default format for a GoldenGate trail?

• A. ASCII:ASCII format
• B. INPUT ASCII: from 1to 127 representing ASCII characters
• C. SQL: SQL statements
• D. CDF: Canonical Data format
• E. XML: XML statement

Answer: A

NEW QUESTION 17
What software is required prior to running Oracle GoldenGate in a Windows Server environment?

• A. Oracle Gateway software configured for that particular database platform
• B. JDBC drivers into the GoldenGate home directory
• C. Microsoft Visual C++ 2010 SP1 Redistributable Package
• D. Nothing, configure GoldenGate Jagent for that particular database platform.

Answer: C

NEW QUESTION 18
......