Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
P.S. Download 1Z0-447 dump are available on Google Drive, GET MORE: https://drive.google.com/open?id=1g50uMyz1EgCK9JUb8_EA0f8px-RINg_F
Question No: 2
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
Question No: 3
Which option is an invalid GLOBALS parameter?
A. DISCARDFILE
B. GGSCHEMA
C. MGRSERVNAME
D. CHECKPOINTTABLE
Answer: A
Question No: 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
Question No: 5
Which GLOBALS parameter is required to initially enable monitoring?
A. JAGENTMONITORING
B. ENABLEMONITORING
C. ENABLEOEMMONITORING
D. CHECKMONITORING
Answer: B
Question No: 6
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
Question No: 7
Your Replicat performance seems slow. Which Replicat parameter can be used to improve performance?
A. DEFERAPPLYINTERVAL
B. BATCHSQL
C. ASSUMETARGETDEFS
D. SPECIALRUN
Answer: B
Question No: 8
By default which type of operations are captured by extract?
A. Inserts, updates, deletes, and table operations such as CREATE TABLE
B. Inserts, compresses, and updates
C. Inserts, updates, deletes, and table operations such as ADD COLUMN
D. Inserts only
E. Inserts, updates, and deletes
Answer: E
Question No: 9
For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management?
A. Teradata
B. Informix
C. Sybase
D. DB2
Answer: D
Question No: 10
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
Question No: 11
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
P.S. Easily pass 1Z0-447 Exam with Examcollectionplus Download Dumps & pdf vce, Try Free: https://www.examcollectionplus.net/vce-1Z0-447/ ( New Questions)