You administer a Microsoft SQL Server 2016 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 withinserts.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 2016 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 2016 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?
You install Microsoft SQL Server 2016 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?
You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.Users need to be able to SELECT from all tables in the database and execute the stored procedure.You need to grant only the necessary permissions.What should you do?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database.Does the solution meet the goal?
