Quiz 70-451, PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Which two SQL Server components should you use?
Which SQL Server component should you use?
You need to ensure that the table meets the following requirements…?
You need to design the database to ensure normalization
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 design a data access layer to simplify the extraction process
You need to optimize the performance of the application to meet the following requirement…