CREAR TEST

TEST BORRADO, QUIZÁS LE INTERESE: GoldenGate Exam 002 Q/A

COMENTARIOS	ESTADÍSTICAS	RÉCORDS

REALIZAR TEST

Título del Test: GoldenGate Exam 002 Q/A Descripción: Questions and amswers for GG Autor: GHS OTROS TESTS DEL AUTOR Fecha de Creación: 06/10/2024 Categoría: Arte Número Preguntas: 50

COMPARTE EL TEST

Comentar

No hay ningún comentario sobre este test.

Temario:

Which parameter could you use to start an Extract when Manager starts? AUTOSTART BEGIN START PROCESS. What GoldenGate process writes to RMTTRAILS? Server/Collector Pump All of the above Replicat Extract . With BATCHSQL enabled, what causes a Replicat to use normal mode operation? Statements which cause errors. When BATCHSQL and GROUPTRANSOPS coexist. Statements with rows between 8k and 24k in length. When server memory < 8GB. Which parameters would be used for one-time initial Replicat? PASSTHRU SOURCEISTABLE CHECKMINUTES SOURCEISFILE SPECIALRUN. You have a source table with a PRODUCT_ID column and a target table with PRODUCT_DESCRIPTION column. On the target database, there is a lookup table containing product codes and corresponding descriptions. What should you use to look up the PRODUCT_DESCRIPTION for each transaction? SQLEXEC ( ) SQLLOOKUP ( ) DBLOGIN ( ) DBLOOKUP ( ). Which replication topology requires conflict resolution? Broadcast Consolidation Cascading Master-to-Master. What Oracle GoldenGate feature provides recoverability without loss of transactions? Checkpointing Sub-second latency Transactional integrity Two-phase commits. 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? Do not specify those columns in the ADD TRANDATA command. Use the COLS and COLSEXCEPT options in the TABLE parameter. Use the COLMAP option in the MAP parameter. Use the FILTER option in the MAP parameter. Select the function that stores environmental values. GGENVIRONMENT ETOKEN @COLGEN @GETENV. Which is an incorrect syntax for connecting to a source or target database by an Extract or Replicat? SOURCEDB SourceDSN TARGETDB TargetDSN USERID sampleID PASSWORD samplepword SOURCEDB sampleDB USERID sampleID PASSWORD samplepword TARGETDB sampleID samplepword. Which option is supported by GoldenGate DDL replication? ALTER SYSTEM ALTER TABLE SYS CREATE ROLE ALTER DATABASE. What is expected behavior of CHECKPARAMS parameter? A report file is created listing all missing parameters. The process checks the parameter syntax and then stops. A report file is created listing all default values not specified in the parameter file. The process checks the parameter syntax and then starts running. You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover from this? Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and regenerate the checkpoint table. Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files. Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files. Restore the target DB from backup, reposition the Extract to a point prior to the corruption, turn on HANDLECOLLISIONS in the Replicat. 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? Inserts will generate a primary key uniqueness violation; deletes will generate a 'no matching row' not found error; updates will continue forever. Updates and deletes will be replicated without issue new inserts will generate a primary key uniqueness violation. None: loop detection is on by default in Oracle. New inserts will be processed without issue; updates and deletes will generate a "row not found" error. Your Replicat performance seems slow. Which Replicat parameter can be used to improve performance? ASSUMETARGETDEFS DEFERAPPLYINTERVAL SPECIALRUN BATCHSQL. What process is the recommended method to purge old GoldenGate trails? Manager Extract Manager and Replicat Replicat. What is the key purpose of GoldenGate trail files? They are configuration files for the GoldenGate processes. They are checkpoint files for the GoldenGate processes. They are database auditing logs where GoldenGate captures changes. They are a persistent storage area for captured transactions. You must implement GoldenGate in a secure environment. How should you proceed in order to protect GoldenGate data from theft? Ensure that table-level Transparent Data Encryption is implemented. Implement trail file encryption. Ensure that network communications are encrypted. Ensure that passwords are encrypted. What is the SOCKSPROXY sub-parameter of the RMTHOST parameter typically used for? Configuring remote database access. Remote capturing. Connecting to a source database via secure communication. Replicating information using a SOCKS5 proxy server, thereby creating a tunnel for TCP communication between a source Extract and a target process. Which option is an invalid GLOBALS parameter? DISCARDFILE GGSCHEMA MGRSERVNAME CHECKPOINTTABLE. 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? The Extract will revert to single-row fetch mode, and then resume array fetches afterwards. The Extract will abend unless LOBMEMORY is increased. The Extract will revert to single-row fetch mode for all tables. The Extract will perform poorly due to paging unless LOBMEMORY is increased. Which three types of information are stored in the GoldenGate trail header? Relative byte address of the commit record. Time of the transaction. Data type (e. g. integer, alphanumeric). Before or after image indicator. What is the name and the location of the file that lists the key values used by extract for encryption and Server Collector for decryption? ENCKEYS file in the GoldenGate installation location. COBGEN file in the GoldenGate installation location. GGSKEY file in the GoldenGate data location. KEYGEN file in the GoldenGate data location. Ideally which process should be configured purge old trail files? Replicat Pump Manager Extract. By default which type of operations are captured by Extract? Inserts, compresses, and deletes. Inserts, updates, deletes, and table operations such as ADD COLUMN. Inserts, updates, deletes, and table operations such as CREATE TABLE. Inserts only. Inserts, updates, and deletes. Select the statement that is supported by OGG DDL Replication. CREATE ROLE ALTGLOBAL ENCRYPT ALTDB. Which Replicat parameter is used when looking up table definitions in a file? SOURCEDEFS SOURCEISFILE DEFERAPPLYINTERVAL SPECIALRUN. What file must be configured in order to use custom encryption keys? ENCKEYS GLOBALS ENCRYPT CUSTKEYS. How would you specify the data source for a secondary Extract functioning as a Data Pump? LOCTRAILSOURC SOURCEISTABLE SOURCEISTRAIL EXTTRAILSOURCE. GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them? in the trail files area in the checkpoint file area. in the server temporary file system in the bounded recovery area. You need to look up table definitions in a file. Which Replicat parameter should you use? SOURCEDEFS MAP COLMATCH ASSUMETARGETDEFS. You want to increase parallelism for greater integrated Replicat throughput while preserving the original transaction atomicity. How can you achieve this? You can configure integrated Replicat with the SPECIALRUN parameter. You can configure integrated Replicat with two parallel apply servers. You can configure integrated Replicat with two parallel child servers. You can configure integrated Replicat with ASSUMETARGETDEFS and SPECIALRUN parameters. Which command forces a running Extract to close the current trail and start writing to the next trail sequence number? SEND EXTRACT <group>, ETROLLOVER ALTER EXTTRAIL <trail name>, ROLLOVER ALTER EXTTRAIL <trail name>, NEXTSEQNO SEND EXTRACT <group>, ROLLOVER. Which utility is responsible for generating source data definitions files? DDLGEN COBGEN EMSCLNT DEFGEN. What three types of information are reported in discard file? The trail file sequence number. The database error message. The details of the discarded records. Runtime statistics. Which could be used to map a value stored in a user token to a target column? @GETENV GGENVIRONMENT @TOKEN GGHEADER. 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? Continue the implementation of OGG and exclude those objects from replication. Contact Oracle Support. Configure OGG with Classic Capture. Configure OGG with Integrated Capture. What is the default format for a GoldenGate trail? SQL: SQL statements INPUT ASCII: from 1 to 127 representing ASCII characters XML: XML statement ASCII:ASCII format CDF: Canonical Data format. 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? This configuration is not supported in GoldenGate 10. WILDCARDRESOLVE DYNAMIC TRANLOGOPTIONS ARCHIVEDLOGONLY ASSUMETARGETDEFS. Replicat is responsible for which three options? Check pointing the oldest uncommitted transaction. Reading data out of the GoldenGate trails. Performing data flow filtering. Performing data transformations. Which three can GoldenGate encrypt? Passwords Extract to Server messages Redo logs Trails. When would you use the PASSTHRU parameter? For a SPECIALRUN one-time processing task that is doing an initial load. When using a data pump to distribute all of the trail data "as is" to a remote system. When Extract is processing database transaction logs where you have a remote database connection. When Extract is processing database transaction logs and writing to a local trail that will be read by a local Replicat. Which three describe a valid OGG Event Action? Write a checkpoint before and/or after writing the record to the trail. Stop the process. Run a shell command. Purge old trail files. How do you control the size of the buffer that contains data extracted from an ASM instance? DBOPTIONS BUFSIZE TRANLOGOPTIONS ASMBUFSIZE DBOPTIONS ASMBUFSIZE TRANLOGOPTIONS BUFSIZE . If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up? Extract Replicat Manager Extract and Replicat. 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? Include the USEDELTA command. Include the UPDATAROWEXISTS command. Include the ADD TRANDATA command. Include the OVERWRITE command. 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 user session running Manager is set to log all messages. The Manager parameter file contains SYSLOG ALL. An Extract or Replicat is overriding GLOBALS with SYSLOG WARN. How many Extracts can write to the same GoldGate trail? Up to 10. Unlimited. Up to 50. Only one. What is GGSCI an Acronym for? GoldenGate Software Connection Interface GoldenGate Secure Command Interface GoldenGate Secure Connection Interface GoldenGate Software Command Interface. Which three are types of encryption supported by OGG? Password. Parameter file encryption. Message encryption. Trail file encryption.

Denunciar Test