Microsoft
70-451 · Question #79
70-451 Question #79: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #79. The question stem and answer options stay visible for context.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. You are creating a database to support the office manager. Your database model has the following structure. The database design has the following business requirements: - An employee can be assigned more than one task. - Upon completion, the task is deleted. - When a task is deleted, the associated assignment is deleted. When an employee is no longer available to complete a task, the employee link to the assignment is replaced with a NULL value. You need to implement the business requirements to maintain data integrity. What should you do?
Options
- ACreate DDL INSERT triggers on the Employee, Task, and Assignment entities.
- BCreate CHECK constraints on the TaskID and EmployeeID attributes in the Assignment entity.
- CCreate Foreign Keys constraints on the TaskID and EmployeeID attributes in the Assignment
- DCreate Foreign Keys constraints on the TaskID and EmployeeID attributes in the Task and
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.