You administer three Microsoft SQL Server 2012 servers named ServerA, ServerB, and ServerC. ServerA is the acting principal and ServerB is the mirror. You need to add ServerC as a witness to the existing mirroring session between ServerA and ServerB.…
You administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that has the following definition: You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to include only rows that contain a…
You want to add a new GUID column named BookGUID to a table named dbo.Book that already contains data. BookGUID will have a constraint to ensure that it always has a value when new rows are inserted into dbo.Book. You…
You administer two Microsoft SQL Server 2012 servers named ServerA and ServerB. You use a database named AdventureWorks. You need to prepare the AdventureWorks database for database mirroring. ServerB will act as the mirror in a mirroring partnership along with…
You administer three Microsoft SQL Server 2008 R2 instances. Database mirroring is configured in High-Safety mode with Automatic Failover between the following three servers: • SQL1 is the Principal server. • SQL2 is the mirror server. • SQL3 is the…
You administer a Microsoft SQL Server 2012 server that has multiple databases. You need to ensure that users are unable to create stored procedures that begin with sp_. Which three actions should you perform in sequence? (To answer, move the…
DRAG AND DROP You administer a Microsoft SQL Server 2012 server. A variety of issues occur from time to time in the production environment. You need to identify the appropriate tool for each issue. Which tool or tools should you…
You administer a single Microsoft SQL Server instance on a two-node failover cluster that has nodes named Node A and Node B. The instance is currently running on Node A. You want to patch both Node A and Node B…
You develop a database application for a university. You need to create a view that will be indexed that meets the following requirements: • Displays the details of only students from Canada. • Allows insertion of details of only students…
You create the following stored procedure. (Line numbers are included for reference only.) You need to ensure that the stored procedure performs the following tasks: • If a record exists, update the record. • If no record exists, insert a…