Qlik Updated QREP Exam Questions and Answers by duaa

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

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

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 areA,B, andD, as they represent the necessary steps to configure Oracle as a source endpoint in Qlik Replicate12.

In Qlik Replicate, when multiple schema rename rules are applied, the final schema name isdetermined by the last applied setting that affects the schema name directly. Here’s how the process works:

Global Transformationto rename schema to ‘USER1’: This rule will initially rename the schema from ‘HR’ to ‘USER1’.However, this is not the final schema name as further changes are applied later in the task settings1.

Task Settings -> Target Metadatato enter the Target table schema as ‘USER2’: This setting overrides the previous global transformation rule and sets the target schema name to ‘USER2’.This is because the Target Metadata settings are applied after the Global Transformations and directly affect the target schema name1.

Global Transformationto add a new column named ‘SCHEMA’ with expression as ‘USER3’: While this rule adds a new column with a value of ‘USER3’, it does not change the schema name itself.It only affects the content of a column within the tables1.

Therefore, the final target schema name, after considering all the applied settings, isD. USER2.This is because the Target Metadata setting in the task settings has the final say on the target schema name, and it is set to 'USER2’1.

For tasks involving Kafka as a target in Qlik Replicate, the valid options are:

A. Full Load and Apply Change: This combination is valid because Kafka can be used both for initial full loads of data and for applying changes captured through CDC (Change Data Capture).In a task with a Kafka target endpoint, each source record is transformed into a message which is then written to a partition in the specified topic1.

The other options are not typically used with Kafka in Qlik Replicate:

B. Full Load and Stage Change: Staging changes is not a standard task option when using Kafka as a target.

C. Apply Change and Store Change: While Kafka can be used to apply changes, the “Store Change” option is not a recognized task option for Kafka targets.

D. Full Load and Store Change: Similarly, “Store Change” is not a standard task option for Kafka targets.

For more information on how to set up and use Kafka as a target endpoint in Qlik Replicate, including the configuration of Full Load and Apply Change tasks, you can refer to the official Qlik community articles and support resources21.

The Apply Exceptions data in Qlik Replicate is retained indefinitely by default. This means thatthe data related to apply exceptions, which includes error records and other relevant information, is not automatically purged after a certain period.

The retention of Apply Exceptions data is crucial for ongoing monitoring and troubleshooting of replication tasks. It allows administrators to review and address any issues that have occurred over the life of the task.

According to the Qlik Replicate documentation, theattrep_apply_exceptionstable, which records processing errors, does not have an automated deletion process.This table includes columns for the task name, table owner, table name, error time (in UTC), statement being executed when the error occurred, and the actual error message1.

This indefinite retention policy ensures that administrators have a complete historical record of all exceptions that have occurred, which can be invaluable for diagnosing and resolving issues with replication tasks. However, it’s important for administrators to manage the size of this table manually to prevent it from growing too large, which could potentially impact system performance.