Qlik QREP Practice Exam Questions & Answers

After a Qlik Replicate administrator creates a new task, runs a Full Load test, and turns on Change Processing, the method to test this task would be to:

Stop the task: This ensures that no active processes are running that could interfere with the testing.

Run -> Advanced Run Options: This step allows the administrator to access more specific settings that can control how the task is executed.

Start Change Processing Only: This option will start the Change Data Capture (CDC) phase without re-running the Full Load. It's used to test the CDC mechanism specifically, ensuring that changes made at the source are captured and applied to the target correctly.

This method is supported by best practices in the Qlik community and documentation, which suggest using the Advanced Run Options to control the task's behavior for testing purposes1. It allows the administrator to verify that the Change Processing is set up correctly and is functioning as expected without the need to reload the target or recreate the task entirely. This approach is efficient and effective for testing the CDC functionality in isolation.

When the connection to the source endpoint is unavailable for an extended period, and the log files are limited to only 2 hours of data before being deleted, the safest way to ensure a consistent state in the target endpoint is to use the Reload Target Run option (A). This approach is recommended because it allows for a complete refresh of the target data, ensuring that it is in sync with the source once the connection is re-established.

The Reload Target Run option is designed to handle situations where the replication logs are not sufficient to recover the replicated state due to extended outages or log retention policies. By reloading the target, you can be confident that the data reflects the current state of the source, without relying on potentially incomplete change logs.

Starting processing from a fixed date and time (B) or recovering from a locally stored checkpoint would not be reliable if the logs do not cover the entire period of the outage. Resuming the task and ignoring warnings (D) could lead to inconsistencies due to missed changes.

Therefore, the Reload Target Run option is the safest method to create a consistent state in the target endpoint under these circumstances1.

To run Analytics under Qlik Enterprise Manager, it is required to have a PostgreSQL Database installed. This is because the Analytics data for Qlik Enterprise Manager is stored in a PostgreSQL database. Before using the Analytics feature, you must ensure that PostgreSQL (version 12.16 or later) is installed either on the Enterprise Manager machine or on a machine that is accessible from Enterprise Manager1.

Here are the steps and prerequisites for setting up Analytics in Qlik Enterprise Manager:

Install PostgreSQL: The setup file for PostgreSQL is included with Enterprise Manager, and it must be installed to store the Analytics data1.

Create a dedicated database and user: A dedicated database and user in PostgreSQL should be created, which will own the tables accessed by the Enterprise Manager Analytics module1.

Configure connectivity: Connectivity to the PostgreSQL repository must be configured as described in the Repository connection settings1.

Data collection and purging: Configure data collection and purging settings as described in the Analytics - Data collection and purge settings1.

Register a license: A Replication Analytics license is required to use Analytics. If you have a license, you can register it by following the procedure described in Registering a license1.

The other options provided, such as Qlik Replicate (A), Qlik Compose (B), and both Qlik Compose and Replicate (D), are not components that must be installed to run Analytics under Enterprise Manager. The essential component is the PostgreSQL Database , which serves as the backend for storing the Analytics data1.

Therefore, the verified answer is C. PostgreSQL Database, as it is the required component to run Analytics under Qlik Enterprise Manager1.

For replicating columns that contain large PDFs, the appropriate data type to use in Qlik Replicate is:

D . BLOB: This stands for Binary Large Object and is the data type used for storing large binary data such as PDF files. The BLOB data type is suitable for handling the size and binary nature of PDF files1.

The other options are not suitable for the following reasons:

A . DLOB: This is not a recognized data type in Qlik Replicate.

B . NCLOB: NCLOB, or National Character Large Object, is used for storing large text data in the national character set and is not optimal for binary data like PDFs.

C . NVARCHAR(1000): NVARCHAR is a character data type with a specified length, which would not be suitable for large binary objects like PDFs due to size limitations and the nature of the data.

For more information on data types and their usage in Qlik Replicate, you can refer to the official Qlik Replicate documentation on Replicate data types.

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

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

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

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