BA Role Tools and Technologies 2 — Questions and Answers
Question 1: A BA needs to capture a complex approval workflow that involves conditional routing based on dollar thresholds. Which tool is most appropriate?
- Fishbone diagram
- BPMN process model (Correct answer)
- Entity-relationship diagram
- Context diagram
Correct answer: BPMN process model
BPMN (Business Process Model and Notation) supports conditional gateways and is the standard for modeling complex workflow logic.
Question 2: Which Confluence feature allows a BA to require stakeholder sign-off on a requirements document before work begins?
- Page labels
- Page restrictions
- Page approvals / workflow (Correct answer)
- Inline comments
Correct answer: Page approvals / workflow
Confluence's page approvals (or workflow plugins) let approvers formally sign off, creating an audit trail before development starts.
Question 3: A BA is facilitating requirements with a geographically distributed team. Which collaboration tool feature is most critical for real-time co-creation of a process map?
- Threaded comments
- Simultaneous multi-user editing on a shared canvas (Correct answer)
- Version history export
- Read-only viewer access
Correct answer: Simultaneous multi-user editing on a shared canvas
Simultaneous multi-user editing (as offered by Miro or Lucidchart) lets remote participants build diagrams together in real time.
Question 4: In a Jira backlog, what is the primary purpose of epics relative to user stories?
- Epics track bugs; stories track features
- Epics group related stories under a larger business goal (Correct answer)
- Epics are assigned to QA; stories to developers
- Epics replace the product roadmap
Correct answer: Epics group related stories under a larger business goal
Epics are large bodies of work that can be broken down into multiple user stories, organizing the backlog around business capabilities.
Question 5: A BA is creating a decision table to validate discount eligibility rules. What is the main advantage of this artifact over a narrative requirements document?
- It requires less stakeholder review
- It visually maps every combination of conditions and outcomes (Correct answer)
- It automatically generates test cases in Jira
- It replaces the need for a use case diagram
Correct answer: It visually maps every combination of conditions and outcomes
Decision tables systematically cover all combinations of input conditions and their corresponding actions, reducing the risk of missed rule scenarios.
Question 6: Which SQL clause would a BA use to filter aggregated results — for example, finding customer segments with more than 500 orders?
- WHERE
- GROUP BY
- HAVING (Correct answer)
- ORDER BY
Correct answer: HAVING
HAVING filters rows after aggregation (e.g., COUNT, SUM), whereas WHERE filters individual rows before grouping.
Question 7: When using Tableau to analyze sales data, a 'drill-down' interaction allows users to:
- Export the dashboard to PDF
- Navigate from a summary view to more granular detail (Correct answer)
- Combine two data sources into one
- Apply a row-level security filter
Correct answer: Navigate from a summary view to more granular detail
Drill-down lets users click a high-level dimension (e.g., Year) to reveal more granular levels (Quarter → Month), supporting self-service exploration.
BA Role Tools and Technologies 2
A BA needs to capture a complex approval workflow that involves conditional routing based on dollar thresholds.
Which tool is most appropriate?