QREP

Review 60 QREP practice questions with answer explanations and community insights.

Question 1

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

  1. Table Selection -> Schemas -> Add Column
  2. New Transformation -> Column -> Add Column
  3. Select Table -> Transform -> Add New
  4. Table Settings -> General -> Add New Column

Question 2

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

  1. SELECT datetime (1092941466, ‘unixepoch’, ‘localtime’);
  2. SELECT datetime (482340664, ‘localtime’, ‘unixepoch’);
  3. strftime (‘%s’, $AR_H_COMMIT_TIMESTAMP) - <code>datetime.datetime</code>(‘%s’, ‘1970-01-01 00:00:00’)
  4. strftime (‘%s’, $AR_H_COMMIT_TIMESTAMP) – strftime (‘%s’,‘1970-01-01 00:00:00’)
  5. Time.now.strftime(‘%s’, ‘1970-01-01 00:00:00’)

Question 3

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

  1. Drop tables or delete tables and data on target side, then run task from a certain timestamp
  2. Under Advanced Run option choose reload target, stop task again, and then resume processing
  3. Under Advanced Run option choose metadata only, stop task again, and then resume processing
  4. Drop tables and data on the target side, run advanced option, create metadata, and then resume task

Question 4

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

  1. Network and performance issues
  2. Load status and performance of task
  3. Specific task information
  4. Qlik Replicate Server status

Question 5

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

  1. SOURCE_UNLOAD
  2. TARGET_APPLY
  3. TARGET_UNLOAD
  4. SOURCE_CAPTURE
  5. TARGET_LOAD
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.