70-462 exam

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: - A data file of 2 terabytes is located on a dedicated LUN (drive D). - A transaction log of 10 GB is...

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to be notified immediately when fatal errors occur on Server01. What should you create?A . An AlertB . A Server Audit SpecificationC . An Extended Event sessionD . A Resource PoolE . A...

DRAG DROP You administer a Microsoft SQL Server database that is used by an application. Users of the application report performance issues. You need to choose the appropriate tool for performance-tuning of SQL Server databases. Which tool or tools should you use? (To answer, drag the appropriate tool or tools...

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 Microsoft SQL Server 2012 database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sales schema. You need to manage users who are prevented from deleting records in the Sales schema. You need...

DRAG DROP You administer a Microsoft SQL Server 2012 database called Human_Resources. The database contains a table named dbo.Salary. You need to ensure that all read activity against dbo.Salary is audited and written to the Windows Security Log. What should you do? (To answer, move the three appropriate actions from...

DRAG DROP 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 appropriate actions from the list of actions to...

You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured...

You administer a Microsoft SQL Server 2012 instance. After a routine shutdown, the drive that contains tempdb fails. You need to be able to start the SQL Server. What should you do?A . Modify tempdb location in startup parameters.B . Start SQL Server in minimal configuration mode.C . Start SQL...

DRAG DROP You administer a Microsoft SQL Server 2012 database called Human_Resources. The database contains a table named dbo.Salary. You need to ensure that all read activity against dbo.Salary is audited and written to the Windows Security Log. What should you do? (To answer, move the three appropriate actions from...