Microsoft 070-464 Value Pack (Frequently Bought Together)

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 C
• B. Option B
• C. Option A
• D. Option D

You are planning two stored procedures named SProc1 and SProc2. You identify the following requirements:
SProc1 must return a table.
SProc2 must return a status code.
You need to identify which options must be implemented to meet each stored procedure requirement.
Which options should you identify?
To answer, drag the appropriate option to the correct requirement in the answer area. (Answer choices may be used once, more than once, or not at all.)

You need to implement a solution that addresses the upload requirements.
Which code segment should you use to implement the Conversions assembly?

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

You execute IndexManagement.sql and you receive the following error message:
"Msg 512, Level 16, State 1, Line 12
Subquery returned more than 1 value. This is not permitted when the subquery follows =,! =, <, <= ,>, > = or when the subquery is used as an expression." You need to ensure that IndexManagement.sql executes properly.
Which WHILE statement should you use at line 18?

• A. WHILE @counter < (SELECT SUM(RowNumber) FROM @indextabie)
• B. WHILE SUM(@RowNumber) < (SELECT @counter FROM @indextable)
• C. WHILE COUNT(@RowNumber) < (SELECT @counter FROM @indextable)
• D. WHILE @counter < (SELECT COUNT(RowNumber) FROM @indextable)

An administrator provides a digital certificate named ServerCert.
You need to implement Transparent Data Encryption (TDE) on ProductsDB.
Which code segment should you use?

• A. USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256
  ENCRYPTION BY SERVER CERTIFICATE PRODUCTSCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO
• B. USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256
  ENCRYPTION BY SERVER CERTIFICATE DBCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO
• C. USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY
  ENCRYPTION BY SERVER CERTIFICATE DBCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO
• D. USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY
  ENCRYPTION BY SERVER CERTIFICATE PRODUCTSCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO