Exam Title: Oracle GoldenGate 12c Implementation Essentials
Exam Number: 1Z0-447
Exam Price: $245.00 More on exam pricing
Format: Multiple-Choice
Duration: 120 Minutes
Number of Questions: 72
Passing Score: 69%
Validated Against: Exam has been validated against Oracle GoldenGate 12c.
Recommended Training Take Recommended Training Courses
Complete one of the courses below to prepare for your exam (optional):
Oracle GoldenGate 12c: Fundamentals for Oracle
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Oracle GoldenGate 12c Certified Implementation Specialist
Oracle GoldenGate (OGG) Overview
Describe OGG functional overview and common topologies
Describe OGG Veridata and Management Pack functionality
Describe the difference between real-time data integration replication and Data Manipulation Language (DML) replication
Install and Configure OGG
Download and Install OGG, and differentiate between various installers (zip, OUI, tar)
Synchronize source and target databases with the Initial Load
Prepare database for OGG CDC and check databases with OGG schema check script
Configure OGG Replication component parameter files
Configure the OGG Command Interface to create OGG processes
Describe how to identify and resolve issues in heterogeneous replication, and provide appropriate solutions
Configure OGG utilities
Mapping and Transformation Overview
Implement use cases for transformation functions
Implement macros
Managing and Monitoring Oracle GoldenGate
Manage OGG command and data security
Implement and troubleshoot OGG Monitoring
Explain the configuration and management of the Enterprise Manager 12c plug-in
Implement and troubleshoot OGG Veridata
Architecture Overview
Describe OGG components
Create the two types of Capture processes for Oracle database
Create the three types of Replicat processes
Explain the difference between an Extract and Pump, and local and remote trails
Configure OGG’s process recovery mechanism
Parameters
Describe and compare GLOBALS versus MANAGER parameters
Create solutions using component parameters for replication requirements
Install OGG parameters
Explain and identify parameters specific for non-Oracle databases
Configuration Options
Describe OGG configuration options (Data Definition Language (DDL), compression and encryption options)
Configure OGG event actions based on use cases
Troubleshoot conflict detection and resolution
Configure Integrated Capture, Replicat, and deployment options
QUESTION 1
You need to look up table definitions in a file. Which Replicat parameter should you use?
A. ASSUMETARGETDEFS
B. COLMATCH
C. SOURCEDEFS
D. MAP
Answer: C
QUESTION 2
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
QUESTION 3
Which three are required to correctly configure an OGG?
A. A maximum file size
B. An extract process
C. A trail file identifier
D. Designation as local or remote
Answer: B,C,D
QUESTION 4
Which GLOBALS parameter is required to initially enable monitoring?
A. JAGENTMONITORING
B. ENABLEMONITORING
C. ENABLEOEMMONITORING
D. CHECKMONITORING
Answer: B
QUESTION 5
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
Answer: C
Click here to view complete Q&A of 1Z0-447 exam
Certkingdom Review, Certkingdom PDF Torrents
Best Oracle 1Z0-447 Certification, Oracle 1Z0-447 Training at certkingdom.com
