What should you do?
Your database named DB1 is one of 15 databases located on a SQL Server 2005 computer named SQL1. Recently, users who work with DB1 report that they experience long query execution times. You want to reproduce and analyze this problem in a test environment that holds all copies of the production databases. You need to record the workload for an entire day on SQL1 for later execution on the test server. You must ensure that all events are captured without skipping any, even if SQL1 is under stress.
What should you do?
What are two possible ways to achieve this goal?
You use a SQL Server 2005 computer that was installed with the default settings. A database named DB1 is located on the server. Due to the recent failure of a hard disk controller, you decide to check the integrity of DB1. You create a maintenance task named CheckDB1 that uses default settings. Because this check must not interfere with user transactions, you schedule it to run over the weekend. The following Monday, you need to retrieve the outcome details of the CheckDB1 maintenance plan. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.
Choose two.)
What are two possible ways to achieve this goal?
TestKing.com has a server named SQL1 that is dedicated to SQL Server 2005. SQL1 is configured for SQL Server and Windows Authentication mode. Using Windows Authentication, you have sysadmin privileges on SQL1. All users who work with SQL1 report that all applications that use SQL1 stop responding. Your supervisor asks you to investigate the problem. In Task Manager, you notice that CPU usage is at 100 percent.
You try to connect to SQL1 by using SQL Server Management Studio. SQL1 does not respond. You need to connect to SQL1 to diagnose the problem. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
What should you do?
You are responsible for configuring and maintaining the backup jobs for a SQL Server 2005 computer. Backup files are written to a tape drive that is connected to the database server. In the future, your department will install a new backup server. Then backup files will be written to disk on the new server. To simplify maintenance, you need to configure the backup jobs so that minimal changes will be necessary to back up to the new server.
What should you do?
Which three actions should you perform?
TestKing.com uses a mission-critical database named DB1, which is located on a server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring.
Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)
What should you do?
TestKing.com has a network that consists of two domains named DOM1 and DOM2.
There is no trust relationship between DOM1 and DOM2. DOM1 contains a server named SQL1. DOM2 contains a server named SQL2. Both servers run SQL Server 2005. The SQL Server instance on SQL1 uses the DOM1SQLService1 service account. The SQL Server instance on SQL2 uses the DOM2SQLService2 service account. There are no mirroring endpoints on either server. SQL1 contains a database named DB1. You want to mirror DB1 to SQL2 by using high-protection mode without a witness. You need to create the database mirroring endpoints and configure security on all participating server instances. What should you do?
What should you do?
You are moving a SQL Server 2005 database named Timesheet to a new database server.
The Timesheet database is used by the TimeEntry application. You need to minimize the amount of time that the TimeEntry application is unavailable while you move the database.
What should you do?
Which two methods of the XML data type should you use?
You are writing a query that returns data from tables in a SQL Server 2005 database.
Some of the data is stored in relational columns, and some of the data is stored in XML data type columns. Your query needs to return a relational result set that contains data from relational fields and attribute values from XML data type columns. Which two methods of the XML data type should you use? (Each correct answer presents part of the solution. Choose two.)
Which command should you use?
You are a database developer for a company that manufactures bicycles. You are creating a Web application that will retrieve data from a database named TestKing. The application connects to a database server that is running SQL Server 2005. One of the functions of your application will allow shift supervisors to see how many bicycles were manufactured during the current shift. A user named Tom creates a stored procedure named usp_GetPersonData in the dbo schema. You are creating an HTTP endpoint that exposes a Web method named PersonData. This Web method allows client applications to access the stored procedure. You use the following statement to create the endpoint.
CREATE ENDPOINT SQLEP_AWPersons AS HTTP (PATH = ‘/AWpersons’, AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR), SITE = ‘SQL1’) FOR SOAP (WEBMETHOD ” (NAME=”), BATCHES = DISABLED, WSDL = DEFAULT, DATABASE = ‘TestKing’, NAMESPACE = ‘http://Adventure-Works/Persons’)
You need to specify the correct WEBMETHOD and NAME to create the endpoint.
Which command should you use?
What should you do?
You use Service Broker to manage data requests between SQL Server 2005 databases.
You need to make changes to objects for an existing service. You want to ensure that no messages can be received by the service until the changes are complete. What should you do?