Qlik Replicate Certification Exam (QREP) Free Practice Test

Question 1

A Qlik Replicate administrator needs to configure Oracle as a source endpoint before running a task in Qlik Replicate Which are three key prerequisites? (Select three.)

A. Enable ARCHIVELOG mode

B. Provide Oracle read-only privileges

C. Install the Oracle Instant Client

D. Configure Oracle Recovery Model

E. Enable supplemental logging

F. Complete a full backup of the source

Correct Answer: A,C,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Two companies are merging Both companies have IBM DB2 LUW running The Qhk Replicate administrator must merge a database (12 TB of data) into an existing database (15 TB of data). The merge will be done by IBM load.
Which approach should the administrator use?

A. Stop task, wait until IBM load finishes, and then resume the task

B. Continue to run the task

C. Stop task, finish IBM load, reload target

D. Create a new task after finishing IBM load

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

A Qlik Replicate administrator has stopped the Qlik Replicate services.
Which are the next three steps to change the Data Directory location on Windows? (Select three.)

A. Uninstall Qlik Replicate and reinstall with the option to move the data directory to a different location

B. Stop the Attunity Replicate Ul Server and Attunity Replicate Server services

C. Start the Attunity Replicate services

D. Move the data directory to a new location

E. Copy the data directory to a shared drive and keep all tasks running

F. Update the Windows Registry

Correct Answer: C,D,F

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Using Qlik Replicate, how can the timestamp shown be converted to unlx time (unix epoch - number of seconds since January 1st 1970)?

A. strftime('%s*,SAR_H_COMMIT_TIMESTAMP) - <code>datetime.datetime</code>('%s','1970-01-01
00:00:00')

B. SELECT datetime(482340664, 'localtime', 'unixepoch');

C. Time.now.strftime(%s','1970-01-01 00:00:00')

D. strftime*'%s,,SAR_H_COMMIT_TIMESTAMP) - strftime('%s','1970-01-01 00:00:00')

E. SELECT datetime<1092941466, 'unixepoch*, 'localtime');

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

The Qlik Replicate developer notices that errors occur about the duplicate key when applying INSERT.
Which should be done in order to identify this Issue?

A. Stop task and enable the Apply Exceptions control table

B. Stop and resume the task

C. Stop and reload the task

D. Check the error message in the Apply Exceptions control table

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

Which files can be exported and imported to Qlik Replicate to allow for remote backup, migration, troubleshooting, and configuration updates of tasks?

A. Task CFG files

B. Task XML files

C. Task INI files

D. Task JSON files

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

Which two endpomts have ARC (Attunity Replicate Connect) CDC (Change Data Capture) agents? (Select two )

A. IBMDB2Z/OS

B. SAPHANA

C. HP NonStop

D. IBM IMS

E. Kafka Source

Correct Answer: C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Qlik Replicate Certification (QREP) Free Practice Test