QUESTION NO: 1
Which statements are true of
goldenGate password encryption?
A password can be encrypted and pasted into a parameter
file.
An encrypted password can be generated using the default
key.
An encrypted password can be generated using a user
defined-key.
A. 1 only
B. 2 only
C. 3 only
D. 1 and 3
E. 1, 2 and 3
Answer: E
QUESTION NO: 2
You want to
configure replication of CREATE TABLE statements from oracle to Teradata, so
that only new table created in your mapped source schema is Replicated. Which
should be the part of solution?
A. This feature is not
supported in oracle goldenGate 10.
B. DDL INCLUDE MAPPED in
extra parameter file.
C. DDL INCLUDE UNMAPPED in
extra parameter file.
D. DDL EXCLUDE MAPPED in
extra parameter file.
Answer: B
QUESTION NO: 3
Which
translations are captured if you ADD EXTRACT BEGIN now 1:00 p.m., but START
EXTRACT at 2:00 p.m.?
A. Transactions started on or
after 1:00 p.m.
B. Transactions started on or
after 2:00 p.m.
C. Transactions started
before 1:00 p.m and committed after 1:00 p.m.
D. Transactions started
before 1:00 p.m and committed after 2:00 p.m.
Answer: D
QUESTION NO: 4
You want
encrypt message sent or over TCP/IP to server usserver1, where the goldenGate
manage process is running on port 7809. Your requirements include using a
custom encryption key and advanced encryption standard (AES), and you have
created an ENCKEYS file What parameters should you use?
A. This feature is not
supported in oracle goldenGate 10.
B. RMTHOST usserval, MGRPORT
7809, ENCRYPT AES, ENCRYPT KEY
C. RMTHOST usserval, MGRPORT
AES, ENCRYPTKEY MYKWY, MBRPORT 7809
D. RMTHOST usserval, MGRPORT
7809, ENCRYPT BLOWFISH ENCRYPTKEY MYKEY
Answer: D
QUESTION NO: 5
Which three
describe a valid OGG Event Action?
A. Stop the process
B. Write a checkpoint before
and/or after writing the record to the trail.
C. Run a shell command
D. Purge old trail files
Answer: A,B,C
QUESTION NO: 6 CORRECT TEXT
By default,
which option is evaluated first, SQLEXEC or filter statement?
A) SQLEXEC
B) FILTER
C) There is no default; it is
set with the after filter I before filter.
D) It depends on their
position in the parameter file; the first encountered is executed first.
Answer: B
QUESTION NO: 7
Which
argument is used to set the maximum size of the EXTTRAIL or RMTTRAL.
A. MAXSIZE
B. TRAILSIZE
C. HAXTRAILSI2E
D. TRAILMAXSIZE F
E. MEGABYTES
Answer: E
QUESTION NO: 8
Which
Manager Parameter sets will report current lag every hour and write a critical
message for any Extract/Replicate with a lag over 60 minutes?
A. LAGBEPOBTHOURS 1, LAGINFO
1 and LAGCRITICAL 60
B. LAGREPORTMINUTES 60,
LAGINFOHOURS 1
C. LAGREPOBT 1,
I.AGCRITICALHOURS 1
D. LAGREPOBTHOURS 1,
LAGINFOMINUTES 30, LAGCR JTTCAI-M I
Answer: B
QUESTION NO: 9
What
parameter provides options for compression and encryption?
A. RMTHOST
B. TARGET
C. TCPIP
D. TARGET DB
Answer: A
QUESTION NO: 10
What
GoldenGate process is responsible for capturing changes in the source database?
A. Manager
B. Replicate
C. Extract
D. Server Collector
Answer: C
QUESTION NO: 11
You have
configured and added the extract and Replicate tasks 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 and
then start the Replicat task.
C. Start the Extract task;
wait for it to stop and then start the Replicate task.
D. Start the Replicate task
Answer: B / A
QUESTION NO: 12
You are
configuring replication between two Oracle tables with the same number of
columns, column table names, and data types, but in different orders. For
replication purpose can you treat these as identical tables?
A. No
B. Yes, if the source and
target Oracle versions and character sets are the same.
C. Yes
D. Yes, as long as the source
table has a primary key define
Answer: D / A
QUESTION NO: 13
What us
expected behavior of CHEKPARMS parameter?
A. The process checks the
parameter syntax and then starts running.
B. The process checks the
parameter syntax and then stops.
C. A report file is created
listing all missing parameters.
D. A report file is created
listing all default values not specified in the parameter file.
Answer: A / B
QUESTION NO: 14
What
GoldenGate facility allows for custom processing in response to a data value?
A. DDLGEN
B. GGSExec
C. User Exits
D. User Tokens
Answer: C
QUESTION NO: 15
How do you
control the size of the buffer that contains data extracted from an ASM
instance?
A. TRANLOGOPTIONS ASMBUFSIZ
B. DBOPTIONS ASMBUFSIZE
C. TRANLOGOPTIONS BUFSIZE
D. DBOPTIONS BUFSIZE
Answer: A
QUESTION NO: 16
How do you
control the size of the buffer that contains data extracted from?
A. TRANLOGOPTIONS ASMBUFSIZE
B. DBOPTIONS ASMBUFSIZE
C. TRANLOGOPTIONS BUFSIZE
D. DBOPTIONS BUFSIZE
Answer: C
QUESTION NO: 17
What three
are valid responsibilities of the OGG Manager?
A. Cleaning up GoldenGate
trails.
B. Starting dynamic
processes, such as Server Collectors, extracts, replicates.
C. Error and lag reporting.
D. Communicating with other
GoldenGate Manager processes
Answer: A, B, C
QUESTION NO: 18
You have
implemented multi-master Oracle/Oracle replication without a provision to
exclude transactions committed by a Replicat process. What errors are likely to
occur?
A. Inserts will generate a
primary key uniqueness violation; deletes will generate a 'no matching
row' not found error; updates
will continue forever.
B. None: loop detection is on
by default in Oracle.
C. New inserts will be
processed without issue; updates and deletes will generate a "row not
found" error.
D. Updates and deletes will
be replicated without issue new inserts will generate a primary key
uniqueness violation.
Answer: B
QUESTION NO: 19
What three
types of information are reported in discard file?
A. The details of the
discarded records
B. The database error message
C. The trial file sequence
number
D. Runtime statistics
Answer: A, B, C
QUESTION NO: 20
Which
command forces a running Extract to close the current trial and start writing
to the next trial sequence number?
A. ALTER EXTTRAIL <trail
name>, NEXTSEQNO
B. ALTER EXTTRAIL <trail
name>, ROLLOVER
C. SEND EXTRACT
<group>, ETROLLOVER
D. SEND EXTRACT <group>,
ROLLOVER
Answer: D
QUESTION NO: 21
To meet a
business requirement for latency, Carlos wants to break long-running source
transactions into shorter commits on the target database with the replicate
parameter MAXTRANSOPS what is the most important thing Carlos should consider
before using MAXTRANSOPS
A. Will business logic be
lost if transaction boundaries are changed?
B. Will a large number of
small commits perform better than a smaller number of large commits?
C. Will redo buffer size on
the target database be adequate for the commit size?
D. Will the sequence of
operations be affected by changing transaction boundaries?
Answer: B
QUESTION NO: 22
In
GoldenGate terms, what is the definition of Extract lag?
A. The difference in time
between when a change is made to source data and when that change is
reflected in the target data.
B. The difference in time
between the current times at the target system.
C. The difference in time
between when a change record is received at the target system and
when the change is reflected
in the target data.
D. The difference in time
between when a change record is processed by the extract and the
timestamp of the record in
the data source.
Answer: D
QUESTION NO: 23
Which OGG
process (es) can change data in database?
A. Replicat only
B. Extract only
C. Extract and Replicat
D. Extract, Replicat and
Manager
Answer: C
QUESTION NO: 24
You have a
source installation of OGG l0 that includes an initial extract and datapump to
provide a remote trail formatted for a GoldenGate 9.5 Replicat process to
consume, which process should be use to convert the data to the earlier format?
A. From the first Extract
process
B. From the Data Pump process
C. From replicate process
D. This feature is not
supported in GoldenGate 10.
Answer: A
QUESTION NO: 25
You are
responsible for replication between your central office and twelve regional
nodes. What is the best product for you to use to actively monitor thirteen
GoldenGate TDM instances and configure email alerts based on process status?
A. Oracle GoldenGate Director
B. Oracle GoldenGate
Transactional Data Management
C. Oracle GoldenGate veridata
D. Oracle GoldenGate Monitor
Answer: A
QUESTION NO: 26
Which GGSCI
command(s) show all available information on both read and write checkpoint for
an
Extract?
Example: 1
INFO EXTRACT <group name>
Example: 2
INFO EXTRACT <group name>, DETAIL
Example: 3
INFO EXTRACT <group name>, SHOWCH
A. Example 2 only
B. Example 3 only
C. Examples 1 and 3
D. Examples 1 and 2
Answer: B
QUESTION NO: 27
How would
you specify the data source for a secondary Extract functioning as a data pump?
A. EXTTRAILSOURCE
B. SOURCEISTABLE
C. SOURCEISTRAIL
D. LOCTRAILSOURC
Answer: C
QUESTION NO: 28
In order to
add delete Replicat processes without specifying a checkpoint table, Gerald has
edited the GLOBALS parameter file. To get the change to take effect, Gerald
exits from the GGSCI command line, but GGSCI fails to restart. Which solution
Is most likely to solve Gerald's problem?
A. Use a text editor to check
the GLOBALS file for syntax errors and fix them
B. Use the cleanup replicat
command
C. Verify that Oracle
environment variables are set correctly
D. Add the Oracle GoldenGate
Installation directory to the system PATH
Answer: A
QUESTION NO: 29
Where can
you find a list of the parameters being used by a Replicat process?
A. System logs
B. Discard file
C. Event log
D. Process report
Answer: D
QUESTION NO: 30
Which
process (es) maintain a checkpoint file?
A. Extract only
B. Replicat only
C. Both Extract and Replicat
D. Server collector
Answer: C
QUESTION NO: 31
In addition
to using the parameter comment to enter remarks in parameter file(s) can be
used?
A. - -
B. //
C. \\
D. /*
Answer: A
QUESTION NO: 32
Which three
can GoldenGate encrypt?
A. Extract to Server messages
B. Trails
C. Passwords
D. Redo logs
Answer: A,B,C
QUESTION NO: 33
Which
parameter tells Extract the tables for which to capture changes?
A. Table
B. LOGTABLE
C. MAP C
D. LOG
Answer: A
QUESTION NO: 34
Where are
GoldenGate macros defined?
A. Macros can be defined in
the parameter file or included in a macro file
B. Macros are defined in the
GLOBALS parameter file
C. Macros are placed in a
file and referenced using an environment variable.
D. Macros are declared,
compiled and referenced via Golden Gate's user exits.
Answer: A
QUESTION NO: 35
If your
system has a firewall controlling port access which parameter can be used to
control ports used for GoldenGate processes?
A. CHILDPORTS
B. ALLOWEDPORTS
C. DYNAMICPORTLIST
D. GETPORTINFO
Answer: C
QUESTION NO: 36
Which statement
best describes the record Image that an Extract process stores in the
GoldenGate trail by default?
A. The new value for updated
fields; the primary key for deleted rows; the after-Image for inserts
B. An image of the contents
of the record after the insert, update or delete operation
C. An after image for inserts
and a before image for updates and deletes
D. An after image for Inserts
and updates and a before image for deletes
Answer: C
QUESTION NO: 37
When
GoldenGate is configured for Archived Only Mode (ALO), what must be considered
configuring the middle-tier server for Capture?
A. The middle-tier capture
server has the same endian order and bit width
B. The middle-tier server
must have a database installed on it
C. GoldenGate only supports
Windows or Linux on the middle-tier server
D. GoldenGate only supports
UNIX on the middle-tier server
Answer: B
QUESTION NO: 38
You are
configuring a multi-master DDL replication environment. To prevent looping of
DDL statement like CREATE TABLE (....), the best solution is______.
A. Include the tranlogoptions
(exclude user) parameter in each Extract parameter file
B. Use the add FILTERTABLE
command at the GGSCI prompt
C. Use DDL exclude OPTYPE
(create table. . . ) in one Extract to prevent looping
D. This feature is not
supported in GoldenGate 10.
Answer: C
QUESTION NO: 39
You have
source table with PRODUCT-ID column and target table with
PRODUCT_DESCRIPTION.
On the target database is a lookup table containing product codes and
corresponding description. What is good way for you to lookup the product
description for each transaction?
A. SQLEXEC ( )
B. DBLOOKUP ( )
C. DBLOGIN ()
D. SQLLOOKUP ( )
Answer: A
QUESTION NO: 40
How many
Extracts can write to the same GoldGate trail?
A. Only one
B. Up to 10
C. Up to 50
D. Unlimited
Answer: A
QUESTION NO: 41
Which
utility is responsible for generating source data definitions files?
A. EMSCLNT
B. COBGEN
C. DDLGEN
D. DEFGEN
Answer: D
QUESTION NO: 42
Which
statement correctly describes GoldenGate Extract and Replicat process reports?
A. By default process reports
are named for the Extract or Replicat group and up to 99 old reports
can be saved depending on the
REPORTUM parameter.
B. By default process reports
are named for the Extract or Replicat group and up to 10 old reports
are kept.
C. Process reports take the
name set by the optional report parameter of the ADD extract replicat
command and up to 99 old
reports can be saved depending on the REPORTNUM parameter.
D. Process reports take the
name set by the required report file parameters and up to 10 old
reports will be saved.
Answer: D
QUESTION NO: 43
Which
statements are true for a two-node, active-active OGG replication
configuration?
Both
databases may be lived and processing transactions.
The two
databases must be homogeneous.
Low latency
reduces the risk of conflicts.
A. 1 and 2
B. 2 and 3
C. 1 and 3
D. I, 2, and 3
Answer: B
QUESTION NO: 44
What is
GGSCI an acronym for?
A. GoldenGate secure command
interface
B. GoldenGate software
command interface
C. GoldenGate software
connection interface
D. GoldenGate secure
connection interface
Answer: B
QUESTION NO: 45
You have a
requirement to extract changes from an oracle 10g database without installing
or running any GoldenGate processes on the host server. To accomplish this, which
GoldenGate process parameter is most likely to be part of your solution?
A. TRANLOGOPTIONS
ARCHIVEDLOGONLY
B. WILDCARDRESOLVE DYNAMIC
C. This configuration is not
supported in GoldenGate 10.
D. ASSUMETARGETDEFS
Answer: A
QUESTION NO: 46
Where is user
token data stored?
A. Trail file
B. Parameter file
C. Discord file
D. Report file
Answer: A
QUESTION NO: 47
What command
is issued to alter Replicat to start processing trail number 10 at relative
byte address 100345?
A. Alter <group>,
extseqno 10, extrba 100345
B. Alter Replicat *, exttrail
<trail prefix>, extseqno 10, extrba 100345
C. Alter Replicat
<group>, sequence lO, rba 100345
D. Alter <group>,
sequence 10, rba 100345
Answer: A
QUESTION NO: 48
Neither your
source, nor your target table has a primary key, and you have not designated
KEYCOLS. How will the Replicat proceed to identify matching target rows to
update or delete?
A. The first unique key
alpha-numerically, excluding virtual columns and nullable columns, will be
treated as the primary key.
B. This configuration is not
supported by GoldenGate; Replicat will abend on updates or deletes.
C. The first column,
excluding virtual columns and nullable columns, will be treated as the pr key.
D. The combination of all
fields up to the first thirty-two will be treated as a compound primary key
Answer: A
QUESTION NO: 49
Which best
describes the function of OGG user tokens?
A. User-defined variables
B. Security tokens
C. User privileges
D. User-defined functions
Answer: A
QUESTION NO: 50
What could
you use to formal 123456789 to format of social security number 123-456-789?
A. @STRCAT ()
B. @STEXT ()
C. @strext () and @strcat ()
D. @STRFIND ( )
Answer: C
QUESTION NO: 51
Replicat is
responsible for which three options?
A. Reading data out of the
GoldenGate trails.
B. Performing data flow
filtering.
C. Performing data
transformations.
D. Check pointing the oldest
uncommitted transaction.
Answer: A,B,C
QUESTION NO: 52
What
GoldenGate process writes to RMTTRAILS?
A. Server/Collector
B. Extract
C. Pump
D. Replicat
E. All of the above
Answer: B
QUESTION NO: 53
How does
Replicat 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
QUESTION NO: 54
What is the
default threshold for message compression in OGG?
A. 1000
B. 100
C. O
D. By default, messages are
not compressed.
Answer: A
QUESTION NO: 55
What is the
name and the location of the file that lists the key values used by extract for
encryptions and Server Collector for decryption?
A. KEYGEN file in the GoldenGate
data location
B. COBGEN file in the
GoldenGate installation location
C. GGSKEY file in the
GoldenGate data location
D. GGSKEY file in the
GoldenGate installation location
E. ENCKEYS file in the
GoldenGate installation location
Answer: E
QUESTION NO: 56
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: 57
Which three
are types of encryption supported by OGG?
A. Parameter file encryption
B. Password
C. Trial file encryption
D. Message encryption
Answer: A,B,C
QUESTION NO: 58
Which three
are required to correctly configure an OGG?
A. A maximum file size
B. An extract process
C. A trailfile identifier
D. Designation as local or
remote
Answer: B,C,D
QUESTION NO: 59
What process
is the recommended method to purge old GoldenGate trials?
A. Extract r
B. Replicat
C. Manager
D. Manager and Replica
Answer: C
QUESTION NO: 60
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
QUESTION NO: 61
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?
A. Manager
B. Extract
C. Replicat
D. Both Extract and Replicat
Answer: D
QUESTION NO: 62
Which
parameter could you use to start an Extract when Manager starts?
A. START
B. BEGIN
C. AUTOSTART
D. PROCESS
Answer: C
QUESTION NO: 63
Which could
be used to map a value stored in a user token to a target column?
A. @GETENV
B. GGHEADER
C. GGENVIRONMENT
D. ©TOKEN
Answer: D
QUESTION NO: 64
Ideally
which process should be configured purge old trial files?
A. Manager
B. Extract
C. Replicat
D. Pump
Answer: A
QUESTION NO: 65
When would
you use the PASSTHRU parameter?
A. When using a data pump to
distribute all of the trail data "as is" to a remote system.
B. When Extract is processing
database transaction logs where you have a remote database
connection.
C. For a SPECIALRUN one-time
processing task that is doing an initial load.
D. When Extract is processing
database transaction logs and writing to a local trial that will be
read by a local Replicat.
Answer: A
QUESTION NO: 66
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
QUESTION NO: 67
What Oracle
GoldenGate feature provides recoverability without loss of transactions?
A. Checkpointing
B. Sub-second latency
C. Two-phase commits
D. Transactional integrity
Answer: A
QUESTION NO: 68
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
QUESTION NO: 69
What file
must be configured in order to use custom encryption keys?
A. ENCKEYS
B. ENCRYPT
C. GLOBALS
D. CUSTKEYS
Answer: A
QUESTION NO: 70
Which
parameters would be used for one-time initial replicat?
A. PASSTHRU
B. SOURCEISFILE
C. CHECKMINUTES
D. SOURCEISTABLE
E. SPECIALRUN
Answer: E
QUESTION NO: 71
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
QUESTION NO: 72
You have
discovered that an OGG checkpoint table has become corrupted. What is 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
QUESTION NO: 73
Which
database platform does GoldenGate not natively support?
A. Sybase
B. FoxPro
C. DB2
D. Teradata
Answer: B
QUESTION NO: 74
What is the
GoldenGate command line interface?
A. SQLCUI
B. GGSCI
C. GGCTRL
D. GGCUI
Answer: B
QUESTION NO: 75
When
implementing GoldenGate on a 11gR2 Oracle database and after running the
GoldenGate
Database
profiling script, you discover that certain objects are compressed, what should
you do?
A. Contact Oracle support
B. Continue the
implementation of OGG and exclude those objects from replication
C. Configure OGG with Classic
Capture
D. Configure OGG with
Integrated Capture
Answer: D
QUESTION NO: 76
Which
Replicat parameter is used when looking up table definitions in a file?
A. SPECIALRUN
B. DEFERAPPLYINTERVAL
C. SOURCEISFILE
D. SOURCEDEFS
Answer: D
QUESTION NO: 77
Select the
function that stores environmental values.
A. GGENVIRONMENT
B. @COLGEN
C. @GETENV
D. ETOKEN
Answer: C
QUESTION NO: 78
Select the
statement that is supported by OGG DDL Replication.
A. ENCRYPT
B. ALTGLOBAL
C. CREATE ROLE
D. ALTDB
Answer: C
QUESTION NO: 79
Select the
commands that give statistics regarding OGG process and memory resource usage.
A. SEND…REPORT
B. SEND…STATS
C. SEND...CACHEMGR
D. INFO…SHOWSTATS
Answer: C
No comments:
Post a Comment