QSDA2024 practice question 7 of 10
A company generates l GB of ticketing data daily. The data is stored in multiple tables. Business users need to see trends of tickets processed for the past 2 years. Users very rarely access the transaction- level data for a specific date. Only the past 2 years of data must be loaded, which is 720 GB of data. Which method should a data architect use to meet these requirements?
Full set: 50 questionsThe scenario describes a classic big data challenge where the full dataset (720 GB) is too large for efficient in-memory analysis. The user requirements are split: frequent analysis of high-level trends (aggregated data) and rare access to transaction-level details. On-Demand App Generation (ODAG) is the Qlik Sense feature specifically engineered for this purpose. It uses a small, fast summary app with pre-aggregated data for trend analysis. When a user needs to investigate details, they make selections in the summary app, and ODAG dynamically generates a new app containing only the relevant slice of transactional data. This provides optimal performance for the primary use case while still enabling deep-dive analysis when required.
A. Creating two separate, manually linked apps is a less efficient and less integrated solution. ODAG provides a seamless, automated workflow for the user.
B. Loading the entire 720 GB of transactional data into a single app would lead to extremely long reload times and poor user interface performance, failing to meet business needs.
D. This option is logically flawed. If the app only contains aggregated data, it is impossible to apply filters to see transaction-level data because that detail does not exist in the app's data model. ---
1. Qlik Sense on Windows Help, May 2024. Section: "Managing big data with Qlik Sense". This document explicitly states, "On-demand app generation (ODAG) lets you load and analyze big data sources. Users are provided with an aggregated view of the data in a selection app. They can select the dimensions and measures they want to see, and then generate an app with the detailed data." This directly aligns with the proposed solution in option C.
2. Qlik Sense for Administrators Help, May 2024. Section: "Managing on-demand apps". This source describes the architecture: "In big data environments, it is often impractical to load an entire data set into a Qlik Sense app in memory... The on-demand selection app acts as a front end for selecting a slice of the data in the large data repository. The on-demand template app is a template for the generated on-demand apps." This confirms that ODAG is the intended mechanism for handling large data volumes by separating aggregated and detailed views.
3. Qlik Sense for Developers Help, May 2024. Section: "Building on-demand apps". This guide for developers reinforces the concept by detailing the creation of the two-part ODAG structure (selection app and template app), which is the core of the solution described in the correct answer. It outlines how the selection app works with aggregated data and the template app is used to generate the detailed view on demand.
Keep practicing
Take the free QSDA2024 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other QSDA2024 practice questions
- Question 4A Chief Information Officer has hired Qlik to enhance the organization's inventory analyt…
- Question 6A data architect implements Section Access on an app to reduce the data for each user whe…
- Question 9A data architect needs to acquire social media data for the past 10 years. The data archi…
- Question 10A startup company is about have its Initial Public Offering (IPO) on the New York Stock E…
