You administer a SQL Server 2008 instance.
Customers report server performance degradation because of a newly implemented process.
You use Dynamic Management Views to verify that there are no long running queries.
You need to correlate the operating system performance data with the actual query execution trace by
using minimum administrative effort.
What should you do?

You administer a SQL Server 2008 database solution.
All data modifications are performed through stored procedures that use only the INSERT, UPDATE, or DELETE statements.
You are designing a backup strategy.
You need to ensure that the following business requirements are met:
The backup strategy supports point-in-time recovery for failure at any time of day.
The transaction log uses the least amount of disk space.
What should you do?

You administer a SQL Server 2008 instance that hosts a large database.
The database experiences high volumes of queries and transactions that are processor-intensive.
You plan to implement an incremental backup strategy for the database. You also plan to use backup
compression.
You need to ensure that the backup jobs have a minimal effect on the performance of the server.
What should you do?

You administer a SQL Server 2008 instance.
The instance is one of three servers in a peer-to-peer transactional replication topology. The publication
contains a table named Orders. The Orders table contains 200 GB of data across multiple partitions.
A batch process bulk loads 10 GB of data to the Orders table periodically.
You need to design a replication strategy to minimize latency.
What should you do?

You administer a SQL Server 2008 instance.
You plan to design a high-availability solution by using database mirroring.
The current application includes programming logic that will retry transactions if a failover occurs.
You need to configure a strategy that will provide the minimum amount of latency for committed transactions.
What should you do?

Your SQL Server 2008 server has only the SQL Server service running. All other SQL Services are
disabled. You have a user named DBReportsUser.
You need to restrict DBReportsUser to login only between 17:00 hours and 22:00 hours. You want to
achieve this goal by using the minimum amount of administrative effort and the least impact on the Server
security.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing the storage scheme for a new SQL Server 2008 database application. The application
will primarily be used to query data. The database will be initially populated with 4 terabytes of data stored
in 20 tables. The data is distributed evenly throughout all 20 tables.
Every night, between 100 GB and 300 GB of new data will be loaded into 4 database tables.
The remaining 16 tables will remain static.
The average CPU utilization of the server where the application will reside is between 30 and 50 percent.
You need to ensure that the amount of disk space used is reduced.
You need to achieve this goal by ensuring minimum impact of performance on the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you. The largest table in a database is partitioned into four equal-sized parts.
The first two partitions are seldom queried, while the third partition is regularly queried by several reports.
Meanwhile, the fourth partition is heavily queried and regularly modified.
The disk space of the table should be cut to the least and the query performance should be with the least impact.
What will you do? (Choose more than one.)