Microsoft-TS Microsoft SQL Server 2008 - Implementation and Maintenance Set 6

You manage a SQL Server 2008 instance. You upgrade a SQL Server 7.0 database to the SQL Server instance. You need to ensure the early detection of suspect pages in the database. What should you do?

You are the administrator of a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2008. The application uses stored procedures that include the EXECUTE AS clause and that use Microsoft Windows accounts. The company's written security policy states that all enterprise applications must run under the context of a service account that requires the minimum amount of privileges. You need to configure the SQL Server service torun under the appropriate context for the installation of the new enterprise sales application. Under which context should the SQL Server service run?

You need to install a SQL Server 2008 instance for a new application on an existing server that contains a default SQL Server 2005 instance. You need to ensure that both database instances are available for their respective certified third-party applications. You need to achieve this goal by complying with the following constraints: Minimal database administrative effort. The existing application environments remain unchanged. What should you do?

Which of the following is not a recommended optimization technique for SQL Server?

You administer two SQL Server 2008 instances named Instance1 and Instance2. A database named AdventureWorks resides on Instance1. You move the AdventureWorks database from Instance1 to Instance2. A SQL Server login named Mary with the password "Re#99$45" is used by a user to access the database on Instance1. You create the same SQL Server login on Instance2. The user attempts to access the AdventureWorks database on Instance2 by using the SQL Server login Mary. However, the user receives an error message which indicates that the access to the AdventureWorks database is denied. You need to ensure that the user can access the AdventureWorks database. Which Transact-SQL statements should you execute on Instance2?

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of two SQL Server 2008 instance. The two instances are respectively named InstanceA and InstanceB. There is a database named Dworks on InstanceA. You move the Dworks database to InstanceB. A user use a SQL Server login named Mary to access the database on InstanceA with the password "Tk@87#34". On InstanceB, you create the same SQL Server login. The user tries to use the SQL Server login Mark to access the Dworks database on InstanceB. But the user gets an error message, according to the indication of the message, the access to the Dworks database has been denied. You must make sure that the user can access the Dworks database on InstanceB successfully. So on InstanceB, which Transact-SQL statements should you execute?

You administer two SQL Server 2008 instances named Instance1 and Instance2. A database named Customers resides on Instance1. You move the Customers database from Instance1 to Instance2. A SQL Server login named User1 that has the password "111999" is used by a user to access the database on Instance1. You create the same SQL Server login on Instance2. The user attempts to access the Customers database on Instance2 by using the SQL Server login User1. However, the user receives an error message which indicates that the access to the Customers database is denied. You need to ensure that User1 can access the Customers database. Which Transact-SQL statements should you execute on Instance2?

You maintain a SQL Server 2008 instance that contains a database named Finance. A smallpercentage of data in the database is modified daily. You need to create a read-only copy of the database for reporting purposes at the beginning of each day by ensuring that minimal disk space is used. Which strategy should you use?

You are in the process of installing SQL 2008 as a a side-by-side upgrade. You want to migrate all databases from SQL 2005 to this new instance. Which method could you use to achieve this?

You administer a remote SQL Server 2008 instance. Users report that the performance of the application is poor. You use SQL Profiler to capture a workload of the remote instance to a trace table on the remote SQL Server instance. You need to analyze the workload of the remote SQL Server instance on a local SQL Server instance by using the Database Engine Tuning Advisor. What should you do?