Qlik Sense System Administrator Certification (2024) — Question 4

A business analyst is creating an app using a dataset from ServiceNow. The dataset shows information about support cases, including how many days it has been since the case was opened (age).
The app requirements are:
• The dashboard must display support cases in categories based on the age (New, Aging, and Beyond Service Level Agreement)
• The categories will be used multiple times in the dashboard
• Given the volume of support cases, it is expected that the dataset will grow to be very large
Which solution is the most efficient way for the business analyst to create this app?

Answer options

• A. Ask the ServiceNow team to create the field in the source dataset
• B. Create an Excel sheet with all possible age values and the corresponding categories to add to the data model
• C. Create a new field for the categories using the Bucket option in the Data manager
• D. Write a master dimension with a nested IF statement to group ages together

Correct answer: C

Explanation

The correct answer is C because using the Bucket option in the Data manager allows for efficient categorization of cases based on age without needing to modify the source dataset or manage additional files. Options A and B require more manual intervention and may not scale well with a large dataset, while D could lead to complex and less maintainable code.