70-462 exam

You administer a Microsoft SQL Server 2012 server. When transaction logs grow, SQL Server must send an email message to the database administrators. You need to configure SQL Server to send the email messages. What should you configure?A . SQL MailB . An Extended Events sessionC . Alerts and operators...

You administer a single server that contains a Microsoft SQL Server 2012 default instance on which several production databases have been deployed. You plan to install a new ticketing application that requires the deployment of a database on the server. The SQL login for this application requires sysadmin permissions. You...

You administer a Windows Azure SQL Database database named Orders. You need to create a copy of Orders named Orders_Reporting. Which Transact-SQL command should you use?A . BACKUP DATABASE Orders TO DISK = 'D:Orders.bak'RESTORE DATABASE Orders_Reporting FROM DISK = 'D:Orders.bakB . BACKUP DATABASE Orders TO DISK = 'D:Orders.bak'CREATE DATABASE Orders_Reporting...

Topic 1, Volume A You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off-loaded from the primary database to another server. You also need to be able to add indexes to...

You administer a Microsoft SQL Server 2012 database named Orders. Users report that during peak usage periods, certain operations are taking more time than expected. Your initial analysis suggests that blocking is the cause. You need to gather more data to be able to determine which processes are being blocked...

You administer a Microsoft SQL Server 2012 database. You configure Transparent Data Encryption (TDE) on the Orders database by using the following statements: You attempt to restore the Orders database and the restore fails. You copy the encryption file to the original location. A hardware failure occurs and so a...

DRAG DROP You administer a Microsoft SQL Server 2012 database. Your database is experiencing deadlock issues. You need to be able to monitor deadlocks. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them...

DRAG DROP You are a database administrator of a Microsoft SQL Server 2012 environment. The environment contains two servers named SQLServer01 and SQLServer02. The database Contoso exists on SQLServer01. You plan to mirror the Contoso database between SQLServer01 and SQLServer02 by using database mirroring. You need to prepare the Contoso...

You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders. Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index named IX_OrderDate on the CustomerOrder table is...

You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail. You also need to minimize the amount of storage used by the database. Which...