You administer a SQL Server 2008 instance. You use an internal application based on SQL
Server 2008. The application uses Analysis Services and Reporting Services. Company
security policy requires that the surface area for all the deployed components of SQL Server
2008 be configured.
You need to implement the security policy and devise a method to evaluate the security
policy against other database servers.
What should you do?

You administer a SQL Server 2008 cluster in a high security environment.
You plan to configure and use encrypted connections for the clustered virtual SQL Server.
You need to install the certificate that will be used for encryption.
What should you do?

You administer a SQL Server 2008 instance that contains a database named Adventure
Works. The AdventureWorks database contains the Products table.
You create a Merge Replication topology and a Publication to replicate the Products table to
the SQL Server instances at remote locations. The Publication has a 21-day retention
period.
When a user returns from a one-month vacation, she discovers that her database does not
contain the most recent data. The Windows Event log states the following error message:
“Replication: expired subscription dropped.”
You need to obtain the most recent data in the database of the user.
You also need to ensure that future data changes are appropriately replicated.
What should you do?

You are mastering the company database, with a SQL Server 2008 computer called
SQLTEST1.There are three examples of SQL Server in the SQLTEST1.The ability to
connect to the dedicated administrative connection on every example of SQL Server should
be included in the disaster recovery plan of the company. You find that you could connect to
the connection on SQLTEST1 default example while testing this ability; you could not
connect to the dedicated connection on the two other examples on SQLTEST1. You should
clarify that the examples are implementing and that client applications should be able to
approach them. You should make sure that no other administrators are attempting to
connect to any dedicated connections on SQLTEST1. You should also make sure that you
could connect to the dedicated connection on all three examples. Which is the correct
answer?

You administer a SQL Server 2008 instance that contains a database named Ad venture
Works.
You are log shipping the Adventureworks database to a remote SQL Server 2008 instance.
During the weekend, the primary SQL Server instance required a restart. After the weekend,
you discover that log shipping has stopped working.
You need to troubleshoot log shipping of the Adventureworks database.
What should you do?

You administer multiple SQL Server 2008 instances.
You plan to install a SQL Server 2008 mission-critical cluster on two cluster-ready nodes.
The mission-critical cluster requires constant availability.
You need to configure the SQL Server cluster to failover by ensuring that the service
disruption is minimized.
Which failover option should you use?

You maintain multiple SQL Server 2008 instances.
You are designing a consolidated repository of performance data.
You need to ensure that the following requirements are met:
-The data collector is used to gather performance information. -A single database stores
performance information for all instances. -Performance information that is older than 14
days is deleted. -Administrative effort to manage performance data is minimized.
What should you do?

Yon manage several SQL Server 2008 instances.
You plan to collect performance data periodically on all instances by using the data collector.
All collected data must be stored in the same database hosted on a single instance. You
need to collect and load performance data in the management data warehouse every 6
hours. Which data collection process should you implement?

You administer a SQL Server 2008 instance that contains the AdventureWorks database.
The Adventure Works database uses the bulk-logged recovery mode. You log ship the

AdventureWorks database across a WAN link. There is a scheduled job that rebuilds the
indexes of the AdventureWorks database. You discover that the job increases the size of the
log backups for log shipping. You need to minimize the size of the log backups used by log
shipping. What should you do?

You are mastering the company database. During the development, you find that TransactSQL query below is running slowly:SELECT VideoTitle, UpcNum, RetailPrice, Release Date
FROM Srvideo.VideoTitle WITH (INDEX(0)) WHERE ReleaseDate BETWEEN ‘20050401’
AND ‘20050510’ A clustered index exists on the VideoTitle column.
There is a nonclustered index on the ReleaseDate column which contains the UpcNum and
RetailPrice columns. The result of the avg_fragmentation_in_percent is 30 percent, when
you search the sys.dm_db_index_physical_stats dynamic management function (DMF) or
the VideoTitle table,In order to find this method to solve this problem, which is the correct
answer?