70-451 Real Exam Questions

You are a database developer. You plan to design a database solution by using SQL Server 2008. A stored procedure uses the INSERT, UPDATE, and DELETE statements separately to load data into a table. You need to rewrite the stored procedure to use a single statement to load the data. 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 table named Claims. The structure of the Claims table is as shown in the following table. Only two percent of the claims are open at any point in time. You discover that queries on claims that have an Open status take a long time to execute. You need to optimize the performance of the claim-processing queries. What should you do?

You have a table named Sales that contains the data listed in the following table. You need design a query that retrieves a list that contains all sales people that have top three values from the TotalSales column. Which query should you design?

You are a database developer. You plan to design a database solution by using SQL Server 2008. Users report poor performance of a long-running query in a database. You fail to detect the cause of poor performance when you examine the estimated execution plan. On viewing the actual execution plan, you discover that several tasks are CPU-intensive. You need to ensure that you can view an estimated execution plan containing the most likely actions. You want to achieve this goal by incurring minimum possible CPU overhead. What should you do?

You have a database that has 20 tables. The tables are not configured to have any referential integrity. All tables have primary keys. Each table contains over 5 million rows. Ten percent of the rows contain outdated information. You need to design a maintenance process to delete all outdated rows. The solution must meet the following requirements: - Minimize execution time - Minimize development effort - Minimize blocking other processes - Prevent deletion failures from affecting the entire deletion process What should the design include?