File Info
| Exam | Oracle GoldenGate 12c Implementation Essentials |
| Number | 1z0-447 |
| File Name | Oracle.1z0-447.CertKey.2019-12-04.48q.vcex |
| Size | 95 KB |
| Posted | Dec 04, 2019 |
| Download | Oracle.1z0-447.CertKey.2019-12-04.48q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
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 Extract to write directly to the remote trail.
- The collector with the FORMAT RELEASE parameter.
Correct answer: A
Question 2
Which syntax would you use in an OBEY script to stop a process without waiting for user input?
- stop * noinput
- stop immediate *
- stop * !
- stop force *
Correct answer: C
Question 3
You must locate the next good record header in a Logdump file. How should you do this?
- Logdump > SCANFORGHDR
- Logdump > GHDR ON
- Logdump > SCANFORENDTRANS
- Logdump > SCANFORHEADER
Correct answer: D
Explanation:
Reference: https://docs.oracle.com/goldengate/c1230/gg-winux/GLOGD/using-logdump-utility.htm#GLOGD108 Reference: https://docs.oracle.com/goldengate/c1230/gg-winux/GLOGD/using-logdump-utility.htm#GLOGD108
Question 4
Which three are the responsibility of the MGR process? (Select three.)
- Process management
- Trail File management
- Data movement
- Receive or route requests from the UI
- Trigger execution
Correct answer: ABC
Question 5
You want to issue GoldenGate commands from a script. What sequence of steps should you follow to accomplish this?
- 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.
- 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.
- 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.
- 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
Explanation:
Reference: https://docs.oracle.com/goldengate/c1221/gg-winux/GWUAD/getting-started-oracle-goldengate-process-interfaces.htm#GWUAD1096 Reference: https://docs.oracle.com/goldengate/c1221/gg-winux/GWUAD/getting-started-oracle-goldengate-process-interfaces.htm#GWUAD1096
Question 6
Which command provides statistics about GoldenGate processes and memory resource utilization?
- SEND…CACHEMGR
- SEND…LOGSTATS
- SEND…GETTCPSTATS
- INFO…SHOWCH
Correct answer: A
Question 7
You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?
- Oracle Goldengate for Big Data
- Oracle Goldengate Application Adapters
- Oracle Goldengate Veridata
- Oracle Data Integrator Adapters
Correct answer: B
Explanation:
Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/GGS_Sect_Config_from_WinUX_ORA_to_AMQ_JMS.pdf Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/GGS_Sect_Config_from_WinUX_ORA_to_AMQ_JMS.pdf
Question 8
Your Replicat performance seems slow. Which Replicat parameter can be used to improve performance?
- DEFERAPPLYINTERVAL
- BATCHSQL
- ASSUMETARGETDEFS
- SPECIALRUN
Correct answer: B
Explanation:
Reference: https://docs.oracle.com/en/cloud/paas/goldengate-cloud/gwuad/tuning-replicat-transactions.html Reference: https://docs.oracle.com/en/cloud/paas/goldengate-cloud/gwuad/tuning-replicat-transactions.html
Question 9
You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?
- Use the command option AFTERCSN.
- Use the command option ATCSN.
- Use the command option UNTIL CANCEL.
- Use the command option RESUME.
Correct answer: A
Question 10
You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?
- It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.
- It is caused by the thread with the highest thread ID applying barrier transactions.
- It is caused by the use of the MAXTRANSOPS parameter.
- It is caused by barrier transactions in a Coordinated Replicat.
Correct answer: D
Explanation:
Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_changesync.htm#GWUAD953 Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_changesync.htm#GWUAD953
