Download Oracle GoldenGate 12c Implementation Essentials.1z0-447.PracticeTest.2018-11-09.43q.vcex

Vendor: Oracle
Exam Code: 1z0-447
Exam Name: Oracle GoldenGate 12c Implementation Essentials
Date: Nov 09, 2018
File Size: 92 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Which three are the responsibility of the MGR process? (Select three.)
  1. Process management
  2. Trail File management
  3. Data movement
  4. Receive or route requests from the UI
  5. 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?
  1. 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.
  2. 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.
  3. 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.
  4. 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?
  1. SEND…CACHEMGR
  2. SEND…LOGSTATS
  3. SEND…GETTCPSTATS
  4. 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?
  1. Implement GoldenGate Monitor.
  2. Have the customer continuously update the application data.
  3. Monitor the GoldenGate lag and last checkpoint time statistics.
  4. 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?
  1. The Oracle GoldenGate Veridata Agent executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.
  2. The Oracle GoldenGate Veridata Manager executes auto-memory database-related requests on behalf of the Oracle GoldenGate Veridata Server.
  3. The Oracle GoldenGate Veridata Agent source database executes database-related requests on behalf of the Oracle GoldenGate Veridata Server.
  4. 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?
  1. Oracle Goldengate for Big Data
  2. Oracle Goldengate Application Adapters
  3. Oracle Goldengate Veridata
  4. 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?
  1. the number of concurrent users
  2. disk space
  3. system memory
  4. 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?
  1. DEFERAPPLYINTERVAL
  2. BATCHSQL
  3. ASSUMETARGETDEFS
  4. 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?
  1. when transformations, filtering, and mapping are required
  2. when look-ups are needed against the source database
  3. when a PASSTHRU parameter is used
  4. when a NOPASSTHRU parameter is used
Correct answer: B
Question 10
You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?
  1. Use the command option AFTERCSN.
  2. Use the command option ATCSN.
  3. Use the command option UNTIL CANCEL.
  4. Use the command option RESUME.
Correct answer: A
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!