nerdexam
Microsoft

98-364 · Question #34

You work as a Database Designer for Hitech Inc. You are designing a database named Project. The company takes projects from outside and divides them into tasks (design, coding, etc.). Each task is…

The correct answer is A. TaskID. See the full explanation below for the reasoning.

Question

You work as a Database Designer for Hitech Inc. You are designing a database named Project. The company takes projects from outside and divides them into tasks (design, coding, etc.). Each task is assigned to only one employee. You want to use a primary key constraint to uniquely define each row in a table named Task. The tables are given below:

Which of the following attributes can be a primary key in the Task table?

Exhibit

98-364 question #34 exhibit

Options

  • ATaskID
  • BProjectID
  • CEmployeeID
  • DSocialSecurityNumber (SSN)

How the community answered

(31 responses)
  • A
    74% (23)
  • B
    13% (4)
  • C
    3% (1)
  • D
    10% (3)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice