You are a database developer. You plan to design a database solution by using SQL Server 2008. A table in a database will store large image files (20-50 MB in size). You have the following business requirements:
* The image files are accessible by applications that use Win32 APIs.
* The image files are part of the database backup.
You need to identify an appropriate strategy to store the image files. Which strategy should you use?

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will store multilingual data. The database will contain a table that has 100 million rows. The table will contain 1,000 columns that are based on the nvarchar(max) data type. For each column, only 2 percent of the rows will be populated. You need to design the table to optimize storage space. What should you do?

You are a database developer.You plan to design a database solution by using SQL Server 2008. The database contains a large table that is infrequently updated. Users execute a query against the table. The query requires the execution of a complex calculation that involves multiple columns for a given row. You discover that the query performance is poor because the query is CPU intensive. You need to reduce the effect of this query on the server. What should you do?

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?