What should you do?
You are the administrator of a SQL Server 2005 computer named SQL1. The SQL Server transaction log files are stored on an 80-GB mirrored volume. New databases have been added to SQL1, and the 80-GB volume is 85 percent full. You do not currently have the ability to upgrade the volume or to add more disk space. You need to receive an alert if the unused disk space on the 80-GB volume falls below 5 GB. What should you do?
Which two actions should you perform?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS)package.The OLE DB
data source for the package is a database that is updated frequently.You need to create a package that
accomplishes the following tasks:
Implement the IRowsetFastLoad interface.Support various data flow destinations. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You are the administrator of a SQL Server 2005 computer named SQL1. The SQL Server transaction log files are stored on an 80-GB mirrored volume. New databases have been added to SQL1, and the 80-GB volume is 85 percent full. You do not currently have the ability to upgrade the volume or to add more disk space. You need to receive an alert if the unused disk space on the 80-GB volume falls below 5 GB. What should you do?
Which two actions should you perform?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The package uses at least one sequence container in one transaction. Each transaction controls a Data Flow task and a Control Flow task. Each Data Flow task has a Success constraint.
The Control Flow task follows the Success constraint. The package must include the following requirements:
Each Data Flow task must use its own transaction.
The Control Flow task and the Data Flow task that precedes it must succeed or fail as an atomic unit.
A restart point must restart each Data Flow task and the Control Flow task that follows it as an atomic unit.
You need to make changes in the control flow designer to meet the outlined requirements.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You are the database administrator for a SQL Server 2005 computer named SQL1. Your company has five databases running on a single SQL Server 2005 instance. All indexes are created by using the SORT_IN_TEMPDB option to reduce the amount of time required and the amount of space used in the user databases to create and rebuild indexes.
You need to design the tempdb database for optimal performance. What should you do?
Which two actions should you perform?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.
The report must meet the following specifications:
When the report is run from a Helpdesk application, the report toolbar must not be displayed. When the report is run from an Intranet Portal application, the report toolbar must display the list of parameters only on the request of the user.
You need to provide the report URL for each application.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You are a database administrator for AIOTestKing.com. The company uses a database named VideoStore. The SQL statements used to create the Sales table in the VideoStore database, an existing index, and the two most common queries executed against this table are shown in the exhibit. (Click the Exhibit button.) 
The existing indexes have just been rebuilt. The VideoID and VideoTitle fields are highly selective. The RetailPrice, WholesalePrice and Genre fields have low selectivity. You need to optimize the performance of both queries while minimizing the size of the index. What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package must be deployed on 10 servers. You do not have access to the file system on any of these 10 servers. You need to set different package configuration properties at the package run time. What should you do?
What should you do?
You are a database administrator for AIOTestKing.com. You have many complex SQL Server Integration Services (SSIS) packages that move data among your servers. The SSIS packages import and export data to and from your company’s trading partners. The SSIS packages can only run after certain conditions are met that exist outside of SQL Server. Your department uses a third-party tool to schedule the running of nightly scripts to test for these conditions. You need to run SSIS from your scripts as seamlessly as possible. What should you do?
Which two actions should you perform?
You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
The project has the following objects:
A cube named SalesData for a database named SalesDB.
Two dimensions named Region and Gender.
A role named Employee that has the Read permission set for the cube.
You need to modify the Employee role definition to allow the SalesData cube to be browsed only by using the Region dimension.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)