Chapter 12. Code Case Studies
Your real-world experience has given you opportunities to review and maintain code. The exam might also test your skills in this area. To help you prepare, this chapter presents multiple scenarios as code case studies. Review each case study and answer the questions.
Case Study 1
You are developing the necessary code to configure the Litware2012 database. This database will be hosted on a SQL Server 2012 instance. At present, the instance is configured in the following way:
FILESTREAM is not currently enabled.
No database master key exists.
01 USE [master] 02 GO 03 CREATE DATABASE [Litware2012] 04 GO 05 ALTER DATABASE [Litware2012] ADD FILEGROUP [Tertiary] 06 GO 07 ALTER DATABASE [Litware2012] ADD FILEGROUP [Quaternary] ...
Get Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
