70-451 Exam Questions
147 real 70-451 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1
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...
- Question #2
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...
- Question #3
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...
- Question #4
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...
- Question #5
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...
- Question #6
You need to create a Service Broker solution. Which object should you create first?
- Question #7
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...
- Question #8
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...
- Question #9
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...
- Question #10
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...
- Question #11
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...
- Question #12
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...
- Question #13
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...
- Question #14
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...
- Question #15
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...
- Question #16
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...
- Question #17
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...
- Question #18
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...
- Question #19
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...
- Question #20
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...
- Question #21
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...
- Question #22
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...
- Question #23
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...
- Question #24
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...
- Question #25
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...
- Question #26
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...
- Question #27
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...
- Question #28
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...
- Question #29
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...
- Question #30
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...
- Question #31
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...
- Question #32
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...
- Question #33
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...
- Question #34
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,...
- Question #35
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...
- Question #36
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...
- Question #37
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...
- Question #38
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...
- Question #39
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...
- Question #40
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...
- Question #41
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...
- Question #42
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...
- Question #43
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...
- Question #44
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...
- Question #45
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...
- Question #46
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...
- Question #47
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...
- Question #48
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...
- Question #49
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...
- Question #50
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...