You are mastering the company database, On a SQL Server 2008, you find out that one of
the data files computer is broken. You should reserve the database which is from the most
recent configurations of backups. In order to cut the lost, you should find the method as
quickly as possible. Which is the correct answer?

You administer a remote SQL Server 2008 instance that contains a database named
InsightDB. The InsightDB database is used by an application that is continuously connected.
The application uses the INSERT command extensively and triggers the population of
multiple tables.
Users of the application report that the application performance is poor. You suspect that the
performance issues are related to blocking.
You need to monitor the state of the instance at regular intervals without affecting the
application performance further.
Which tool should you use?

Your workstation has installed Microsoft SQL Server Management Studio (SSMS), and not
installed Microsoft Business Intelligence Development Studio (BIDS).
You should design a package, which has the following features:
The package should be transactional.
The package should be optimized for 10 tables.

The package should be stored safely in the msdb database of a server which is remote.
Which is correct?

You maintain a SQL Server 2008 instance.
You find a SQL Server Agent job is failing. When you review the job history information, you
notice that the job history information is incomplete and appears to be truncated.
You need to ensure that all information produced by a job is available for viewing.
What should you do?

You administer a SQL Server 2008 instance that contains a database named SpatialDB. The
SpatialDB database includes spatial data types.
You need to perform a database consistency check on SpatialDB to include the spatial
indexes. You also need to ensure that the effect on the database concurrency is minimized.
Which Transact-SQL statement should you execute?

You are mastering the company database; there is the transaction information which is for
company’s Web-based order system in the database of the company.
The database is set to utilize the full recovery model. Between the hours of 20:00 and 04:00,
you get the few orders; one hour should be accepted for the risk when the system is
runningDatabase backups should be run as quickly as possible. You should create the
solution to avoid this kind of risk. What should you do?

You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2,
which include a copy of a database named Sales. The database is replicated between SQL1
and SQL2 by using transactional replication. A full backup of each database is performed
every night. Transaction log backups are performed every hour.
Replication latency is typically less than two minutes. One afternoon, the Sales database on
SQLTEST1 becomes corrupted.
You are unable to repair the database. The Sales database on SQLTEST2 is unaffected.
You need to return the Sales database on SQLTEST1 to normal operation as quickly as
possible.
You must ensure a minimum loss of data and minimal impact to users of either server. What
should you do?

You maintain a SQL Server 2008 instance that contains a database named Finance.
In your absence, a user with a login named Rob will maintain the database snapshots.
You need to giant the appropriate permissions to the user to delete the database snapshots
for the Finance database.
Which database permission should you giant?

You maintain a SQL Server 2008 Enterprise Edition instance that contains a database
named Finance. You need to reduce the size of the full database backup files of the Finance
database. Which Transact-SQL statement should you use?

You are managing a SQL Server 2008 instance which includes a database called TesterDB
for Home.com. The data file and the transaction log file which are located on the D: drive
that owns only 10 percent useful space. You should make sure that you move both files to
the G: drive.
Which is the correct answer?