Microsoft
70-451 · Question #108
70-451 Question #108: Real Exam Question with Answer & Explanation
The correct answer is A. a WHILE loop that contains a single DELETE statement. See the full explanation below for the reasoning.
Question
You have a database that has 20 tables. The tables are not configured to have any referential integrity. All tables have primary keys. Each table contains over 5 million rows. Ten percent of the rows contain outdated information. You need to design a maintenance process to delete all outdated rows. The solution must meet the following requirements: - Minimize execution time - Minimize development effort - Minimize blocking other processes - Prevent deletion failures from affecting the entire deletion process What should the design include?
Options
- Aa WHILE loop that contains a single DELETE statement
- Bmultiple TRUNCATE TABLE statements
- Ca single transaction that contains multiple DELETE statements
- Dan IF statement that contains a single DELETE statement
Community Discussion
No community discussion yet for this question.