Conducting UAT for a New Feature | Dataford Interview Questions

What is your process for conducting User Acceptance Testing (UAT) on a new feature?

For a SQL-based UAT check, compare each test case's acceptance criteria with its recorded Adobe feature events. Include test cases with no events and testers whose records are missing.

Output

One row per UAT test case
Columns: case_id, feature_name, tester_name, expected_events, observed_events, expected_successes, observed_successes, and uat_status
Include PASS only when both observed counts match the expected counts, otherwise FAIL
Order by case_id ascending

Schema

uat_cases

Column	Type	Description
case_idPK	INT	Unique UAT test case identifier
feature_name	VARCHAR(150)	Adobe feature being tested
tester_id	INT	Assigned tester identifier
expected_events	INT	Expected number of recorded events
expected_successes	INT	Expected number of successful events

testers

Column	Type	Description
tester_idPK	INT	Unique tester identifier
tester_name	VARCHAR(100)	Tester display name

feature_events

Column	Type	Description
event_idPK	INT	Unique recorded feature event
case_id	INT	Associated UAT test case
event_success	BOOLEAN	Whether the feature event met its expected outcome

Your question is Conducting UAT for a New Feature. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem