Quiz 70-451

Quiz 70-451, PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

What should you do to design the table to optimize storage space?

What should you do to reduce the effect of this query on the server?

What should you do to achieve this goal by using the minimum amount of tables?

Which data type should you use to to ensure that each row in a table records the date and the time that the row was written?

Which data type should you use to to ensure that the database can store files that are 20 MB or less?

Which message type should you use?

Which object should you create first?

What should you recommend?

What should you do?

What should you do?