You have a SQL Server Integration Services (SSIS) package that contains an Execute Process task. You need to schedule the SSIS package to run on a regular basis. What should you do?

You are a database developer. You develop a task management application that connects to a SQL Server 2008 database named TaskDB. Users log on to the application by using a SQL Server login. The application contains a module named Task that assigns tasks to users. Information about these tasks is stored in the Tasks table of the TaskDB database. The Tasks table contains multiple columns. These include the CloseDate and EstimatedTime columns. Users assigned to a database role named User1 can update all task information columns except the CloseDate and the EstimatedTime columns in the Tasks table. Administrative users assigned to a database role named Task_Admin can update all task information in the Tasks table. You need to design a strategy to meet the security requirements. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are a database developer. You develop a database application for a SQL Server 2008 instance. The instance hosts a third-party database. You are not allowed to modify the database schema. The database contains two tables that are as shown in the following diagram.

You plan to extract address information about full-time employees based on the FullTimeIndicator flag. You need to design a data access layer to simplify the extraction process. What should you do?

You have a legacy application. You do not have access to the application source code. The application has a large denormalized table that contains 100 columns. The application uses stored procedures and views to perform all data manipulation language (DML) activities on the table. You need to optimize the performance of the application to meet the following requirement:
* Reduce I/O
* Minimize the storage requirements
* Optimize insert, update, and delete operations
What should you do?

You are designing a database for a reporting solution that is based on data from an Online Transaction Processing (OLTP) database. The reports will contain aggregated data. You need to ensure that the reports will not affect query performance on the OLTP database. The solution must minimize the use of joins when performing the aggregate calculations. What should you do?

You need to provide a developer the ability to create and modify database diagrams from an existing database by using SQL Server Management Studio. The solution must minimize the amount of permissions assigned to the developer. What should you do?

You have a database that contains two tables named Table1 and Table1_Details. Table1_Details contains details about items in Table1. You need to ensure that when an item is removed from Table1, all related items are removed from Table1_Details. You must achieve this goal by using the minimum amount of Transact-SQL code. What should you do?

You have a table in a database that contains 30 million rows. You need to ensure that the table meets the following requirements:
* Enables queries on all string values within the table
* Enables queries to be returned by order of proximity
* Minimizes the amount of time required to execute queries
What should you do?

You need to design a database solution that meets the following capabilities:
* Executes SQL Server Integration Services (SSIS) packages
* Executes Transact-SQL Schedules tasks
* Sends alerts
Which SQL Server component should you use?

You are a database solutions architect. Your company plans to develop a solution by using a SQL Server 2008 instance. The solution has the following business requirements: + Import data from various data sources such as Microsoft Office Excel, Microsoft SQL Server 2000, Microsoft SQL Server 2005, and CSV files.
+ Profile the source data before it is imported.
+ Provide collaboration and offline capabilities to mobile users.
+ Allow mobile users to use heterogeneous data stores.
You need to configure the appropriate SQL Server components to accomplish the business requirements. You want to achieve this goal by using the minimum amount of administrative effort. Which two SQL Server components should you use? (Each correct answer presents part of the solution. Choose two.)