Qlik QREP Dumps (V8.02) – The Effective QREP Practice Exam Questions and Answers of DumpsBase

1. Which is the path to add a new column to a single table in a task?

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

3. Which information in Qlik Replicate can be retrieved from the server logs?

4. Which two components are responsible for reading data from the source endpoint and writing it to the target endpoint in Full Load replication? (Select two.)

A. SOURCE_UNLOAD

B. TARGET_APPLY

C. TARGET_UNLOAD

D. SOURCE_CAPTURE

E. TARGET_LOAD

5. Where are the three options in Qlik Replicate used to read the log files located? (Select three.)

A. In Windows Event log

B. In Diagnostic package

C. In External monitoring tool

D. In Data directory of Installation

E. In Monitor of Qlik Replicate

F. In Enterprise Manager

6. In the CDC mode of a Qlik Replicate task, which option can be set for Batch optimized apply mode?

A. Source connection processes

B. Number of changed records

C. Time and/or volume

D. Maximum time to batch transactions

7. How should missing metadata be added in a Qlik Replicate task after the task has been stopped?

8. When running a task in Qlik Replicate (From Oracle to MS SQL), the following error message appears:

Failed adding supplemental logging for table "Table name" Which must be done to fix this error?

A. Contact the Oracle DBA

B. Check the permission on the target endpoint

C. Enable supplemental logging

D. Check the permission of the source endpoint

9. Which is the minimum level of permissions required for a user to delete tasks?

10. 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.)

11. Which two task logging components are associated with a Full Load to a target endpomt? (Select two.)

12. Which are valid source endpoint types for Qlik Replicate change processing (CDC)? (Select two)

13. How can the task diagnostic package be downloaded?

14. An operative database can only commit two engines to Qlik Replicate (or initial loads at any given time.

How should the task settings be modified?

A. Apply Change Processing Tuning and increase the Apply batched changes intervals to 60 seconds

B. Qlik Replicate tasks only load one table at a time by default, so the task settings do not need to be modified.

C. Apply Full Load Settings to limit the number of engines to two.

D. Apply Full Load Tuning to read a maximum number of tables not greater than two.

15. Which is the default port of Qlik Replicate Server on Linux?

A. 3550

B. 443

C. 80

D. 3552

16. A Qlik Replicate administrator must deliver data from a source endpoint with minimal impact and distribute it to several target endpoints.

How should this be achieved in Qlik Replicate?

A. Create a LogStream task followed by multiple tasks using an endpoint that reads changes from the log stream staging folder

B. Create a task streaming to a dedicated buffer database (e.g.. Oracle or MySQL) and consume that database in the following tasks as a source endpoint

C. Create a task streaming to a streaming target endpoint (e.g., Kafka) and consume that endpoint in the following tasks as a source endpoint

D. Create multiple tasks using the same source endpoint

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

A. IBM IMS

B. IBMDB2Z/OS

C. Kafka Source

D. SAPHANA

E. HP NonStop

18. AQlik Replicate administrator requires data from a CRM application that can be accessed through different methods.

How should this be done?

19. A customer needs to run daily reports about the changes that have occurred within the past 24 hours

When setting up a new Qlik Replicate task, which option must be set to see these changes?

20. During the process of handling data errors, the Qlik Replicate administrator recognizes that data might be truncated Which process should be used to maintain full table integrity?