Which of the following sentences are true regarding authentication modes? (Choose all that apply.)

You are working in a very secure environment and must enable HTTP endpoints to meet new application needs. You must ensure that only members authenticated to your domain can send requests to the endpoint and that even if someone were to hack into your network, data being sent to clients cannot be read. Which options would you need to enable to meet these requirements? (Choose all that apply.)

Which Transact-SQL function shows the last time statistics were updated for a specified index?

You are a DBA tasked with maintaining an installation of SQL Server 2005.One of your jobs is to correct the index fragmentation levels for all user tables in your database. During your fragmentation investigation, you determine that an index has external fragmentation levels greater than 30 percent. Which statement would you use to correct this amount of external fragmentation?

Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However, on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However, the query fails when executed. You need to troubleshoot the cause of the error. What should you do?

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 AdventureWorks. 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 Mike 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 = ‘AdventureWorks’,
NAMESPACE = ‘http://Adventure-Works/Persons’)

You need to specify the correct WEBMETHOD and NAME to create the endpoint. Which command should you use?

You are responsible for importing data into SQL Server 2005 databases. Your department is starting to receive text files that contain sales transactions from stores across the country. Columns in the data are separated by semicolons. You need to import the files into the sales database. What should you do?

You work at the regional sales office. You are responsible for importing and exporting data in SQL Server 2005 databases. The main office asks you to send them a text file that contains updated contact information for the cusMikeers in your region.
The database administrator in the main office asks that the data be sorted by the StateProvince, Surname, and FirstName columns. You need to satisfy these requirements by using the least amount of effort. What should you do?