Oracle Oracle Certifications 1Z0-447 Questions & Answers

• Question 71:

  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

  Correct Answer: B

  Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/ GGS_Sect_Config_from_WinUX_ORA_to_AMQ_JMS.pdf

• Question 72:

  Which three are the responsibility of the MGR process? (Select three.)

  A. Process management

  B. Trail File management

  C. Data movement

  D. Receive or route requests from the UI E. Trigger execution

  Correct Answer: ABC

• Question 73:

  You want to issue GoldenGate commands from a script. What sequence of steps should you follow to accomplish this?

  A. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI ./ input_file, where the file name is the script file.

  B. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci < input_file from the command line of the operating system, where the input_file is an OBAY text file.

  C. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI < input_file, where the file name is an OBEY file.

  D. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci ./ input_file from the command line of the operating system, where the file name is the script file.

  Correct Answer: B

  Reference: https://docs.oracle.com/goldengate/c1221/gg-winux/GWUAD/getting-started-oraclegoldengate-process-interfaces.htm#GWUAD1096

• Question 74:

  Which command provides statistics about GoldenGate processes and memory resource utilization?

  A. SEND…CACHEMGR

  B. SEND…LOGSTATS

  C. SEND…GETTCPSTATS

  D. INFO…SHOWCH

  Correct Answer: A

• Question 75:

  What is the SOCKSPROXY subparameter of the RMTHOSTparameter typically used for?

  A. replicating information using a SOCKS5 proxy server, thereby creating a tunnel for TCP communication between a source Extract and a target process

  B. connecting to a source database via secure communication

  C. remote capturing

  D. configuring remote database access

  Correct Answer: A

  Reference: http://www.dba86.com/docs/oracle/ogg/E66315_01/gg-winux/GWURF/ rmthost.htm#GWURF631

• Question 76:

  You must locate the next good record header in a Logdump file. How should you do this?

  A. Logdump >SCANFORGHDR

  B. Logdump > GHDR ON

  C. Logdump > SCANFORENDTRANS

  D. Logdump > SCANFORHEADER

  Correct Answer: D

  Reference: https://docs.oracle.com/goldengate/c1230/gg-winux/GLOGD/using-logdumputility.htm#GLOGD108

• Question 77:

  You edit the GLOBALS file, save the changes, and restart GGSCI to have the change take effect. However, when you try to start the Manager, it fails. Which action should solve the problem?

  A. Use the CLEANUPREPLICATcommand.

  B. Use a text editor to check the GLOBALS file for syntax errors and correct them.

  C. Verify that Oracle environment variables are set correctly.

  D. Add the Oracle GoldenGate Installation directory to the system PATH.

  Correct Answer: C

• Question 78:

  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?

  A. The Replicat with the FORMAT RELEASEparameter.

  B. The Extract with the FORMAT RELEASE parameter.

  C. The Extract to write directly to the remote trail.

  D. The collector with the FORMAT RELEASEparameter.

  Correct Answer: A

• Question 79:

  You are experiencing an issue with the downstream database server for the Integrated Capture Downstream Model. Which step should you take to resolve the issue?

  A. Ensure that the Oracle database version on the downstream database server is the same version as the source Oracle version.

  B. Ensure that the platform type of the downstream database server is the same platform as the source database server.

  C. Ensure that the GoldenGate version used on the downstream database server is the same version used on the source database server.

  D. Ensure that the GoldenGate version used on the downstream database server is the same version used on the target database server.

  Correct Answer: B

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/ic_deploy.htm#GIORA472

• Question 80:

  Which syntax would you use in an OBEY script to stop a process without waiting for user input?

  A. stop * noinput

  B. stop immediate *

  C. stop * !

  D. stop force *

  Correct Answer: C