You have been hired as a Database Consultant by vceguide.com to design a SQL Server 2012 database solution. You are tasked with designing a scale-out and high-availability SQL Server 2012 Online Transaction Processing (OLTP) database solution that will maintain copies…

You administer a Microsoft SQL Server 2012 database. You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated privileges. You need to ensure that the…

You administer a Microsoft SQL Server 2012 database instance. You create a new user named UserA. You need to ensure that UserA is able to create SQL Server Agent jobs and execute SQL Server agent jobs owned by UserA To…

You administer a Microsoft SQL Server 2012 instance named SQL2012. You are in the process of migrating a database from a SQL Server 2008 instance named SQL2008 to the SQL2012 instance. You have upgraded a database from the SQL2008 instance…

You plan to install a Microsoft SQL Server 2012 instance. The instance will support a database that has the following requirements: Store Excel workbooks on the file system. Access the workbooks through Transact-SQL. Include the workbooks in database backups. During…

You plan to install Microsoft SQL Server 2012 for a web hosting company. The company plans to host multiple web sites, each supported by a SQL Server database. You need to select an edition of SQL Server that features backup…

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to collect data for a long period of time to troubleshoot wait statistics when querying Contoso. You also need to ensure minimum impact…

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to track all SELECT statements issued in the Contoso database only by users in a role named Sales. What should you create? A.…

You administer a Microsoft SQL Server 2012 environment. One of the SQL Server 2012 instances contains a database named Sales. You plan to migrate Sales to Windows Azure SQL Database. To do so, you need to implement a contained database.…

You administer a Microsoft SQL Server 2012 database that includes a table named Application.Events. Application.Events contains millions of records about user activity in an application. Records in Application.Events that are more than 90 days old are purged nightly. When records…