You need to create an application that will represent the relationship between managers and employees. You must achieve this goal by using the minimum amount of tables. What should you do?

You are designing a data storage solution for a transactional application. You need to ensure that each row in a table records the date and the time that the row was written. The time must be as precise as possible. Which data type should you use?

You are designing a database table for a content management system. Users will store images and videos in the database. You need to ensure that the database can store files that are 20 MB or less. The solution must minimize the amount of space required to store the data. Which data type should you use?

You plan to create a Service Broker solution. The solution will transport data from one queue to another queue. You need to identify which message type must be used to transport binary data. The solution must minimize the amount of data transported. Which message type should you use?

You need to create a Service Broker solution. Which object should you create first?

You are designing a maintenance strategy for a database that contains several views. The views will be assigned custom permissions. You need to recommend a solution that will allow developers to modify the views without affecting the view’s existing permissions. What should you recommend?

You plan to deploy a new application. The application will perform the following operations:
* Create a new database
* Add new logins
* Back up the new database
You need to configure a login to support the deployment of the new application. The solution must ensure that the application uses the most restrictive permissions possible. What should you do?

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?