1Z0-447 Online Practice Questions and Answers
You are migrating from a legacy database server to Exadata, which requires you to use different versions of GoldenGate. What do you need to configure to ensure that backwards replication works?
A. The Replicat with the FORMAT RELEASEparameter.
B. The Extract with the FORMAT RELEASE parameter.
C. The Extract to write directly to the remote trail.
D. The collector with the FORMAT RELEASEparameter.
Which command provides statistics about GoldenGate processes and memory resource utilization?
A. SEND…CACHEMGR
B. SEND…LOGSTATS
C. SEND…GETTCPSTATS
D. INFO…SHOWCH
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 and EXTTRAILis for local trails.
D. Extract is typically used to produce local trail files over a TCP/IP connection.
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
GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them?
A. in the checkpoint file area
B. in the trail files area
C. in the server temporary file system
D. in the bounded recovery area
Which option is supported by GoldenGate DDL replication?
A. CREATE ROLE
B. ALTER SYSTEM
C. ALTER DATABASE
D. ALTER TABLE SYS
You must implement GoldenGate in a secure environment. How should you proceed in order to protect GoldenGate data from theft?
A. Implement trail file encryption.
B. Ensure that passwords are encrypted.
C. Ensure that network communications are encrypted.
D. Ensure that table-level Transparent Data Encryption is implemented.
Which is an incorrect syntax for connecting to a source or target database by an Extract or Replicat?
A. TARGETDB TargetDSN USERID sampleID PASSWORD samplepword
B. SOURCEDB SourceDSN
C. SOURCEDB sampleDB USERID sampleID PASSWORD samplepword
D. TARGETDB sampleID samplepword
Which option is not included as part of a Veridata installation?
A. Veridata BackPlane Server
B. Veridata Agent
C. Veridata Web Server
D. Veridata Repository
You need to manually patch Oracle GoldenGate source and targets. How should you proceed?
A. Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. If the patches changed table definitions, run DEFGEN for the source tables to generate updated source definitions, and then replace the old definitions with the new ones in the existing source definitions file on the target system. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.
B. Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source and on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.
C. Stop access to the source and target databases. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.
D. Stop access to the source and target databases. Start applying the patch on the source. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.