You are designing a table to store date and time information for an application. The
application will be used by users in Europe, Asia, and North America. You need to add a
column that stores the date and time information for all users. The column must contain
information that can be used to identify the users’ local time zone. What should you include
in the design?

You are a database developer. You plan to design a database solution by using SQL Server
2008. The database contains a table named SaverPlans that stores information about
savings plans. The table contains a column named MinBalance that stores the minimum
balance for a given plan. You need to ensure that each new savings plan, for which the
MinBalance value is unspecified, has a minimum balance of 1,000 U.S. dollars. You want to
achieve this goal by using the minimum amount of cost. What should you do?

You are a database developer. You plan to design a database solution by using SQL Server
2008. A database contains two tables named Orders and OrderDetails. There is also a data
warehouse containing a table named factSales. The factSales table has a de-normalized
structure and contains columns from Orders and OrderDetails. You plan to design a solution
that will extract all data modifications from Orders and OrderDetails and load them into
factSales. You have the following requirements: • The load operation is incremental and
runs daily. • The schema of the tables cannot be modified. • The history of each modification
is maintained for one month. You need to implement the solution by using the least amount

of coding and administrative effort. What should you do?

You are a database developer. You plan to design a database solution by using SQL Server
2008. The database will contain a table to stage data from an external source. The imported
data will contain a field named TransactionTime. The TransactionTime field will use the
hh:mm:ss.[m] format (such as 12:55:30.1). You need to select the appropriate data type for
the TransactionTime field. You want to achieve this goal by incurring minimum amount of
storage cost. Which data type should you use?

You are designing a table that will contain the columns in the following table. You need to
add a column that will display the sum of the Subtotal, TaxAmt, and FreightAmt columns.
The solution must minimize the amount of storage space required to store the table. What
should you create?

ou plan to deploy a new application. The application will perform the following operations: •
Create a new database • 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?