File Info
| Exam | Oracle GoldenGate 12c Implementation Essentials |
| Number | 1z0-447 |
| File Name | Oracle.1z0-447.TestKing.2018-10-15.45q.vcex |
| Size | 76 KB |
| Posted | Oct 15, 2018 |
| Download | Oracle.1z0-447.TestKing.2018-10-15.45q.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
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 2
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 3
Which command provides statistics about GoldenGate processes and memory resource utilization?
- SEND…CACHEMGR
- SEND…LOGSTATS
- SEND…GETTCPSTATS
- INFO…SHOWCH
Correct answer: A
Question 4
You want to monitor replication not only to check that the processes are running, but to specifically verify that the data continuously replicates. How should you accomplish this?
- Implement GoldenGate Monitor.
- Have the customer continuously update the application data.
- Monitor the GoldenGate lag and last checkpoint time statistics.
- Implement heartbeat tables for replication.
Correct answer: C
Explanation:
Reference: http://www.oracle.com/technetwork/articles/havawala-goldengate-091741.html Reference: http://www.oracle.com/technetwork/articles/havawala-goldengate-091741.html
Question 5
You must return column-level detail for out-of-sync rows. How can you accomplish this?
- The Oracle GoldenGate Veridata Agent executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.
- The Oracle GoldenGate Veridata Manager executes auto-memory database-related requests on behalf of the Oracle GoldenGate Veridata Server.
- The Oracle GoldenGate Veridata Agent source database executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.
- The Oracle GoldenGate Veridata Manager executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.
Correct answer: A
Explanation:
Reference: https://docs.oracle.com/goldengate/v1221/gg-veridata/GVDAD/about_ogg_veridata.htm#GVDAD114 Reference: https://docs.oracle.com/goldengate/v1221/gg-veridata/GVDAD/about_ogg_veridata.htm#GVDAD114
Question 6
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 7
You want to use multiple concurrent Extract process groups. What is the key factor in determining how many can be running at the same time?
- the number of concurrent users
- disk space
- system memory
- the number of compound keys on the source tables
Correct answer: C
Explanation:
Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_performance.htm#GWUAD1131 Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_performance.htm#GWUAD1131
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
When is a Pump not required to connect to a source database?
- when transformations, filtering, and mapping are required
- when look-ups are needed against the source database
- when a PASSTHRU parameter is used
- when a NOPASSTHRU parameter is used
Correct answer: B
Explanation:
Question 10
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
