Microsoft
70-451 · Question #60
70-451 Question #60: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #60. The question stem and answer options stay visible for context.
Question
A database contains two tables named Table1 and Table1_Details. Table1_Details contains details about the items in Table1. You need to ensure that when an item is removed from Table1, all related items are removed from Table1_Details. You must achieve this goal by using the minimum amount of Transact-SQL code. What should you do?
Options
- ACreate a foreign key relationship. Set Cascade Delete to Set Null.
- BCreate a foreign key relationship. Set Cascade Delete to Cascade.
- CCreate a trigger on Table1_Details that fires on the Delete action.
- DCreate a stored procedure that deletes all related items from Table1_Detai!s.
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.