1z0-481 | The Secret of Oracle 1z0-481 exam
Q21. 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
Explanation:
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_upgrade_v104.pdf
Q22. 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
Explanation:
Reference :
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Q23. 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
Q24. 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: ABC
Explanation:
Reference:
http://gavinsoorma.com/2010/02/goldengate-tutorial-3-configuring-the-manager-process/ http://space.itpub.net/10248702/viewspace-624577
Q25. 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: D
Explanation: An after image for inserts and updates and a before image for deletes.According to these guides:1.
http://docs.oracle.com/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf,
page 190,GETUPDATEAFTERS/IGNOREUPDATEBEFORES are the DEFAULT values of the parameters which control whether or not the after/before images of updated records are included in the records processed by GoldenGate.2. Oracle GG Fundamentals Student Guide, Version 10.4, page 113, Extract Parameters, Extract Parameter Defaults slide… Only after-image of update
Q26. 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
Q27. What parameter provides options for compression and encryption?
A. RMTHOST
B. TARGET
C. TCPIP
D. TARGET DB
Answer: A
Explanation:
Reference :
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Q28. Which three are types of encryption supported by OGG?
A. Parameter file encryption
B. Password
C. Trial file encryption
D. Message encryption
Answer: ABC
Q29. 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
Explanation:
The START EXTRACT starts the Extract and Data Pump processes.
Reference:
http://www.pythian.com/news/7959/oracle-goldengate-installation-part-1/
Q30. 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
Explanation:
One of the encryption options that GoldenGate provides is to use Passwords in the extract and replicate parameter file. Also, the encrypted password can be generated using user defined key up to 128-bit or using the default key.
Reference:
http://gavinsoorma.com/2010/07/goldengate-encrypting-data-and-passwords/