exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam

Exam 98-364 topic 1 question 215 discussion

Actual exam question from Microsoft's 98-364
Question #: 215
Topic #: 1
[All 98-364 Questions]

Philandrio Inc. is one of the largest drug manufacturing companies in the world.
It has many offices worldwide. Each office has a manpower of approximately 14,000.
The managers themselves are employees in the company.
You are building a database for the company's Human Resources Department (HRD).
You want to track the following attributes for each employee, and at the same time, eliminate duplicate entries and minimize data storage wherever possible.

FirstName -

MiddleName -

LastName -

EmployeeldentityNumber -

Address -

Date_of_Hire -

Department -

Salary -

ManagerIdentityNumber -
Which of the following is the appropriate table detail sufficient to track the above attributes, correctly and efficiently?

  • A. Only one table, Employee
  • B. Three tables, Employee, Manager, and a table to link both these entities
  • C. Two tables, Employee and Manager
  • D. Either two or three tables
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
robertscobar
3 years, 7 months ago
3 table is lowest space used.
upvoted 1 times
robertscobar
3 years, 7 months ago
3 tables would use less space and data repetition, eg department.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...