70-463 · Question #137
70-463 Question #137: Real Exam Question with Answer & Explanation
The correct answer is D: EmployeeNum. EmployeeNum (Employee Number) is the correct column for a unique constraint. EmployeeNum represents the business/natural key - a human-assigned identifier (such as a badge number or HR identifier) that uniquely identifies each employee and is used operationally to reference emplo
Question
Exhibits
Options
- ADateHired
- BDepartmentID
- CEmployeelD
- DEmployeeNum
- EFirstName
- FJobTitle
- GLastName
- HMiddleName
- IReportsToID
Explanation
EmployeeNum (Employee Number) is the correct column for a unique constraint. EmployeeNum represents the business/natural key - a human-assigned identifier (such as a badge number or HR identifier) that uniquely identifies each employee and is used operationally to reference employees across systems. While EmployeeID is likely the primary key (a surrogate key), the question asks for a unique constraint specifically, implying a secondary uniqueness requirement on the business identifier. EmployeeNum must be unique to reliably join with EmployeeData and to prevent duplicate employee records from different sources. Other columns like FirstName, LastName, DepartmentID, JobTitle, and ReportsToID are not unique per employee and cannot serve as unique identifiers.
Community Discussion
No community discussion yet for this question.