You are a database developer. You plan to design a database solution by using SQL Server 2008. You have a database that contains a table and a table-valued function. The table-valued function accepts the primary key from the table as a parameter. You plan to write a query that joins the table to the results of the table-valued function. You need to ensure that only rows from the table that produce a result set from the table-valued function are returned. Which join predicate should you use?

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a view that has the following features:
* It contains a WHERE clause that filters specific records.
* It allows data updates.
You need to prevent data modifications that do not conform to the WHERE clause. You want to achieve this goal by using minimum effort. What should you do?

You have an instance of SQL Server 2008 that has xp_cmdshell enabled. You need to design a stored procedure that meets the following requirements:
* Allows authorized users to retrieve lists of files
* Minimizes permissions assigned to objects
* Minimizes security risks
What should you include in the design?

You are a database developer. You plan to design a database solution by using SQL Server 2008. There are two schemas named Sales and Marketing. You are the owner of the Sales schema and the Marketing schema is owned by a user named MarketingUser. Users of the Marketing schema do not have permissions to access the Sales schema. You have permissions to create objects in all schemas in the database. The Sales schema has a table named Customers.You plan to create a stored procedure in the Marketing schema for the marketing team. The stored procedure will select data from the Customers table and will be owned by MarketingUser. You need to ensure that the marketing team is able to execute the stored procedure. What should you do?

You are designing a database that will store telephone numbers. You need to ensure that only phone numbers that use a specific format are written to the database. What should you create?

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database contains two tables named Supplier and Product. There is a foreign key constraint between the Supplier and Product tables on the SupplierID column. The Supplier table contains a row that has the SupplierID value as 0. The 0 value indicates that the supplier is deleted. Certain transactions delete the supplier records from the Supplier table. You need to ensure that if a supplier is deleted, the SupplierID value in the Product table is set to 0. What should you do?

You are designing a document repository application that will contain over 100,000 documents. The repository will have the following specifications:
* Documents can be associated to 30 different properties
* Most documents will have less than 10 properties defined
You need to design a single table for the application. The solution must use the minimum the amount of storage space. What should you include in the design?

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?