You administer a Microsoft SQL Server database that includes a table named dbo.Log. This table contains millions of records about user activity in an application.Records in dbo.Log that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts.You need to be able to modify dbo.Log without requiring any changes to the applications that utilize dbo.Log.Which type of solution should you use?
You administer a Microsoft SQL Server 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 and to identify the root cause.What should you do?
You administer a Microsoft SQL Server database.Users report that a billing application becomes unresponsive during busy times of the day.While investigating, you notice large number of processes taking or waiting for table locks.You suspect that SQL Server is assigning stronger locks to queries.You start a SQL Profiler trace.Which event should you select?
DRAG DROP -You administer a Microsoft SQL Server 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 the list of actions to the answer area and arrange them in the correct order.)Select and Place:
You install Microsoft SQL Server 2012 on a new server.After setup is complete, you attempt to start the SQL Server service. After being in a starting state for a few moments, the service goes back to a stopped state.You need to determine the cause of the failure.Which file should you use?
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.You administer all the deployments of Microsoft SQL Server 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 configuration should you use?
