O'Reilly logo

Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases by Peter Ward Orin Thomas and boB Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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] ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required