Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
P.S. Virtual 1Z0-447 item pool are available on Google Drive, GET MORE: https://drive.google.com/open?id=1PueIYJkx_M0YvO94U6nbPgKjS5EVb7MC
Q1. Ideally which process should be configured purge old trial files?
A. Manager
B. Extract
C. Replicat
D. Pump
Answer: A
Q2. 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.
Answer: D
Q3. Identify two correct statements regarding GoldenGate supported features.
A. GoldenGate supports network encryption and compression.
B. GoldenGate supports DML and DDL replication for all supported databases.
C. GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source.
D. GoldenGate for SQLServer supports only SQLServer Standard Edition as a source.
Answer: AC
Q4. 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.
Answer: C
Q5. 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.
Answer: A
Q6. 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
Q7. Which two are valid macros?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A D
Q8. How does Replicate know the structure of the source tables when the target has a different layout?
A. GoldenGate trail file contains the metadata of incoming data
B. Replicat uses an ODBC connection to connect to the source system tables
C. Parameter file contains table layouts
D. Discard file contains table layouts
E. Source Definitions file contains table layouts
Answer: E
Q9. Which statement correctly explains when you would use ASSUMETARGETDEFS?
A. The target tables are already created.
B. Only the fields in the target tables are mapped.
C. The source and target tables have identical data structure.
D. You have specified wildcards in either the TABLE or MAP parameters
Answer: C
Q10. Which three types of information are stored in the GoldenGate trial header?
A. Before or after image indicator
B. Data type (e.g. integer, alphanumeric)
C. Relative byte address of the commit record
D. Time of the transaction
Answer: A B C
P.S. Easily pass 1Z0-447 Exam with 2passeasy Virtual Dumps & pdf vce, Try Free: https://www.2passeasy.com/dumps/1Z0-447/ ( New Questions)