Oracle GoldenGate 12c Implementation Essentials 1Z0-447

1Z0-447

Oracle

Oracle GoldenGate 12c Implementation Essentials

http://killexams.com/exam-detail/1Z0-447

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

QUESTION: 6

You must synchronize the starting point for Replicat with the restore point of the target

database. How should you accomplish this?

A. Use the command optionAFTERCSN.

B. Use the command optionATCSN.

C. Use the command optionUNTIL CANCEL.

D. Use the command optionRESUME.

Answer: A

QUESTION: 7

What is the key purpose of GoldenGate trail files?

A. They are a persistent storage area for captured transactions.

B. They are configuration files for the GoldenGate processes.

C. They are checkpoint files for the GoldenGate processes.

D. They are database auditing logs where GoldenGate captures changes.

Answer: C

QUESTION: 8

What is the function of the GoldenGate JAgent?

A. It performs connections via JDBC to run the Veridata comparisons.

B. It enables communication between GoldenGate and Monitor, and Enterprise Manager

Agent.

C. It reads the database transaction logs.

D. It integrates GoldenGate with Oracle Data Integrator.

Answer: B

QUESTION: 9

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: 10

Which combination of DBMS, Extract, and GoldenGate version is required to avoid

using a DDL trigger?

A. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or

greater

B. any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater

C. Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or

greater

D. Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

Answer: C

QUESTION: 11

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.

Answer: D

QUESTION: 12

Your Extract process, which is using an Oracle database, has stopped with uncommitted

transactions. How should you guarantee an efficient recovery after Extract has stopped?

A. Use theFORCETRANSandPURGEORPHANEDTRANSACTIONSparameters to

control the bounded recovery feature of the general Extract checkpointing facility.

B. Use theWARNLONGTRANSparameter to control the bounded recovery feature of the

general Extractcheckpointing facility.

C. Use theBRparameter to control the bounded recovery feature of the general Extract

checkpointing facility.

D. Use thePURGEORPHANEDTRANSACTIONSparameter to control the bounded

recovery feature of the general Extract checkpointing facility.

Answer: C

QUESTION: 13

Which option is supported by GoldenGate DDL replication?

A. CREATE ROLE

B. ALTER SYSTEM

C. ALTER DATABASE

D. ALTER TABLE SYS

Answer: D

QUESTION: 14

You installed GoldenGate on your server, but you received an error when you tried to

start GGSCI. What is the reason for this issue?

A. The incorrect version of GoldenGate was installed for your CPU architecture.

B. A license key must be applied first.

C. GoldenGate Manager was not started first.

D. TheLD_LIBRARY_PATHvariable to$ORACLE_HOMEwas not set.

Answer: A

QUESTION: 15

You need to configure the source database, target database, and Oracle GoldenGate for

conflict detection and resolution (CDR). You want the full before image of each record,

but your database does not provide a before image in the log record and must be

configured to do so with supplemental logging. How should you proceed?

A. Include theOVERWRITEcommand.

B. Include theUSEDELTAcommand.

C. Include theADD TRANDATAcommand.

D. Include theUPDATAROWEXISTScommand.

Answer: C

QUESTION: 16

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

Answer: B

QUESTION: 17

Which three are valid Extract or Replicat statements using the @RANGE function for an

Acct table with a Primary Key on the AccountID column? (Select three.)

A. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));

B. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));

C. TABLE fin.Sales, FILTER (@RANGE (1, 2));

D. FILTER (@RANGE (2, 2, AccountID));

E. FILTER (@RANGE 2, 2, ID);

Answer: A, B, C

QUESTION: 18

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?

A. the number of concurrent users

B. disk space

C. system memory

D. the number of compound keys on the source tables

Answer: C

QUESTION: 19

Which parameter for GoldenGate 12c enables DDL replication for a Replicat?

A. TARGETDDL

B. GETDDL

C. DDL for Replicat is enabled by default.

D. USEDDL

Answer: C

QUESTION: 20

When is a Pump not required to connect to a source database?

A. when transformations, filtering, and mapping are required

B. when look-ups are needed against the source database

C. when aPASSTHRUparameter is used

D. when aNOPASSTHRUparameter is used

Answer: B

QUESTION: 21

Which Logdump command is used to check how many change records are in the trail

file?

A. STATS

B. REPORT

C. REPORTCOUNT

D. COUNT

Answer: D

QUESTION: 22

Which method in GoldenGate should you use to undo DML changes previously made to

a target database?

A. Run Extract and Replicat from the command line.

B. Use Extract and Replicat with the GoldenGate Logdump utility.

C. Run the Reverse Utility on the target database transaction logs.

D. Use Extract and Replicat with the GoldenGate Reverse utility.

Answer: D

QUESTION: 23

Ideally which process should be configured purge old trial files?

A. Manager

B. Extract

C. Replicat

D. Pump

Answer: A

QUESTION: 24

Your Replicat performance seems slow. Which Replicat parameter can be used to

improve performance?

A. DEFERAPPLYINTERVAL

B. BATCHSQL

C. ASSUMETARGETDEFS

D. SPECIALRUN

Answer: B

QUESTION: 25

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: 26

You must implement GoldenGate in a master-to-master configuration. What output from

the profiling scripts should you look for to ensure that your implementation is correct?

A. Tables set with nologging

B. Tables with Large Object (LOB) data types

C. Tables that have conflicts

D. Triggers and sequences

Answer: C

QUESTION: 27

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: A

Explanation:

In reference guide, page 256, and I quote "If multiple groups are reading the same set of

trail files, one process could purge a file before another is finished with it. Instead, use

theManager version of PURGEOLDEXTRACTS, which is the preferred use of the

parameter in all GoldenGate configurationsbecause it allows you to manage trail files in a

centralized fashion."

QUESTION: 28

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?

A. View the maybe out-of-sync (MOOS) queue.

B. View the Veridata log file.

C. View the confirm-out-of-sync (COOS) queue.

D. View the Veridata Agent repository.

Answer: A

QUESTION: 29

You need to locate the position of the oldest unprocessed transaction by using the

command INFO EXTRACT <extractgroup> SHOWCH. How should you proceed?

A. Use the Read Startup Checkpoint.

B. Use the Read Recovery Checkpoint.

C. Use the Write Startup Checkpoint.

D. Use the Read Current Checkpoint.

Answer: B

QUESTION: 30

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: 31

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: 32

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

A. Jagent

B. Extract

C. Replicat

D. Manager

Answer: B

QUESTION: 33

What software is required prior to running Oracle GoldenGate in a Windows Server

environment?

A. Oracle Gateway software configured for that particular database platform

B. JDBC drivers into the GoldenGate home directory

C. Microsoft Visual C++ 2010 SP1 Redistributable Package

D. Nothing, configure GoldenGate Jagent for that particular database platform.

Answer: C

QUESTION: 34

You must synchronize tables with Large Object data types. Which Initial Load method

supports this process?

A. File to Replicat

B. GoldenGate Direct Load

C. File to database utility

D. Direct bulk load to SQL*Loader

Answer: D

QUESTION: 35

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: A, C

QUESTION: 36

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

Explanation:

In reference guide, page 312,Syntax EVENTACTIONS ([STOP| ABORT |

FORCESTOP][IGNORE [TRANSACTION [INCLUDEVENT]][DISCARD][LOG

[INFO | WARNING]][REPORT][ROLLOVER][SHELL<command>][TRACE

<trace file> [TRANSACTION] [PURGE | APPEND]][CHECKPOINT[BEFORE |

AFTER | BOTH]][, ...])

QUESTION: 37

If multiple GoldenGate processes are accessing a set of trail files, which process should

include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

A. Manager

B. Replicat

C. Extract

D. Extract and Replicat

Answer: A

QUESTION: 38

Which parameter could you use to start an Extract when Manager starts?

A. START

B. BEGIN

C. AUTOSTART

D. PROCESS

Answer: C

QUESTION: 39

Your Goldengate deployment is using a shared wallet, and older versions of the master

key should be retained after the master key is renewed until all processes are using the

newest version. How should you determine whether all of the processes are using the

newest version so that you can delete older versions of the master key?

A. GoldenGate deployments cannot use a shared wallet.

B. View the GoldenGate log files to monitor Replicat report files to verify that the SCN

was applied by allReplicat groups.

C. View the report file of the newest Extract after renewing the master key to confirm the

last SCN that was mined with old key.

D. View the report file of each Extract immediately after renewing the master key to

confirm the last SCN that was mined with the old key. Then, monitor the Replicat report

files to verify that this SCN was applied by all Replicat groups.

Answer: D

QUESTION: 40

Your GLOBALS file contains the parameter SYSLOG NONE, but the system logs

contain warnings from the Manager. What could be causing this to occur?

A. The GGSCI session was configured incorrectly.

B. The Manager parameter file containsSYSLOG ALL.

C. An Extract or Replicat is overriding GLOBALS withSYSLOG WARN.

D. The user session running Manager is set to log all messages.

Answer: C

QUESTION: 41

Which statement regarding the GoldenGate Data Pump is incorrect?

A. Data Pump is a separate process.

B. Data Pump can be used to pump trail records to multiple locations.

C. Data Pump has distance limitations.

D. Data Pump uses TCP/IP to route the trail records.

Answer: A

QUESTION: 42

You want to increase parallelism for greater integrated Replicat throughput while

preserving the original transaction atomicity. How can you achieve this?

A. You can configure integrated Replicat with two parallel apply servers.

B. You can configure integrated Replicat with two parallel child servers.

C. You can configure integrated Replicat with theSPECIALRUNparameter.

D. You can configure integrated Replicat

withASSUMETARGETDEFSandSPECIALRUNparameters.

Answer: A

QUESTION: 43

You are implementing GoldenGate monitoring via the Enterprise Manager Plug-In.

When you start JAgent, it fails with “ajavA.lang.Exception: One or more Java Agent

properties in Config.properties are not defined properly”. What is the first thing to check?

A. if The Enterprise Manager Agent is running

B. if the JAgent has been enabled in the GoldenGate Manager

C. if the agent type is set to OEM in JAgent properties

D. if the Oracle Wallet has been created for the JAgent

Answer: C

QUESTION: 44

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

Answer: D

QUESTION: 45

What file must be configured in order to use custom encryption keys?

A. ENCKEYS

B. ENCRYPT

C. GLOBALS

D. CUSTKEYS

Answer: A

QUESTION: 46

You want to eliminate the reporting output from processing a Macro. How should you

proceed?

A. Use the optional parameterNOLIST.

B. Use the optional parameterUNLIST.

C. Use the optional parameterNOREPORT.

D. Use the optional parameterNOMACROOUTPUT.

Answer: A

QUESTION: 47

Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle

GoldenGate?

A. ENABLE_GOLDENGATE_REPLICATION=true

B. ENABLE_STREAMS_REPLICATION=true

C. Configure theSTREAMS_POOL_SIZEdatabase parameter

D. ENABLE_DATABASE_REPLICATION=true

Answer: A

QUESTION: 48

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

QUESTION: 49

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: 50

How can you tell if GoldenGate has been configured for batch processing?

A. TheSPECIALRUNparameter is in the Replicat parameter file.

B. Replicat is started with theINITIALLOADtask.

C. There is a dedicated GoldenGate process calledSPECIALRUN.

D. TheSPECIALRUNparameter is in theGLOBALSparameter file.

Answer: B

QUESTION: 51

How should you configure Replicat to control how errors are handled in one-way

replication?

A. UseREPERRORin the Replicat parameter file.

B. UseHANDLECOLLISIONin the Replicat parameter file.

C. Use Conflict Detection and Resolution in the Replicat parameter file.

D. UseMAPEXCEPTIONin the Replicat parameter file.

Answer: A

QUESTION: 52

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?

A. Configure Replicat with theFORMATASCII SQLLOADER OPTION.

B. Configure Extract with theFORMATSQL SQLLOADER OPTION.

C. Configure Extract with theFORMATASCII SQLLOADER OPTION.

D. Configure Replicat with theFORMATXML OPTION.

Answer: C

QUESTION: 53

Which two are valid macros?

A. Option A

B. Option B

C. Option C

D. Option D

Answer: A, D

QUESTION: 54

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: 55

Which statement is valid for DDL replication?

A. GoldenGate User Exits are not supported for DDL.

B. Source and target objects can be different.

C. Target objects can be different from source when usingSOURCEDEFSin Replicat.

D. It can useWILDCARDRESOLVE IMMEDIATE.

Answer: B

QUESTION: 56

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: 57

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: 58

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

QUESTION: 59

You must configure GoldenGate parameter files for conflict resolution and want to be

sure that the before values are compared with current values in the target database to

detect update and delete conflicts. How should you accomplish this?

A. Use theCOMPCOLSwith theGETUPDATEBEFORESoption of the MAP parameter in

the Replicat parameter file to specify columns that are to be used with before values in

the ReplicatWHERE clause.

B. Use theCOMPARECOLSoption of the MAP parameter in the Replicat parameter file

to specify columns that are to be used with before values in the ReplicatWHEREclause.

C. Use theGETUPDATEBEFORESoption of the MAP parameter in the Replicat

parameter file to specify columns that are to be used with before values in the

ReplicatWHEREclause.

D. Use theGETBEFORECOLSoption of the MAP parameter in the Replicat parameter

file to specify columns that are to be used with before values in the

ReplicatWHEREclause.

Answer: B

QUESTION: 60

Which parameters) would be used for one-time initial replicat?

A. PASSTHRU

B. SOURCEISFILE

C. CHECKMINUTES

D. SOURCEISTABLE

E. SPECIALRUN

Answer: E

QUESTION: 61

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: 62

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: 63

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

QUESTION: 64

Which option is an invalid GLOBALS parameter?

A. DISCARDFILE

B. GGSCHEMA

C. MGRSERVNAME

D. CHECKPOINTTABLE

Answer: A

QUESTION: 65

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: 66

You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio

should be used?

A. Oracle Goldengate for Big Data

B. Oracle Goldengate Application Adapters

C. Oracle Goldengate Veridata

D. Oracle Data Integrator Adapters

Answer: B

QUESTION: 67

Select four Oracle GoldenGate use cases.

A. real-time discovery

B. real-time data warehousing

C. offload reporting

D. zero downtime upgrades and migrations

E. backup and recovery

F. data center load balancing by using multi-master replication

Answer: B, C, D, F

QUESTION: 68

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: 69

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

QUESTION: 70

You are running multiple installations of Oracle GoldenGate on the same Windows

server. How can you differentiate the different Manager services?

A. Create aGLOBALSfile for each installation and use theMGRSERVNAMEparameter,

with a unique name.

B. Include the parameterSERVICENAMEin each Manager, with a unique name.

C. Accept the default service name and manually edit within the Services applet.

D. Multiple Manager services are not allowed on the same Windows server.

Answer: A

QUESTION: 71

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 andEXTTRAILis for local trails.

D. Extract is typically used to produce local trail files over a TCP/IP connection.

Answer: B

QUESTION: 72

Replicat makes checkpoints in the trail file to mark its last read position. Select two ways

to create checkpoint tables.

A. Run thechkpt_db_extracttrail.sqlscript.

B. Run thechkpt_db_create.sqlscript.

C. Use theADD Extract Trailcommand.

D. Use theINFO REPLICATcommand with theSHOWCHoption.

E. Use theADD CHECKPOINTTABLEcommand.

Answer: B, E

For More exams visit http://killexams.com