You are mastering the company database, You should check the log of the a SQL Server
2005 Enterprise Edition everyday, You get the information on the torn page errors of the
database. In order to fine the solution of the torn page, Which is the correct answer?

You administer several SQL Server 2008 instances.
You need to ensure that all SQL Server instances are consistently configured for the
following aspects:
-Naming conventions -Security settings -Force index creation -Avoidance of data
fragmentation
What should you do?

You administer a SQL Server 2008 instance and a SQL Server 2005 instance. Both
instances run on the same computer. The SQL Server 2008 instance contains a database
named WebApplicationDB that uses the Fulltext indexes.
Several records that include the word “root” are added to the WebApplicationDB database.
When the Fulltext index is queried for the word “root,” an empty resultset is returned.
You need to ensure that records that contain the word “root” are returned by the query.
What should you do?

You are managing a SQL Server 2000 instance which includes a database called Products
for Home.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 administer a SQL Server 2008 instance. You plan to install a SQL Server Analysis
Services (SSAS) instance. The SSAS instance will be accessed by an Internet Information
Services application by using anonymous access. You need to ensure that the application
can access the SSAS instance. 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 maintain a SQL Server 2008 instance.
The SQL Server instance is configured to use the -T1222 and -T1204 trace flags during
startup.
You need to ensure that your failure recovery plan backs up the use of the trace flags.
What should you do?

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 managing a SQL Server 2008 instance which includes a database called Products
for Home.com. On the Products database, logged operations are executed. You should
make sure that the database could be recovered to a special point in time. Which is the
correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products
for Home.com. You should not modify the database frequently everyday. You should make
sure that you develop a read-only copy of the database for reporting purposes at the
beginning of every day .Which is the correct answer?