NO.1 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. 06
B. 05
C. 19
D. 04
Answer: C
70-464 test answers            70-532 Practice Questions   
Explanation:
http://msdn.microsoft.com/en-us/library/ms186755.aspx

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

NO.2 You execute usp_TestSpeakers.
You discover that usp_SelectSpeakersByName uses inefficient execution plans.
You need to update usp_SelectSpeakersByName to ensure that the most efficient
execution plan is used.
What should you add at line 30 of Procedures.sql?
A. OPTION (OPTIMIZE FOR UNKNOWN)
B. OPTION (FORCESCAN)
C. OPTION (FORCESEEK)
D. OPTION (OPTIMIZE FOR (@LastName= 'Anderson'))
Answer: A
70-464 test questions   70-464 Exam Dumps   
Explanation:

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

Microsoft 70-532 exam questions candidates all know the Microsoft 70-532 exam questions is not easy to pass. But it is also the only way to success, so they have to choose it. In order to improve the value of your career, you must pass this certification exam. The exam questions and answers designed by DumpKiller contain different targeted, and have wide coverage. There is no any other books or other information can transcend it. The question bprovided by DumpKiller definitely ace exam questions and answers that help you pass the exam. The results many people used prove that DumpKiller success rate of up to 100%. DumpKiller is the only way that suits you to pass the exam, choose it equal to create a better future.

70-464 Free Demo Download: http://www.dumpkiller.com/70-464_braindumps.html

This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.

We recommend that you review this exam preparation guide in its entirety and familiarize yourself with the resources on this website before you schedule your exam. See the Microsoft Certification exam overview for information about registration, videos of typical exam question formats, and other preparation resources. For information on exam policies and scoring, see the Microsoft Certification exam policies and FAQs.

Exam 70-464 Objectives:

Implement database objects (30-35%)
Implement programming objects (20-25%)
Design database objects (20-25%)
Optimize and troubleshoot queries (20-25%)