Learn with Microsoft : 070-464 training material for 100% pass

You have a table named Table1 that contains 1 million rows. Table1 contains a column named Column1 that stores sensitive information. Column1 uses the nvarchar (16) data type.
You have a certificate named Cert1.
You need to replace Column1 with a new encrypted column named Column2 that uses one-way hashing.
Which code segment should you execute before you remove Column1?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

You have a text file that contains an XML Schema Definition (XSD).
You have a table named Schema1.Table1.
You have a stored procedure named Schema1.Proc1 that accepts an XML parameter named Param1.
You need to store validated XML data in Schema1.Table1. The solution must ensure that only valid XML data is accepted by Param1.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A. Create an XML schema collection in the database from the text file.
• B. Declare Param1 var1 as type XML and associate the variable to the XML schema collection.
• C. use the modify method to insert the XML schema into each row of the XML column in Table1.
  Explanation/Reference:
  http://msdn.microsoft.com/en-us/library/bb510420.aspx
  http://msdn.microsoft.com/en-us/library/ms187856.aspx
  http://msdn.microsoft.com/en-us/library/ms176009.aspx
  http://msdn.microsoft.com/en-us/library/hh403385.aspx
  http://msdn.microsoft.com/en-us/library/ms184277.aspx
• D. Define an XML column in Table1 by using an XML schema collection.

You plan to migrate an instance of SQL Server 2008 to a new installation of SQL Server 2012.
You need to migrate alerts and e-mail notifications.
Which system stored procedures should you use? (Each correct answer presents part of the solution. Choose all that apply.)

• A. sp_syspolicy_create_job
• B. sp_audit_write
• C. sp_add_alert
  B: sp_add_operator
  Creates an operator (notification recipient) for use with alerts and jobs.
  C: sp_audit_write
  Adds a user-defined audit event to the USER_DEFINED_AUDIT_GROUP. If USER_DEFINED_AUDIT_GROUP is not enabled, sp_audit_write is ignored.
• D. sp_add_operator

You are designing two stored procedures named Procedure1 and Procedure2.
You identify the following requirements:
* Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored procedure.
* Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure.
Which technologies should you identify?
To answer, drag the appropriate technology to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)

You have a SQL Server 2012 database named Database1.
You execute the following code:

You insert 3 million rows into Sales.
You need to reduce the amount of time it takes to execute Proc1.
What should you do?

• A. Option B
• B. Option A
• C. Option D
• D. Option C