Exam QSBA2024 topic 1 question 12 discussion

✅ Why Option C is Best: The Bucket feature in Qlik Sense is designed to group continuous numerical values (like age) into named ranges/categories It creates a new field in the data model, which improves performance and ensures reusability across visualizations It avoids repeatedly computing logic in expressions (as in nested IFs), which is more efficient for large datasets; ❌ Why the Other Options Are Less Effective: A. Ask the ServiceNow team to create the field: May be ideal in a controlled environment, but not efficient or flexible for quick implementation or prototyping B. Excel sheet with mappings: Not scalable, and maintaining it manually is error-prone — also adds unnecessary joins D. Master dimension with nested IF: Works, but logic is calculated at runtime in every chart, which hurts performance on large data

Why answer A is wrong: While having the categorization done at the source can offload processing, it might not be practical or timely if collaboration with the ServiceNow team is limited. It also reduces the analyst's control over the categorization logic. So the answer is C because - The Bucket option in the Data manager allows you to efficiently create a calculated field based on ranges of values