Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. QlikView
  3. QREP

QlikView QREP Exam (page: 2)
QlikView Qlik Replicate Certification
Updated on: 12-Feb-2026

Viewing Page 2 of 13
QREP PDF 60 Questions

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

  1. Source connection processes
  2. Number of changed records
  3. Time and/or volume
  4. Maximum time to batch transactions

Answer(s): C

Explanation:

In Change Data Capture (CDC) mode, Batch optimized apply mode can be set based on time and/or volume.
This means that the batching of transactions can be controlled by specifying time intervals or the volume of data changes to be batched together.
This optimization helps improve performance by reducing the frequency of writes to the target system and handling large volumes of changes efficiently. The Qlik Replicate documentation outlines this option as a method to enhance the efficiency of data replication in CDC mode by batching transactions based on specific criteria.

In the Change Data Capture (CDC) mode of a Qlik Replicate task, when using the Batch optimized apply mode, the system allows for tuning based on time and/or volume. This setting is designed to optimize the application of changes in batches to the target system. Here's how it works:
Time: You can set intervals at which batched changes are applied. This includes setting a minimum amount of time to wait between each application of batch changes, as well as a maximum time to wait before declaring a timeout.
Volume: The system can be configured to force apply a batch when the processing memory exceeds a certain threshold. This allows for the consolidation of operations on the same row, reducing the number of operations on the target to a single transaction. The other options provided do not align with the settings for Batch optimized apply mode in CDC tasks:
A) Source connection processes: This is not a setting related to the batch apply mode.
B) Number of changed records: While the number of changed records might affect the batch size, it is not a setting that can be directly configured in this context.
D) Maximum time to batch transactions: This option is related to the time aspect but does not fully capture the essence of the setting, which includes both time and volume considerations. Therefore, the verified answer is C. Time and/or volume, as it accurately represents the options that can be set for Batch optimized apply mode in the CDC tasks of Qlik Replicate.



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

Answer(s): C

Explanation:

If a task has missing metadata, you need to first stop the task.

Navigate to the "Advanced Run" options.
Select the option "Metadata Only."
Start the task with this setting to process the missing metadata.
Stop the task again after the metadata is added.
Resume normal task processing. This procedure ensures that only the metadata is processed without affecting the existing data on the target side. This method is recommended in Qlik Replicate documentation for handling missing metadata issues.

To add missing metadata in a Qlik Replicate task after the task has been stopped, the correct approach is to use the Advanced Run option for metadata only. Here's the process:
Select the task that requires metadata to be added.
Go to the Advanced Run options for the task.
Choose the Metadata Only option, which has two sub-options:
Recreate all tables and then stop: This will rebuild metadata for all available tables in the task. Create missing tables and then stop: This will rebuild metadata only for the missing tables or the tables that were newly added to the task.
By selecting the Metadata Only option and choosing to create missing tables, you can ensure that the metadata for the newly added tables is updated without affecting the existing tables and data. After this operation, you can stop the task again and then resume processing. The other options provided are not the recommended methods for adding missing metadata:
A and D suggest dropping tables or data, which is not necessary for simply adding metadata. B suggests reloading the target, which is not the same as updating metadata only. Therefore, the verified answer is C, as it accurately describes the process of adding missing metadata to a Qlik Replicate task using the Advanced Run options.



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?

  1. Contact the Oracle DBA
  2. Check the permission on the target endpoint
  3. Enable supplemental logging
  4. Check the permission of the source endpoint

Answer(s): C

Explanation:

The error message "Failed adding supplemental logging for table" indicates that supplemental logging is not enabled on the Oracle source.
Supplemental logging must be enabled to capture the necessary changes for replication. To fix this error, you should enable supplemental logging on the Oracle database for the specific table or tables.
This can usually be done by executing the following SQL command on the Oracle source:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS; Verify that the logging is enabled and then retry the replication task. This solution aligns with the troubleshooting steps provided in the Qlik Replicate documentation for dealing with supplemental logging errors.

The error message "Failed adding supplemental logging for table `Table name'" indicates that supplemental logging has not been enabled for the table in the Oracle source database. Supplemental logging is necessary for Qlik Replicate to capture the changes in the Oracle database accurately, especially for Change Data Capture (CDC) operations.
To resolve this error, you should:
Enable supplemental logging at the database level by executing the following SQL command in the Oracle database:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
This command enables minimal supplemental logging, which is required for Qlik Replicate to function correctly.
If you need to enable supplemental logging for all columns, you can use the following SQL command:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS; This ensures that all necessary column data is logged for replication purposes. After enabling supplemental logging, verify that it is active by querying the v$database view:
SELECT supplemental_log_data_min FROM v$database;
The correct return value should be `YES', indicating that supplemental logging is enabled. The other options provided are not directly related to the issue of supplemental logging:

A) Contact the Oracle DBA: While contacting the DBA might be helpful, the specific action needed is to enable supplemental logging.

B) Check the permission on the target endpoint: Permissions on the target endpoint are not related to the supplemental logging requirement on the source database.
D) Check the permission of the source endpoint: Permissions on the source endpoint are important, but the error message specifically refers to the need for supplemental logging. Therefore, the verified answer is C. Enable supplemental logging, as it directly addresses the requirement to fix the error related to supplemental logging in Qlik Replicate.



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

  1. Operator
  2. Viewer
  3. Designer
  4. Admin

Answer(s): C

Explanation:

According to the Qlik Replicate documentation, the minimum level of permissions required for a user to delete tasks is theDesignerrole. The predefined roles in Qlik Replicate come with different sets of permissions.TheAdminandDesignerroles have the permission to delete tasks, while theOperatorandViewerroles do not.
Here's a breakdown of the permissions for each role related to task management:
Admin: Can create, design, and delete tasks.
Designer: Can create, design, and delete tasks.

Operator: Can perform runtime operations like start, stop, or reload targets but cannot delete tasks. Viewer: Can view task history and other details but cannot perform task management operations like deleting tasks.



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

  1. Enable supplemental logging
  2. Install the Oracle Instant Client
  3. Complete a full backup of the source
  4. Enable ARCHIVELOG mode
  5. Provide Oracle read-only privileges
  6. Configure Oracle Recovery Model

Answer(s): A,B,D

Explanation:

When configuring Oracle as a source endpoint for Qlik Replicate, there are several key prerequisites that need to be met:
Enable supplemental logging (A): Supplemental logging is crucial for capturing the changes in the Oracle database accurately, especially for Change Data Capture (CDC) operations. It ensures that all necessary column data is logged for replication purposes. Install the Oracle Instant Client (B): The Oracle Instant Client provides the necessary libraries for Qlik Replicate to connect to and interact with the Oracle database. It's required for the proper functioning of Qlik Replicate.
Enable ARCHIVELOG mode (D): ARCHIVELOG mode is necessary for the Oracle database to archive redo logs, which Qlik Replicate uses to capture changes. This mode allows the database to continue functioning and preserve the logs even after a log switch, which is essential for CDC1. The other options provided are not listed as key prerequisites for configuring Oracle as a source endpoint in Qlik Replicate:

C) Complete a full backup of the source: While it's a good practice to have a backup, it's not a prerequisite for configuring the source endpoint.

E) Provide Oracle read-only privileges: Read-only privileges might be necessary for certain operations, but they are not listed as a key prerequisite.
F) Configure Oracle Recovery Model: This is not mentioned as a prerequisite in the Qlik Replicate documentation.
Therefore, the verified answers are A, B, and D, as they represent the necessary steps to configure Oracle as a source endpoint in Qlik Replicate.



Viewing Page 2 of 13



Share your comments for QlikView QREP exam with other users:

Sanyog Deshpande 9/14/2023 7:05:00 AM

good practice
UNITED STATES


Tyron 9/8/2023 12:12:00 AM

so far it is really informative
Anonymous


beast 7/30/2023 2:22:00 PM

hi i want it please please upload it
Anonymous


Mirex 5/26/2023 3:45:00 AM

am preparing for exam ,just nice questions
Anonymous


exampei 8/7/2023 8:05:00 AM

please upload c_tadm_23 exam
TURKEY


Anonymous 9/12/2023 12:50:00 PM

can we get tdvan4 vantage data engineering pdf?
UNITED STATES


Aish 10/11/2023 5:51:00 AM

want to clear the exam.
INDIA


Smaranika 6/22/2023 8:42:00 AM

could you please upload the dumps of sap c_sac_2302
INDIA


Blessious Phiri 8/15/2023 1:56:00 PM

asm management configuration is about storage
Anonymous


Lewis 7/6/2023 8:49:00 PM

kool thumb up
UNITED STATES


Moreece 5/15/2023 8:44:00 AM

just passed the az-500 exam this last friday. most of the questions in this exam dumps are in the exam. i bought the full version and noticed some of the questions which were answered wrong in the free version are all corrected in the full version. this site is good but i wish the had it in an interactive version like a test engine simulator.
Anonymous


Terry 5/24/2023 4:41:00 PM

i can practice for exam
Anonymous


Emerys 7/29/2023 6:55:00 AM

please i need this exam.
Anonymous


Goni Mala 9/2/2023 12:27:00 PM

i need the dump
Anonymous


Lenny 9/29/2023 11:30:00 AM

i want it bad, even if cs6 maybe retired, i want to learn cs6
HONG KONG


MilfSlayer 12/28/2023 8:32:00 PM

i hate comptia with all my heart with their "choose the best" answer format as an argument could be made on every question. they say "the "comptia way", lmao no this right here boys is the comptia way 100%. take it from someone whos failed this exam twice but can configure an entire complex network that these are the questions that are on the test 100% no questions asked. the pbqs are dead on! nice work
Anonymous


Swati Raj 11/14/2023 6:28:00 AM

very good materials
UNITED STATES


Ko Htet 10/17/2023 1:28:00 AM

thanks for your support.
Anonymous


Philippe 1/22/2023 10:24:00 AM

iam impressed with the quality of these dumps. they questions and answers were easy to understand and the xengine app was very helpful to use.
CANADA


Sam 8/31/2023 10:32:00 AM

not bad but you question database from isaca
MALAYSIA


Brijesh kr 6/29/2023 4:07:00 AM

awesome contents
INDIA


JM 12/19/2023 1:22:00 PM

answer to 134 is casb. while data loss prevention is the goal, in order to implement dlp in cloud applications you need to deploy a casb.
UNITED STATES


Neo 7/26/2023 9:36:00 AM

are these brain dumps sufficient enough to go write exam after practicing them? or does one need more material this wont be enough?
SOUTH AFRICA


Bilal 8/22/2023 6:33:00 AM

i did attend the required cources and i need to be sure that i am ready to take the exam, i would ask you please to share the questions, to be sure that i am fit to proceed with taking the exam.
Anonymous


John 11/12/2023 8:48:00 PM

why only give explanations on some, and not all questions and their respective answers?
UNITED STATES


Biswa 11/20/2023 8:50:00 AM

refresh db knowledge
Anonymous


Shalini Sharma 10/17/2023 8:29:00 AM

interested for sap certification
JAPAN


ethan 9/24/2023 12:38:00 PM

could you please upload practice questions for scr exam ?
HONG KONG


vijay joshi 8/19/2023 3:15:00 AM

please upload free oracle cloud infrastructure 2023 foundations associate exam braindumps
Anonymous


Ayodele Talabi 8/25/2023 9:25:00 PM

sweating! they are tricky
CANADA


Romero 3/23/2022 4:20:00 PM

i never use these dumps sites but i had to do it for this exam as it is impossible to pass without using these question dumps.
UNITED STATES


John Kennedy 9/20/2023 3:33:00 AM

good practice and well sites.
Anonymous


Nenad 7/12/2022 11:05:00 PM

passed my first exam last week and pass the second exam this morning. thank you sir for all the help and these brian dumps.
INDIA


Lucky 10/31/2023 2:01:00 PM

does anyone who attended exam csa 8.8, can confirm these questions are really coming ? or these are just for practicing?
HONG KONG