70-462 exam

You administer a Microsoft SQL Server 2012 instance. You need to stop a blocking process that has an SPID of 64 without stopping other processes What should you do?A . Execute the following Transact-SQL statement: EXECUTE sp_KillSPID 64B . Restart the SQL Server service.C . Execute the following Transact-SQL statement:...

DRAG DROP You administer a Microsoft SQL Server database 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 use? (To answer, drag the appropriate tool or tools to the...

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server. What should you create?A . An Extended Event...

DRAG DROP 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 ServerA . Which three actions should you perform...

You administer a Microsoft SQL Server database that has Trustworthy set to On. You create a stored procedure that returns database-level information from Dynamic Management Views. You grant User1 access to execute the stored procedure. You need to ensure that the stored procedure returns the required information when User1 executes...

DRAG DROP You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job. The SSIS package accesses a network share when exporting data from...

DRAG DROP You administer a Microsoft SQL Server 2012 database. All database traffic to the SQL Server must be encrypted by using secure socket layer (SSL) certificates or the connection must be refused. Network administrators have deployed server certificates to the Windows store of all Windows servers on the network...

DRAG DROP You administer a Microsoft SQL Server 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 value in the SpecialOfferID column. Which four Transact-SQL statements...

Note: This question is part of a series of questions that use the same set of answers choices. An answer choice may be correct for more than one question in the series. You administer a Microsoft SQL Server that hosts a transactional database and a reporting database. The transactional database...

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following table. You discover that all files except Sales_2.ndf are corrupt. You need to recover the corrupted data in the minimum amount of time. What...