1Z0-447 | The Replace Guide To 1Z0-447 vce

New Questions 3

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

New Questions 4

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

New Questions 5

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

New Questions 6

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

New Questions 7

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

New Questions 8

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

A. DEFERAPPLYINTERVAL

B. BATCHSQL

C. ASSUMETARGETDEFS

D. SPECIALRUN

Answer: B

New Questions 9

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

New Questions 10

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

New Questions 11

Ideally which process should be configured purge old trial files?

A. Manager

B. Extract

C. Replicat

D. Pump

Answer: A

New Questions 12

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