Quiz 70-451

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

Which two SQL Server components should you use?

You need to design the database to ensure normalization

Which SQL Server component should you use?

You need to ensure that the table meets the following requirements…?

You need to implement the business requirements to maintain data integrity

You need to ensure that when an item is removed from Table1, all related items are removed from Table1_Details

You need to provide a developer the ability to create and modify database diagrams from an existing database by using SQL Server Management Studio

You need to ensure that the reports will not affect query performance on the OLTP database

You need to optimize the performance of the application to meet the following requirement…

You need to design a data access layer to simplify the extraction process