70-461 exam

You use Microsoft SQL Server 2012 to develop a database application. Your application sends data to an NVARCHAR (MAX) variable named @var. You need to write a Transact-SQL statement that will find out the success of a cast to a decimal (36, 9). Which code segment should you use?A ....

CORRECT TEXT You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You have an application named Appl. You have a parameter named @Count that uses the int data type. App1 is configured to pass @Count to a stored procedure. You need to create...

You develop a Microsoft SQL Server 2012 server database that supports an application. The application contains a table that has the following definition: CREATE TABLE Inventory (ItemID int NOT NULL PRIMARY KEY, ItemsInStore int NOT NULL, ItemsInWarehouse int NOT NULL) You need to create a computed column that returns the...

You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders. The tables are related by a column named CustomerID. You need to create a query that meets the following requirements: • Returns the CustomerName for all customers and the OrderDate for any orders that they...

CORRECT TEXT You have a database that contains the tables as shown in the exhibit. (Click the Exhibit button.) You have the following query: You need to recreate the query to meet the following requirements: • Reference columns by using one-part names only. • Sort aggregates by SalesTerritoryID, and then...

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 require fast access and will be retrieved frequently. What should...

You use a Microsoft SQL Server 2012 database that contains a table named BlogEntry that has the following columns: Id is the Primary Key. You need to append the "This is in a draft stage" string to the Summary column of the recent 10 entries based on the values in...

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 . ENCRYPTBYKEYB . ENCRYPTIONC . ENCRYPTBYPASSPHRASED . ENCRYPTBYCERTView AnswerAnswer: B Explanation: Reference: http://technet.microsoft.com/en-us/library/bb510663.aspx...

You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.) You need to display rows from the Orders table for the Customers row having the CustomerId value set to 1 in the following XML format. Which Transact-SQL query...

You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders. The tables are related by a column named CustomerID. You need to create a query that meets the following requirements: • Returns the CustomerName for all customers and the OrderDate for any orders that they...