70-451 Exam Questions

You have a table that contains 5 million rows. The table has a clustered index. You plan to add an additional index on a column that contains 80 percent null values. The column is...

You have a table named Books that contains information about books. Books has the columns in the following table. You plan to create several queries that will filter on Title and I...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database supports a Web site and captures user interactions. These interactions a...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database supports a warehousing application and contains data from two warehouses...

You are a database developer. You plan to design a database solution by using SQL Server 2008. You plan to design a complex multi-statement stored procedure in the following manner...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain three tables. The structure of the three tables is as shown...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database contains a table that is stored as a heap. You perform page-level compre...

You are a database developer. You plan to design a database solution by using SQL Server 2008. Your company has a main office in New York and several branch offices globally. All t...

Your company is developing an application. The database platform for the application will be vendor-independent. You need to ensure that the application automatically stores the cu...

A database contains two tables named Table1 and Table1_Details. Table1_Details contains details about the items in Table1. You need to ensure that when an item is removed from Tabl...

You need to design a database solution that meets the following requirements: - Supports different types of databases - Provides reliable messaging between databases - Provides dat...

You have a table that contains 10 million rows. You need to design a query that returns a 100,000- row sample dataset. The solution must minimize the query's execution time. The sa...

You are a database developer. You design a database solution by using SQL Server 2008. Your company has offices in Europe, Asia, North America, and Africa. The company data is upda...

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains a stored procedure that is created by using the following DDL cod...

You need to recommend a solution that will enable two or more application sessions to share the same transaction and locks. The solution must enable the applications to work on the...

A new data analytics application is being implemented in your organization. Users will run a process that compares result sets before and after executing complex data modifications...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain a view. The view will contain a computed column that will b...

You are designing a table to store customer data. The table will contain a column to store the e-mail addresses of the customers. You need to recommend a solution to store the e-ma...

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

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain a table to stage data from an external source. The imported...

Your company has four offices. Each office contains a server that runs SQL Server 2008. All corporate data is stored in a central location. You need to create a reporting solution....

You have a server that runs SQL Server 2008 Enterprise. The server contains a 300-GB database. At the end of every month, several reports are generated from the database. Users rep...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain a table named Claims. The Claims table will contain a large...

You are designing a database that will be used for reporting purposes. The database stores data using spatial data type. You need to minimize the data storage requirements and impr...

You are a database solutions architect. Your company plans to develop a solution by using a SQL Server 2008 instance. The solution has the following business requirements: - Import...

You need to design a database solution that meets the following capabilities: - Executes SQL Server Integration Services (SSIS) packages - Executes Transact-SQL - Schedules tasks -...

You have a table in a database that contains 30 million rows. You need to ensure that the table meets the following requirements: - Enables queries on all string values within the...

You are a database developer. You plan to create a database by using SQL Server 2008. The database will store information about students, teachers, classes, and rooms in a school....

You are a database developer. You plan to design a database solution by using SQL Server 2008. You are creating a database to support the office manager. Your database model has th...

You have a database that contains two tables named Table1 and Table1_Details. Table1_Details contains details about items in Table1. You need to ensure that when an item is removed...

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

You are designing a database for a reporting solution that is based on data from an Online Transaction Processing (OLTP) database. The reports will contain aggregated data. You nee...

You have a legacy application. You do not have access to the application source code. The application has a large denormalized table that contains 100 columns. The application uses...

You have an instance of SQL Server 2008 that has xp_cmdshell enabled. You need to design a stored procedure that meets the following requirements: - Allows authorized users to retr...

You plan to create a database. The database will be used by a Microsoft .NET application for a special event that will last for two days. During the event, data must be highly avai...

You are creating a database that will store usernames and credit card numbers for an application. You need to recommend a solution to store and resuse the credit card numbers in th...

You are a database developer. You plan to design a database solution by using SQL Server 2008. You have a database that contains a table and a table-valued function. The table-valu...

You have a table that has 10 million rows. The table has a view that returns all of the rows. You discover performance degradation when you run an unfiltered view. You need to reco...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain a common language runtime (CLR) user-defined scalar functio...

You are a database developer. You plan to design a database solution by using SQL Server 2008. You configure a database on a server to use a common language runtime (CLR). You need...

You are a database developer. You develop solutions by using SQL Server 2008 in an enterprise environment. You plan to create a stored procedure that queries a sales table and prod...

You are a database developer. You provide solutions by using SQL Server 2008 in an enterprise environment. Your online transaction processing (OLTP) database contains a tabled name...

You need to configure a security solution for an application. The solution must meet the following requirements: - The application must have access to tables in a database - The ta...

You are a database developer. You create a database by using SQL Server 2008 in an enterprise environment. The database contains two stored procedures named ModifySales and Retriev...

You are designing a table to store date and time information for an application. The application will be used by users in Europe, Asia, and North America. You need to add a column...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database contains a table named SaverPlans that stores information about savings...

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains two tables named Orders and OrderDetails. There is also a data wa...

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain a table to stage data from an external source. The imported...

You are designing a table that will contain the columns in the following table. You need to add a column that will display the sum of the Subtotal, TaxAmt, and FreightAmt columns....

You plan to deploy a new application. The application will perform the following operations: - Create a new database - Back up the new database You need to configure a login to sup...