CISSP Question #76: Real Exam Question with Answer & Explanation

Question

Which of the following actions should be performed when implementing a change to a database schema in a production system?

Options

• ATest in development, determine dates, notify users, and implement in production
• BApply change to production, run in parallel, finalize change in production, and develop a back-out
• CPerform user acceptance testing in production, have users sign off, and finalize change
• DChange in development, perform user acceptance testing, develop a back-out strategy, and

Explanation

The best practice for implementing a change to a database schema in a production system is to follow a change management process that includes the following steps: Change in development, perform user acceptance testing, develop a back-out strategy, and implement change. This ensures that the change is properly tested, approved, documented, and communicated, and that there is a contingency plan in case of failure or unexpected results.

No community discussion yet for this question.