Free Qlik Replicate Certification Exam QREP Exam Practice Test

Where should Qlik Replicate be set up in an on-premises environment?

• As close as possible to the target system
• In the "middle" between the source and target
• As close as possible to the source system
• In a cloud environment

How can a source be batch-loaded automatically on a daily basis?Set trigger through server schedulerSet trigger through Advanced Run optionsSet trigger through Task DesignerEnable task on full load and apply changes

• Set trigger through server scheduler, as it is the method that allows for the automation of batch loading on a daily schedule1.

The Qlik Replicate administrator adds a new column to one of the tables in a task What should the administrator do to replicate this change?

• Stop and resume the task
• Stop task, enable CT tables, and resume
• Change the DDL Handling Policy to accommodate this change
• Stop and reload the task

When working with Qlik Enterprise Manager, which component must be installed to run Analytics under Enterprise Manager?

• Qlik Replicate
• Qlik Compose
• PostgreSQL Database
• Qlik Compose and Replicate

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

• Source connection processes
• Number of changed records
• Time and/or volume
• Maximum time to batch transactions

The designer creates a replication task with the source schema name 'HR' and renames the schema in the following areas:

• In Global Transformation, create a rule to rename schema to 'USER1'
• In Task Settings -> Target Metadata, enter the Target table schema as 'USER2'
• In Global Transformation, add a new column named 'SCHEMA' and expression as 'USER3' Which is the final target schema name?
• USER3
• HR
• USER1
• USER2

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

• 3550
• 443
• 80
• 3552

Which is the possible Escalate Action for Table Errors?

• Log Record to the Exceptions Table
• No Escalate Action
• Suspend Table
• Stop Task

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

• Operator
• Viewer
• Designer
• Admin

In Qlik Enterprise Manager Analytics, which messages can be seen in the GUI?

• Server settings
• Server-specific trends, specify to a task
• Task-specific trends, specify to a task
• Server and task trends