70-464 Exam Questions - Online Test

70-464 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Your success in Microsoft 70-464 is our sole target and we develop all our 70-464 braindumps in a way that facilitates the attainment of this target. Not only is our 70-464 study material the best you can find, it is also the most detailed and the most updated. 70-464 Practice Exams for Microsoft MCSE 70-464 are written to the highest standards of technical accuracy.

Q31. Topic 8) 

Your network contains a server named Server1 that runs SQL Server 2012. Server1 contains an instance named Instance1. Instance1 contains a database named ContentDatabase. 

ContentDatabase uses transaction log backups. 

The recovery model of ContentDatabase is set to FULL. 

You need to shrink the ContentDatabase_Log log file to 10 MB. The solution must ensure that you can continue to back up the transaction log. 

Which three code segments should you execute? 

To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order. 

Answer: 

Q32. You have a database named Database1. Database1 has two stored procedures named Proc1 and Proc2 and a table named Table1. Table1 has millions of rows. 

Proc1 updates data in Table1. Proc2 reads data from Table1. 

You discover that when Proc1 is executed to update more than 4,000 rows, Proc2 is blocked. The block affects all rows, including those that are not being updated by Proc1. 

You need to ensure that when Proc1 is executing, Proc2 can access the data in Table1 that Proc1 is not updating. 

What should you change Proc1 to do? 

More than one answer choice may achieve the goal. Select the BEST answer. 

A. Update less than 4,000 rows simultaneously. 

B. Use the PAGLOCK table hint. 

C. Wait for Proc2 to complete. 

D. Use the ROWLOCK table hint. 

Answer: A 

Q33. Which data type should you use for CustomerID? 

A. varchar(11) 

B. bigint 

C. nvarchar(11) 

D. char(11) 

Answer: D 

Explanation: 

Invoices.xml All customer IDs are 11 digits. The first three digits of a customer ID represent the customer's country. The remaining eight digits are the customer's account number. int: -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) (just 10 digits max) bigint: -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) http://msdn.microsoft.com/en-us/library/ms176089.aspx http://msdn.microsoft.com/en-us/library/ms187745.aspx 

Q34. You need to modify the usp_DetectSuspiciousActivity stored procedure. 

Which two actions should you perform? Each correct answer presents part of the solution. Choose two. 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

E. Option E 

F. Option F 

Answer: D,E 

Explanation: 

Note: 

* Move micropayments to dbo.POSException table by using a stored procedure named ups_DetectSuspiciousActivity. 

Q35. You need to implement a solution that meets the data recovery requirements. You update each stored procedure to accept a parameter named @transactionID. What should you add next to the beginning of each stored procedure? 

A. SAVE TRANSACTION WITH MARK @transactionID 

B. ROLLBACK DISTRIBUTED TRANSACTION @transactionID 

C. BEGIN TRANSACTION WITH MARK @transactionID 

D. COMMIT TRANSACTION @transactionID 

Answer: C 

Q36. You need to modify the function in CountryFromID.sql to ensure that the country name is returned instead of the country ID. 

Which line of code should you modify in CountryFromID.sql? 

A. 04 

B. 05 

C. 06 

D. 19 

Answer: D 

Explanation: 

http://msdn.microsoft.com/en-us/library/ms186755.aspx http://msdn.microsoft.com/en-us/library/ms191320.aspx 

Q37. You need to prepare the database to use the .NET Framework ProcessProducts component. 

Which code segments should you execute? (Each correct answer presents part of the solution. Choose all that apply.) 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

E. Option E 

F. Option F 

G. Option G 

Answer: A,C,D,E 

Explanation: 

http://msdn.microsoft.com/en-us/library/ms131048.aspx http://msdn.microsoft.com/en-us/library/ms131052.aspx http://msdn.microsoft.com/en-us/library/ms189524.aspx http://msdn.microsoft.com/en-us/library/ms345106.aspx http://msdn.microsoft.com/en-us/library/ms131107.aspx 

Q38. You need to implement a solution that addresses the performance issues of the usp_GetOrdersByProduct stored procedure. 

Which statement should you execute? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: C 

Q39. 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 SUM(@RowNumber) < (SELECT @counter FROM @indextable) 

B. WHILE @counter < (SELECT COUNT(RowNumber) FROM @indextable) 

C. WHILE COUNT(@RowNumber) < (SELECT @counter FROM @indextable) 

D. WHILE @counter < (SELECT SUM(RowNumber) FROM @indextabie) 

Answer: B 

Q40. Topic 8) 

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. 

Answer: