70-433 Exam Questions

You administer a Microsoft SQL Server 2008 database named AdventureWorks that contains a table named Production.Product. The table contains a primary key named PK_Product_ProductID...

You administer a Microsoft SQL Server 2008 database named AdventureWorks that contains a table named Production.Product. The table contains a primary key named PK_Product_ProductID...

You are the database administrator for an order management system. The database has the following two schemas: The application contains a product table that has the following defin...

You are a database developer for your organization. You create an application that uses a Transact-SQL variable to store user input data. The database collation is case-insensitive...

You administer a Microsoft SQL Server 2008 database that contains tables named Sales.Customer and Sales.SalesOrder. A diagram of the tables is shown in the exhibit. (Click the Exhi...

You have a table named Subscribers. You receive an updated list of subscribers. You need to remove subscribers that are no longer on the list. Which clause should you use to remove...

A table named Shirts includes an XML column named SizeAndColors that contains the sizes and colors of each shirt, as shown in the following code segment. You need to return a list...

You are the database developer for a Microsoft SQL Server 2008 database that contains tables named order and product. The tables have the following definitions: You need to write a...

Your company uses an application that passes XML to the database server by using stored procedures. The database server has a large number of XML handles that are currently active....

You are a developer for a Microsoft SQL Server 2008 R2 database instance. You create tables named order, customer, and product as follows: You need to write a query to return all c...

You are a developer for a Microsoft SQL Server 2008 R2 database instance. You create tables named order, customer, and product as follows: You need to write a query to sum the sale...

You are a developer for a Microsoft SQL Server 2008 R2 database instance used to support a customer service application. You create tables named complaint, customer, and product as...

You are a database developer working on an application hosted on Microsoft SQL Server 2008 R2. The application regularly imports employee data from XML files. These files are bulk-...

You administer a Microsoft SQL Server 2008 database named AdventureWorks that contains a table named Production.Product. The table contains a primary key named PK_Product_ProductID...

You administer a Microsoft SQL Server 2008 database named AdventureWorks that contains a table named Production.Product. The table contains a primary key named PK_Product_ProductID...

You administer a Microsoft SQL Server 2008 R2 database that has a table named Customer. The table has the following definition: The database also has a table named CustomerExclusio...

You are a database developer writing reports for a sales management application. A customer table has the following definition: An order table has the following definition: You nee...

A table named Contacts includes a column named SmtpAddress. You must develop a report that returns e-mail addresses from the Contacts table that have the following format: at least...

You administer a Microsoft SQL Server 2008 database that contains a table named dbo.[order]. There are no triggers on the table. You plan to create a stored procedure that will hav...

You administer a SQL Server 2008 instance. The instance contains a database table named Sales.SalesOrderDetail. The table has the following definition: You need to enable row compr...

You create a stored procedure that contains proprietary formulas. You need to ensure that no users are able to access Microsoft SQL Server Management Studio to view the definition...

You need to identify which products will be inserted when you execute the following code block. Which products will be inserted?

You develop a new stored procedure for an existing database. You create two tables named Customer and Orders. The tables have the following definitions: Users are restricted from a...

You administer a Microsoft SQL Server 2008 database named AdventureWork that contains a table named Production.Product. The table has the following definition: You want to add a ne...

You administer a Microsoft SQL Server 2008 R2 database that has a table named Customer. The table has the following definition: The database also has a table named PreferredCustome...

You administer a Microsoft SQL Server 2008 R2 instance configured to use Windows Authentication. The database contains a table named CustomerTransaction that has the following defi...

You are updating a database table. You need to partition the table to store only the last 1000 rows of data in the table. What should you do?

You administer a Microsoft SQL Server 2008 database that contains a stored procedure named dbo.SalesOrderDetails. The stored procedure has following definition: Parameter values pa...

You are a developer for a Microsoft SQL Server 2008 R2 database instance used to support a customer service application. You create tables named complaint, customer, and product as...

You are a developer for a Microsoft SQL Server 2008 R2 database instance used to support a customer service application. You create tables named complaint, customer, and product as...

You are the database developer for an order-processing application. The database has the following tables: You need to ensure that the following requirements are met: Which Transac...

You administer a Microsoft SQL Server 2008 database named AdventureWorks that contains a table named Production.Product. The table contains a primary key named PK_Product_ProductID...

You administer a Microsoft SQL Server 2008 database. The database contains tables named Customer, Subscriptions, and Orders that have the following definitions: Customers are consi...

You are the administrator of a SQL Server 2008 instance with a database named DB1. which contains the following stored procedure. (Line numbers are useded for reference only.) 01 C...

You currently store date information in two columns. One column contains the date in local time and one column contains the difference between local time and UTC time. You need to...

You have two partitioned tables named Transaction and TransactionHistory. You need to archive one of the partitions of the Transaction table to the TransactionHistory table. Which...

You work as a network database administrator at ABC.com. ABC.com has a database server named ABC-DB01 that hosts the Sales database. The Sales database has a table named Shipping t...

You need to alter stored procedures to use the WITH RECOMPILE option. Which types of stored procedures should you alter? (Each correct answer represents a complete solution. Choose...

You need to create a column that allows you to create a unique constraint. Which two column definitions should you choose? (Each correct answer presents a complete solution. Choose...

You manage a SQL Server 2008 database that is located at your company's corporate headquarters. The database contains a table named dbo.Sales. You need to create different views of...

You work as a network database administrator at ABC.com. You need to implement error handling by using a TRY...CATCH block. How would you pass control to your CATCH block when an e...

Your database is 5GB and contains a table named SalesHistory. Sales information is frequently inserted and updated. You discover that excessive page splitting is occurring. You nee...

You administer a Microsoft SQL Server 2008 database that contains a stored procedure named dbo.SalesOrderDetails. The stored procedure has following definition: Parameter values pa...

You are working with a SQL Server 2008 instance that is configured to use the Icelandic_CS_AS collation. You create a database by using code that includes the following statements....

A table named Locations contains 5000 locations and the number of sales made at each location. You need to display the top 5 percent of locations by sales made. Which Transact-SQL...

You are the database developer for a customer service application. The database has the following table and view. You need to verify that the entire code is functional. Which Trans...

You are a database developer responsible for maintaining an application. The application has a table named Programs that has the following definition: You need to modify the Custom...

You administer a Microsoft SQL Server 2008 database that contains a table named Sales.SalesOrderDetail and a view named Sales.ProductOrders. The view has the following definition:...

You administer a Microsoft SQL Server 2008 database for an inventory management system. The application contains a product table that has the following definition: You want to add...

You administer a Microsoft SQL Server 2008 database for an inventory management system. The application contains a product table that has the following definition: You want to add...