70-451 Exam Questions

You are a database developer. You develop a database application for a SQL Server 2008 instance. The instance hosts a third-party database. You are not allowed to modify the databa...

You are a database developer. You develop a task management application that connects to a SQL Server 2008 database named TaskDB. Users log on to the application by using a SQL Ser...

You have a SQL Server Integration Services (SSIS) package that contains an Execute Process task. You need to schedule the SSIS package to run on a regular basis. What should you do...

You plan to deploy a new application. The application will perform the following operations: - Create a new database - Add new logins - Back up the new database You need to configu...

You are designing a maintenance strategy for a database that contains several views. The views will be assigned custom permissions. You need to recommend a solution that will allow...

You need to create a Service Broker solution. Which object should you create first?

You plan to create a Service Broker solution. The solution will transport data from one queue to another queue. You need to identify which message type must be used to transport bi...

You are a database developer. You plan to design a database solution by using SQL Server 2008. You have a Web site supported by a database that has the full-text search component i...

You are a database solutions architect. Your company plans to develop a solution by using a SQL Server 2008 instance. You design a new database that contains a table to store Micro...

You are a database developer. You plan to design a database solution by using SQL Server 2008. You create a table that contains information about Web pages that are added to a Web...

You are using Microsoft SQL Server 2008 Enterprise Edition. You need to maintain a history of all data modifications made to a table, including the type of modification and the val...

You are designing a database table for a content management system. Users will store images and videos in the database. You need to ensure that the database can store files that ar...

You are troubleshooting query performance on SQL Server 2008. You are tasked to capture a graphical execution plan. You need to save the plan to a file that can be used by SQL Serv...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database contains a large table that is infrequently updated. Users execute a que...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will store multilingual data. The database will contain a table that has...

You are a database developer. You plan to design a database solution by using SQL Server 2008. A table in a database will store large image files (20-50 MB in size). You have the f...

You are designing a document repository application that will contain over 100,000 documents. The repository will have the following specifications: - Documents can be associated t...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database contains two tables named Supplier and Product. There is a foreign key c...

You are a database developer. You create a database that uses SQL Server 2008 in an enterprise environment. You plan to import data from an external source into a table. You need t...

You are a database developer for a retail application. You create a database by using SQL Server 2008 in a distributed enterprise environment that has multiple servers. The same da...

You are designing a database that will store telephone numbers. You need to ensure that only phone numbers that use a specific format are written to the database. What should you c...

You are a database developer. You plan to design a database solution by using SQL Server 2008. You create a stored procedure that uses the TRY/CATCH syntax in a new database. When...

You are a database developer. You plan to design a database solution by using SQL Server 2008. There are two schemas named Sales and Marketing. You are the owner of the Sales schem...

You are a database developer. You plan to create a database by using SQL Server 2008. A database contains a table named Sales. The Sales table contains customer order summary infor...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database contains a table named Products. The database has two stored procedures...

You have a stored procedure that is used to set up maintenance tasks. The stored procedure executes every night. The stored procedure contains three critical data manipulation lang...

You are a database developer. You develop solutions by using SQL Server 2008 in an enterprise environment. An application contains two stored procedures. The tasks performed by the...

You are a database developer. You develop solutions by using SQL Server 2008 in an enterprise environment. You are creating a SQL Agent job that uses Transact-SQL to update data in...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain a table that will store customer data as XML data. The data...

You are designing a database that contains a data definition language (DDL) trigger. The DDL trigger will provide the maximum amount of data available when any attempt is made to c...

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table named Employee_Vacation. You are given an updated list of...

Your company has the following development policy for XML data: - The data must be element-centric - The data must be well-formed XML - The data must have a root element - The data...

You have a table that has five varchar columns. You are designing an application that requires data in well-formed XML. You need to design a query statement that will produce the d...

You plan to implement a Web-based application that will save XML data to a column in a table. You need to design a query that ensures that before saving the XML data to the table,...

You have a table that has an XML column named XMLOrderHeader. You need to design a stored procedure that extracts the order header values and stores them in a table. The solution m...

You need to design a method for storing large XML-formatted data. The design must meet the following requirements: - Minimize the page I/O - Minimize the response time for data man...

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...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database includes a table that contains the following product inventory informati...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain a table that has a parent-child relationship to itself. Eac...

You have a table named Table1. A sample of the data in Table1 is shown in the following table. There is a defined nonclustered index on the SalesOrderNumber column. The following q...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database has a table named Sales. The Sales table contains 10 million rows. You d...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database application has a table named Transactions that contains millions of row...

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table named Person. The structure of the table is as shown in t...

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database will contain 10 tables that are used to generate reports. Data in the tabl...

You are a database developer. You plan to design a database solution by using SQL Server 2008. Account managers in your company store order data in a database. Your company require...

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a table named Policies. The table contains information about 100...

Users frequently update millions of rows in a table at a time. Users report that it takes a long time to update the rows. You need to recommend a solution to reduce the time it tak...

You have a stored procedure that uses a cursor. The stored procedure updates several related tables. You discover that the stored procedure runs slowly and uses a significant amoun...

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 s...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain information on retail sales transactions of more than 500 s...