What should you do?
You develop a database for a travel application. You need to design tables and other database objects. You need to store media files in several tables. Each media file is less than 1 MB in size. The media files will…
70-461 v.2
Which Transact-SQL statement or statements should you use?
You develop a Microsoft SQL Server 2012 database. You need to create and call a stored procedure that meets the following requirements: • Accepts a single input parameter for CustomerID. • Returns a single integer to the calling application. Which…
Which table hint should you use?
You develop a Microsoft SQL Server 2012 database that contains a heap named OrdersHistorical. You write the following Transact-SQL query: • INSERT INTO OrdersHistorical • SELECT * FROM CompletedOrders You need to optimize transaction logging and locking for the statement.…
What should you do?
You use a Microsoft SQL Server 2012 database that contains two tables named SalesOrderHeader and SalesOrderDetail. The indexes on the tables are as shown in the exhibit. (Click the Exhibit button.) You write the following Transact-SQL query: You discover that…
Which Transact-SQL statement should you use?
You use a Microsoft SQL Server 2012 database. You want to create a table to store Microsoft Word documents. You need to ensure that the documents must only be accessible via Transact-SQL queries. Which Transact-SQL statement should you use? A.…
Which Transact-SQL batch should you use?
You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline. Which…
What should you create for each application?
You develop a Microsoft SQL Server 2012 database. The database is used by two web applications that access a table named Products. You want to create an object that will prevent the applications from accessing the table directly while still…
Which object should you use?
You develop a Microsoft SQL Server 2012 database. You need to create a batch process that meets the following requirements: • Returns a result set based on supplied parameters. • Enables the returned result set to perform a join with…
Which query should you use?
Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both tables contain more than 100 million rows. Each table has a Primary Key column named SalesOrderId. The data in the two tables is distinct from one another. Business users want…
Which stored procedure option should you use?
You are a database developer at an independent software vendor. You create stored procedures that contain proprietary code. You need to protect the code from being viewed by your customers. Which stored procedure option should you use? A. ENCRYPTBYKEY B.…