CREAR TEST

TEST BORRADO, QUIZÁS LE INTERESE: GG Exam Q/A 003

COMENTARIOS	ESTADÍSTICAS	RÉCORDS

REALIZAR TEST

Título del Test: GG Exam Q/A 003 Descripción: Parte 3 del examen para GG Autor: GHS OTROS TESTS DEL AUTOR Fecha de Creación: 09/10/2024 Categoría: Arte Número Preguntas: 31

COMPARTE EL TEST

Comentar

No hay ningún comentario sobre este test.

Temario:

In addition to using the parameter comment to enter remarks in parameter file(s) what can be used? \\ /* // --. Which best describes the function of OGG user tokens? User-defined variables. User privileges. Security tokens. User-defined functions. In GoldenGate terms, what is the definition of Extract lag? The difference in time between when a change is made to source data and when that change is reflected in the target data. The difference in time between the current times at the target system. 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. The difference in time between when a change record is processed by the extract and the timestamp of the record in the data source. You are migrating from a legacy database server to Exadata, which requires you to use different versions of GoldenGate. What do you need to configure to ensure that backwards replication works? The Replicat with the FORMAT RELEASE parameter. The Extract with the FORMAT RELEASE parameter. The collector with the FORMAT RELEASE parameter. The Extract to write directly to the remote trail. 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? The first column, excluding virtual columns and nullable columns, will be treated as the primary key. This configuration is not supported by GoldenGate; Replicat will abend on updates or deletes. The combination of all fields up to the first thirty-two will be treated as a compound primary key. The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key. Which of following Oracle data types Oracle GoldenGate does not support? (Choose three) BINARY_FLOAT DATE TIMEZONE_ABBR URITYPE TIMESTAMP WITH LOCAL TIMEZONE NVARCHAR2 MLSLABEL. Which parameter tells Extract the tables for which to Capture Changes? MAP C Table LOG LOGTABLE. When GoldenGate is configured for Archived Only Mode (ALO), what must be considered configuring the middle-tier server for Capture? GoldenGate only supports UNIX on the middle-tier server. GoldenGate only supports Windows or Linux on the middle-tier server. The middle-tier server must have a database installed on it. The middle-tier capture server has the same endian order and bit width. Which statement correctly explains when you would use ASSUMETARGETDEFS? The source and target tables have identical data structure. The target tables are already created. You have specified wildcards in either the TABLE or MAP parameters. Only the fields in the target tables are mapped. What GoldenGate facility allows for custom processing in response to a data value? GGSExec DDLGEN User Tokens User Exits. 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? DDL EXCLUDE MAPPED in extra parameter file. This feature is not supported in oracle GoldenGate 10. DDL INCLUDE UNMAPPED in extra parameter file. DDL INCLUDE MAPPED in extra parameter file. You are configuring a multi-master DDL replication environment. To prevent looping of DDL statement like CREATE TABLE (….), the best solution is______. Include the tranlogoptions (exclude user) parameter in each Extract parameter file. This feature is not supported in GoldenGate 10. Use the add FILTERTABLE command at the GGSCI prompt. Use DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping. You are asked to create an Extract process on a source database to capture data from materialized views. Which of these are valid statements for Extract process which captures data of materialized view? (Choose Two) Materialized view created WITH ROWID are not supported. DML (but not DDL except truncate) from a full refresh of materialized view is supported. Source table may or may not have a primary key. DML (but not DDL) from a full refresh of materialized view is supported. Which statement best describes the record Image that an Extract process stores in the GoldenGate trail by default? An image of the contents of the record after the insert, update or delete operation. An after image for inserts and a before image for updates and deletes. The new value for updated fields; the primary key for deleted rows; the after-image for inserts. An after image for inserts and updates and a before image for deletes. You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue? GoldenGate Manager was not started first. The incorrect version of GoldenGate was installed for your CPU architecture. The LD_LIBRARY_PATH variable to $ORACLE_HOME was not set. A license key must be applied first. If your system has a firewall controlling port access which parameter can be used to control ports used for GoldenGate processes? GETPORTINFO DYNAMICPORTLIST CHILDPORTS ALLOWEDPORTS. What is the GoldenGate command line interface? GGCTRL GGCUI SQLCUI GGSCI. Which argument is used to set the maximum size of the EXTTRAIL or RMTTRAIL. TRAILMAXSIZE F TRAILSIZE MEGABYTES MAXSIZE HAXTRAILSI2E. Which GoldenGate process would you configure to enable Synchronous Streaming? A Knowledge Module. Secondary Extract. Manager Replicat. From which portion of SGA the shared memory comes from for GoldenGate Extract process? Large Pool Redo Log Buffer Streams Pool Buffer Cache. Which process receives data from the Extract process over TCP/IP and writes it to a trail or extract file on the target system? Manager Release Collector Replicat. Which statements are true of GoldenGate password encryption? 1 - A password can be encrypted and pasted into a parameter file. 2 - An encrypted password can be generated using the default key. 3 - An encrypted password can be generated using a user defined-key. 1, 2 and 3 3 only 1 only 2 only 1 and 3. How can you tell if GoldenGate has been configured for batch processing? The SPECIALRUN parameter is in the GLOBALS parameter file. There is a dedicated GoldenGate process called SPECIALRUN. The SPECIALRUN parameter is in the Replicat parameter file. Replicat is started with the INITIALLOAD task. Which Manager Parameter sets will report current lag every hour and write a critical message for any Extract/Replicat with a lag over 60 minutes? LAGBEPOBTHOURS 1, LAGINFO 1 and LAGCRITICAL 60 LAGREPOBT 1, I.AGCRITICALHOURS 1 LAGREPOBTHOURS 1, LAGINFOMINUTES 30, LAGCR JTTCAI-M I LAGREPORTMINUTES 60, LAGINFOHOURS 1. 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 Example 3 only Examples 1 and 3 Examples 1 and 2 Example 2 only . Which command creates the database logmining server in Oracle? REGISTER MININGDB REGISTER EXTRACT ADD MININGDB ALL ABOVE OPTIONS. Where are GoldenGate macros defined? Macros can be defined in the parameter file or included in a macro file. Macros are placed in a file and referenced using environment variable. Macros are declared, compiled and referenced via GoldenGate's user exits. Macros are defined in the GLOBALS parameter file. What parameter provides options for compression and encryption? TCPIP RMTHOST TARGET DB TARGET. 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? Tables set with nologging. Triggers and sequences Tables that have conflicts. Tables with Large Object (LOB) data types. What command is issued to alter Replicat to start processing trail number 10 at relative byte address 100345? Alter <group>, sequence 10, rba 100345 Alter <group>, extseqno 10, extrba 100345 Alter Replicat <group>, sequence lO, rba 100345 Alter Replicat *, exttrail <trail prefix>, extseqno 10, extrba 100345. 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? RMTHOST usserval, MGRPORT AES, ENCRYPTKEY MYKWY, MBRPORT 7809 RMTHOST usserval, MGRPORT 7809, ENCRYPT BLOWFISH ENCRYPTKEY MYKEY This feature is not supported in oracle GoldenGate 10. RMTHOST usserval, MGRPORT 7809, ENCRYPT AES, ENCRYPT KEY.

Denunciar Test