What should you do?
You are the database administrator of your company. You are responsible for managing all databases stored on a SQL Server 2008 computer named SQL1.
You create a job with multiple steps that collects data from multipletables for reporting purposes. Each job step collects data for a particular report.
You configure the job to run daily. Users report that data for several reports is not updated regularly. You suspect that all steps configured in the jobare not being performed.
You want to ensure that each job step is performed even when if an error occurs. What should you do?
Which command should you issue to start the appropriate service?
You are the SQL administrator for your company. A SQL Server 2008 instance named SQL_Prod contains all theproduction databases.
From SQL_Prod , you need to connect to another SQL Server 2008 instance named SQL_Test.
However, you cannot obtain a list of the available servers.
You suspect that the appropriate service is not started.
Which command should you issue to start the appropriate service?
What should you do?
You are the SQL administrator for your company. You manage two SQL Server 2008 instances named SQL_Prod and SQL_Test . The SQL_Test instance is used by application developers to test new applications. A developer wants to be able to view the error log files for SQL Server, SQL Agent, SQL auditing, and WindowsEvents using the Log File Viewer component in SQL Server Management Studio. You need to grant thedeveloper the appropriate permission. What should you do?
which two log files could you look to obtain additional information about the error?
You are the database administrator of your company. Several users connect to an instance of SQL Server 2008 named SQL1.
A user reports that his session terminated unexpectedly. You want to identify the cause of theproblem.
In which two log files could you look to obtain additional information about the error? (Choose two. Each correctanswer represents a complete solution.)
Which trace flag should you use?
You are responsible for managing an instance of SQL Server 2008. You discover that the server is performingvery poorly.
You investigate and discover that deadlocks are causing the problem. You want to identify which processes and resources are causing the problem.
You want to ensure that theinformation you receive about deadlocks is formatted by processes and then by resources. Which trace flag should you use?
Which Transact-SQL statement should you run?
You are the database administrator of your company. The network contains a SQL Server 2008 computer thathas 15 databases. Users report that some queries take a long time to complete. You investigate and discoverdeadlocks are causing this problem.
You want to receive information about the resources and types of locks that are causing deadlocks along with thecurrent command affected by the deadlocks.
You want to receive this information in Extensible Markup Language(XML) format.
Which Transact-SQL statement should you run?
Which command-line utility should you use to do this?
You are the database administrator of your company. You maintain an instance of SQL Server 2008 named SQL1 .
SQL1 contains a database named Employees that contains information about the company’s employees.You create a maintenance job for the Employees database.
You configure the job to run when the processorutilization on the server is below 20 percent. After several days, you discover that the maintenance job has not run.
You discover that the SQL Server Agentservice is not running. You try to start the SQL Server Agent by using SQL Server Management Studio, but theagent will not start.
You want to diagnose the problem with the SQL Server Agent. Which command-line utility should you use to do this?
Which dynamic management view should you use to identify these sessions?
You are the database administrator for your company and manage all the SQL Server 2008 databases of thecompany. The production database named Prod1 contains all the product and sales-related data of the company. John, a database user, complains that he is not able to update the data in the tables. You suspect that a usersession is blocking John’s request. You want to identify the blocking sessions. Which dynamic management view should you use to identify these sessions?
which system stored procedure is executed by the application?
You are a database administrator for your company. You implement application roles to manage the security ofthe applications accessed by your company’s users.
You create an application role with the following code:
CREATE APPLICATION ROLE Cust_role1
WITH PASSWORD = ‘1254mtnl’,
DEFAULT_SCHEMA = Cust;
GO
You have granted all the required permissions to the Cust_role1 role to execute the application. You also grantpermissions on this role to the user Amy who is using the application. When Amy logs in to the application, which system stored procedure is executed by the application?
Which Transact-SQL script should you use?
You manage an instance of SQL Server 2008 named SQL1 . SQL1 contains a stored procedure named Sales_SP.
The Sales_SP is stored in a database named SalesDB in the Sales schema.
You discover that a temporary employee named Mary is able to run Sales_SP. You want to prevent Mary fromrunning the Sales_SP stored procedure.
You also want to prevent Mary from inheriting permission to run thestored procedure through any group or role membership.
Which Transact-SQL script should you use?