QREP practice question 6 of 15

A Qlik Replicate administrator will use Parallel load during full load Which three ways does Qlik Replicate offer? (Select three.)

Full set: 60 questions
Answer options
A: Use Data Ranges Correct answer
B: Select specific tables and columns
C: Use Partitions - Use all partitions - Use main\sub-partitions Correct answer
D: Use Time and Date Ranges in the date and time columns Correct answer
E: User chooses a list of columns and set of values that define ranges
F: Use Partitions - Specify partitions\sub-partitions
Correct Answer:
A. Use Data Ranges; C. Use Partitions - Use all partitions - Use main\sub-partitions; D. Use Time and Date Ranges in the date and time columns
Explanation

Qlik Replicate allows Full Load parallelisation in exactly three mutually-exclusive modes, configured in the “Parallel Load” dialog:
• Use Data Ranges – splits the table by numeric or character value ranges on a single column.
• Use Partitions – loads one or more database partitions in parallel (user may choose all, main, or specific partitions/sub-partitions).
• Use Time and Date Ranges – splits the table according to contiguous ranges on a DATE, TIME or TIMESTAMP column. Options A, C and D describe these three modes verbatim.

Why Incorrect

B. “Select specific tables and columns” concerns task table selection, not the Parallel Load feature.
E. “User chooses list of columns and set of values” is not an available Parallel Load mode; ranges are defined on a single column.
F. “Specify partitions/sub-partitions” is only a sub-option within the broader “Use Partitions” mode already covered by option C, not a separate method.

References

1. Qlik Replicate September 2023 User Guide, Chapter “Performance Tuning” → section “Parallel Load”, pp. 355-357: radio buttons “Use Data Ranges”, “Use Partitions”, “Use Time and Date Ranges”.

2. Qlik Replicate Best Practices White Paper, v2022-05, §4.1 “Parallel Loading Large Tables” – explains the same three methods.

3. Qlik Replicate Help Portal (cloud edition) article “Parallel Loading Options”, paragraphs 1-4 (retrieved 2024-11-20) – lists the identical three options.

Scroll to Top