$5.$ Ensure that you can isolate performance problems when they occur, as well as monitor

ongoing SQL performance and usage. Optimize the performance of your database by

performing the appropriate tasks. Ensure that your database is regularly checked for

inconsistencies and backed up$.$ Any problems should be emailed to your

trioscollege.com email address.

$6.$ Provide suitable fault tolerance for your database.

$7.$ For steps $1-6,$ document what you did to achieve each step $($point$-$form under each step

within this document, with appropriate screenshots or code output to illustrate your

choices$).$ Hint: You can reuse parts of the code used to mark your SQL$16$A final project!

$8.$ Send me a copy of this document as well as a FULL backup of your database for marking

$($either via email or MS Team chat$).$

$9.$ Optional bonus: Design a new database that will be used as a data warehouse for your IT

Consulting Company database. Identify which information from your database is most

valuable for business intelligence analysis. Next, define your dimensions for the data

warehouse as well as the data points to store in the fact table. Finally, select the columns

to include in each dimension table, and optionally implement your design.