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 are mastering the company database called TesterDB; the database includes a
database that uses SQL Server log shipping. Log shipping will happen half a hour. You
should make the full backup.
In order to cut the net bandwidth utilization when maintenance every night.
Which is the correct answer?

You are mastering the company database, Users complaints that the SQL Server 2008
application is running slowly. You should check the information of the CPU utilization, disk
utilization, and memory utilization. The network should be considered. the detailed
information should be checked for the proper example of SQL Server2008.Which is the
correct answer?

You maintain a SQL Server 2008 instance that contains a database named Finance. The
recovery model of the Finance database is set to Full.
The backup strategy for the Finance database is as shown in the following table.

The system databases, user database data, and log files are stored on separate disks. The
hard disks that contain the user database data files are reported to have failed at 15:00
hours on Wednesday.
You need to restore the Finance database from the database backups by ensuring minimal
data loss in minimum possible time.
What should you do?

You maintain a SQL Server 2008 instance that contains a database named Finance.
The Finance database contains the following filegroups:
The PRIMARY filegroup that contains the On-Line Transaction Processing (OLTP) data
stored in the F: volume.
A filegroup named Histoiy that contains historical data stored in the G: volume.
The transaction log of the database is stored in the H: volume.
As part of the archiving strategy for the Finance database, data is frequently moved from the
PRIMARY filegroup to the History filegroup.
The backup strategy for the Finance database consists of the following requirements:
Backing up the PRIMARY filegroup five times a day
Backing up the History filegroup at the end of each working day
Backing up the transaction log every 15 minutes
At 13:00 hours, the volume that contains the History filegroup fails.
You need to restore the database by ensuring minimal data loss in minimum possible time.
What should you do?

You maintain an instance of Microsoft SQL Server 2008. The instance contains a database
named Finance.
The recovery model of the Finance database is set to Full. A full database backup of all the
user databases is performed at 02:00 hours daily. The transaction log backup occurs every
15 minutes. A differential backup is performed every 4 hours.
You plan to perform a full backup of the Finance database at 11:00 hours.
You need to ensure that the backup is performed without affecting the overall backup and
restore procedures for the Finance database. You also need to ensure that the backup files
are restored in proper sequence.
Which Transact-SQL statement should you use?

You maintain a SQL Server 2008 instance that contains a database named Finance. The
Finance database currently contains 100 GB of data. On an average, 1 GB of data is
modified or inserted daily.
The recovery model of the Finance database is set to Simple. Business requirements specify
that data loss of more than two hours worth of transactions during business hours is
unacceptable.
You need to select a backup strategy that uses the least amount of disk space by adhering
to the business requirements.
What should you do?

You are mastering the company database, and managing 20 SQL Server 2005 computers
which are operated by other administrators that are asked to meet company service level
agreements (SLAs) on querying response time.
Some of the method on controlling query response times on the servers should be told for
these administrators.
Which is the correct answer?

You administer a SQL Server 2008 instance.
A stored procedure is used as the data source for a report that is frequently executed during
business hours. Users report that the data returned by the report is inconsistent. You
discover that the inconsistencies are caused by phantom reads. You need to ensure that the
report returns consistent results without affecting other users. What should you do?

You are managing a SQL Server 2008 instance which includes some applications for
Home.com. You set the SQL Server Agent service to implement through utilizing the
SerTest\Test account. You create a job named MailingTester that allows a file to be stored to
a log server. The job could not run normally because it could not own proper access to the
log server. You decide to set the service of SQL Server Agent. You should make sure that
you could run the settings such that the SQL Server Agent service owns all access to the log
server. Which is the correct answer?