Exam QSBA2024 topic 1 question 12 discussion

Actual exam question from QlikView's QSBA2024

Question #: 12
Topic #: 1

[All QSBA2024 Questions]

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?

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

Show Suggested Answer

Suggested Answer: A 🗳️

by shaan007 at Dec. 20, 2024, 12:08 a.m.

Comments

Submit Cancel

shaan007

3 weeks, 5 days ago

Selected Answer: C

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

upvoted 2 times

...

Exam QSBA2024 All Questions

View all questions & answers for the QSBA2024 exam

Exam QSBA2024 topic 1 question 12 discussion

Comments

shaan007

SY0-701