Free Qlik Compose Certification Exam Practice Questions

Sample Practice Questions

Try these 10 sample questions from the Qlik Compose Certification Exam practice bank. Each includes the answer and explanation. Continue with the interactive practice above to review the full question set.

1. 1In a Compose data lake project, what is the role of the landing zone?

   1. A.It receives replicated source tables in the landing zone.Correct answer: A
   2. B.It receives the storage tables after Compose has processed them.
   3. C.It keeps the generated historical store after updates are merged.
   4. D.It supplies the read-optimized storage views for consumption.

   Explanation: Qlik describes the landing stage: "The source tables are loaded into the Landing Zone using Qlik Replicate or other third-party replication tools." The landing zone receives replicated source tables.

   Reference: Qlik Compose Introduction — Data lake projects > Data lake project architecture

2. 2What does a relationship attribute in a Compose warehouse model point to?

   1. A.Another entity within the same modelCorrect answer: A
   2. B.An attribute domain within the same entity
   3. C.A source column within the same table
   4. D.A historical version within the same entity

   Explanation: Qlik states: “Similar to a foreign key, a relationship "attribute" is a special type of attribute that points to another entity in the same model.” The relationship connects model entities.

   Reference: Creating and managing relationships — Creating and managing relationships

3. 3A transformation must obfuscate source data before it reaches the landing zone. At which location does the Qlik comparison place that transformation?

   1. A.A Replicate transformation before the landing zoneCorrect answer: A
   2. B.A model transformation before the landing zone
   3. C.A data warehouse mapping before the landing zone
   4. D.A data mart transformation before the landing zone

   Explanation: The comparison lists Replicate for "Obfuscation due to regulatory reasons or internal policies" and says it is applied "Before the data reaches the landing zone." This meets the stated timing requirement.

   Reference: Creating expressions — Data transformation location comparison

4. 4A warehouse project has multiple data marts. How does its built-in workflow run the data mart tasks?

   1. A.In parallel after the warehouse tasks completeCorrect answer: A
   2. B.In parallel before the warehouse tasks begin
   3. C.Sequentially before the warehouse tasks begin
   4. D.Sequentially while the warehouse tasks are running

   Explanation: Qlik states: "However, in projects with multiple data marts, the data mart tasks run in parallel, following the completion of the data warehouse tasks." The built-in ordering waits for the warehouse tasks.

   Reference: Workflows — Workflows

5. 5How does the data lake architecture describe the Replicate landing data and Compose storage tables?

   1. A.Landing data is write-optimized; storage tables are read-optimized.Correct answer: A
   2. B.Landing data is read-optimized; storage tables are write-optimized.
   3. C.Both landing data and storage tables are write-optimized.
   4. D.Both landing data and storage tables are read-optimized.

   Explanation: Qlik describes landing changes "in write-optimized format" and says "Compose creates and populates the Storage Zone tables in read-optimized format, ready for consumption by downstream applicaitons." The two zones are optimized for different access patterns.

   Reference: Qlik Compose Introduction — Data lake projects > Data lake project architecture

6. 6A model discovered from the landing zone needs relationships between its entities. What must the designer account for?

   1. A.Relationships must be added to the discovered model.Correct answer: A
   2. B.Relationships are automatically derived from every landing table.
   3. C.Relationships can only be created by reimporting an ERwin model.
   4. D.Relationships are created only when data marts are loaded.

   Explanation: Qlik states: “If your model is derived from the landing zone (as opposed to the source database(s)), the model will be created without any relationships” Landing-zone discovery does not create relationships; add those needed in the model.

   Reference: Creating and managing relationships — Creating and managing relationships

7. 7At which location are transformations applied as staging-table updates after mappings are created?

   1. A.In the Replicate task
   2. B.In the Compose modelCorrect answer: B
   3. C.In a data warehouse mapping
   4. D.In the data mart design

   Explanation: Qlik's comparison states: "Applied as an update to the staging tables after creating the mappings." The model is the location associated with this processing stage.

   Reference: Creating expressions — Data transformation location comparison

8. 8Which scheduler option uses a cron expression to determine when a Compose task runs?

   1. A.Once
   2. B.Every
   3. C.Weekly
   4. D.AdvancedCorrect answer: D

   Explanation: Qlik states: "Advanced - to use a Cron expression." Advanced is the cron-based option.

   Reference: Scheduling tasks — Scheduling tasks

9. 9What happens to new records in a Compose historical data store as source updates arrive?

   1. A.They replace the complete history at each update.
   2. B.They are appended as new historical rows.Correct answer: B
   3. C.They are retained only in the landing zone.
   4. D.They are merged into a single current row.

   Explanation: The introduction says: "New rows are automatically appended to HDS as data updates arrive from source systems." Appending preserves rows for historical analysis.

   Reference: Qlik Compose Introduction — Data lake projects > Historical data store

10. 10When a relationship attribute is selected as a Business Key, how is its history type configured?

    1. A.It is fixed as Type 1.Correct answer: A
    2. B.It is fixed as Type 2.
    3. C.It may be changed between Type 1 and Type 2.
    4. D.It defaults to Type 2 but can be changed to Type 1.

    Explanation: Qlik states: “Since the history type for Business Keys must be type 1, the option to change the history type is unavailable when the Business Key check box is selected.” The Business Key setting fixes the history type to 1.

    Reference: Creating and managing relationships — Adding relationships via the Manage Model window