Which of the following is the main reason to configure a separate monitor server in a log shipping configuration?

You are employed as a database administrator at Hi-tech Company. Your duties at Hi-tech Company encompass administrating a SQL Server 2005 database named Datebase01. The Hi- tech Company Web site has a page for clients to send the comments about its products and the company.
You received instruction from the CIO to use Datebase01 to store the comments in the Comments column of a table named TBContent. You implement full-text searching in order to run reports on the comments. What actions should you execute? (Choose all that apply)

To create an indexed view, the base tables for the view must meet many criteria. The view then has additional restrictions. Some examples of these restrictions are as follows, which is Correct?

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?