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

You are managing a SQL Server 2008 instance for Company.com. You decide to publish an instance of SQL Server Reporting Services (SSRS) which keeps the old information to the same machine. And make it as default. Which is the correct answer?

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of two instances both of which run on the same computer. One is a SQL Server 2008 instance; another is a SQL Server 2005 instance. There is a database named DB1 in the SQL Server 2008 instance. DB1 uses the Fulltext indexes. Several records that include the word "root" are added to DB1. An empty resultset is returned when the Fulltext index is queried for the word "root." You must make sure the query can return records that contain the word "root". What should you do?

You are managing a SQL Server 2008 sample which includes an On-Line Analytical Processing (OLAP) database together with a dimension table called Tester for the Company.com. You should refresh the Tester table each hour. The Tester table includes data which is not useful. In order to keep the disk space used to reserve the Tester table.Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products for Company.com. You decide to update a SQL Server6.0 database to the SQL Server instance. You should make sure that the early detection of suspect pages in the database.Which is the correct answer?

You are managing a SQL Server 2000 instance for Company.com. You decide to install a SQL Server 2008 instance for a new application. Not only you should make sure that both database instances are useful for their respective certified third-party applications but also you should finish this goal through constraints listed below: You should cost Minimal cost.You could not change application environmentsWhich is the correct answer?

You are managing a SQL Server 2000 instance which includes a database called Products for Company.com. You decide to install a SQL Server 2008 instance for business. You should make sure that third-party applications could run normally on both database instances, you could get the results by conforming to the listed conditions:1. The existed application environments keep common. 2. Minimal database administrative effort.Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called TestDB for Company.com. There is the Products table in TestDB. In order to reproduce the Products table to the SQL Server instances at remote locations; you develop a Merge Replication topology and a Publication which owns a 25-day retention period. When a user called Clerk returns from a one- month vacation, He finds out that her database does not includes newest data. The error message is listed below: "Replication: expired subscription dropped." Not only you should get the newest data in the database of the user, but also you should make sure that the information changes are properly doubled. In order to solvethe problem, which is the correct answer?

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible. In the options below, which strategy should you use?

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use?

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DeliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use?