Free Oracle GoldenGate 12c Implementation Essentials 1Z0-447 Exam Practice Test

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to--database utility. How should you configure GoldenGate in order to accomplish this?

• Configure Replicat with theFORMATASCII SQLLOADER OPTION.
  
• Configure Extract with theFORMATSQL SQLLOADER OPTION.
  
• Configure Extract with theFORMATASCII SQLLOADER OPTION.
  
• Configure Replicat with theFORMATXML OPTION.
  

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

• Jagent
  
• Extract
  
• Replicat
  
• Manager
  

Select four Oracle GoldenGate use cases.

• real-time discovery
  
• real-time data warehousing
  
• offload reporting
  
• zero downtime upgrades and migrations
  
• backup and recovery
  
• data center load balancing by using multi-master replication
  

If multiple GoldenGate processes are accessing a set of trial files which of the processes should include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

• Manager
  
• Extract
  
• Replicat
  
• Both Extract and Replicat
  

Which three are required to correctly configure an OGG?

• A maximum file size
  
• An extract process
  
• A trail file identifier
  
• Designation as local or remote
  

You want to use multiple concurrent Extract process groups. What is the key factor in determining how many can be running at the same time?

• the number of concurrent users
  
• disk space
  
• system memory
  
• the number of compound keys on the source tables
  

You must implement GoldenGate in a secure environment. How should you proceed in order to protectGoldenGate data from theft?

• Implement trail file encryption.
  
• Ensure that passwords are encrypted.
  
• Ensure that network communications are encrypted.
  
• Ensure that table-level Transparent Data Encryption is implemented.
  

By default which type of operations are captured by extract?

• Inserts, updates, deletes, and table operations such as CREATE TABLE
  
• Inserts, compresses, and updates
  
• Inserts, updates, deletes, and table operations such as ADD COLUMN
  
• Inserts only
  
• Inserts, updates, and deletes
  

Veridata has completed the initial comparison and you want to view the rows that appear to be out-of-sync. How can you do this?

• View the maybe out-of-sync (MOOS) queue.
  
• View the Veridata log file.
  
• View the confirm-out-of-sync (COOS) queue.
  
• View the Veridata Agent repository.
  

Your GLOBALS file contains the parameter SYSLOG NONE, but the system logs contain warnings from the Manager. What could be causing this to occur?

• The GGSCI session was configured incorrectly.
  
• The Manager parameter file containsSYSLOG ALL.
  
• An Extract or Replicat is overriding GLOBALS withSYSLOG WARN.
  
• The user session running Manager is set to log all messages.