How to pass Microsoft 70-464 Real Exam in 24 Hours [test questions 31-45]

100% Guarantee of 70-464 practice exam materials and preparation exams for Microsoft certification for examinee, Real Success Guaranteed with Updated 70-464 pdf dumps vce Materials. 100% PASS Developing Microsoft SQL Server 2012 Databases exam Today!

2016 Apr 70-464 Study Guide Questions:

Q31. Topic 8) 

You have two existing tables, one named COUNTRY and the other named STATES. The tables are defined as follows: 

You need to set up a rule that every STATE.Country_Abbr must match an existing record in the COUNTRY table. 

Develop the solution by selecting and arranging the required code blocks in the correct order. 

You may not need all of the code blocks. 

Answer: 


Q32. You need to implement a solution that meets the security requirements. Which statement should you execute? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: A 


Q33. You are testing disaster recovery procedures. 

You attempt to restore DB1 to a different server and you receive the following error message: "Msg 33111. Level 16, State 3, Line 1 Cannot find server certificate with thumbprint ,0xA694FBEA88C9354E5E2567C30A2A69E8FB4C44A9\ Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally." 

You need to ensure that you can restore DB1 to a different server. 

Which code segment should you execute? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: B 

6. You need to modify InsertInvoice to comply with the application requirements. Which code segment should you execute? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: D 


Q34. 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 that uses two-way encryption. 

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: 


Q35. You need to ensure that usp_AddXMLOrder can be used to validate the XML input from the retailers. 

Which parameters should you add to usp_AddXMLOrder on line 04 and line 05? (Each correct answer presents part of the solution. Choose all that apply.) 

A. @schema varbinary(100). 

B. @items varchar(max). 

C. @schema sysname. 

D. @items varbinary(max). 

E. @items xml. 

F. @schema xml. 

Answer: C,E 


70-464  practice exam

Update 70-464 free practice exam:

Q36. You need to provide referential integrity between the Sessions table and Speakers table. Which code segment should you add at line 47 of Tables.sql? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: B 

Explanation: 

http://msdn.microsoft.com/en-us/library/ms189049.aspx http://msdn.microsoft.com/en-us/library/ms179610.aspx http://msdn.microsoft.com/en-us/library/ff878370.aspx 


Q37. Topic 8) 

You create a disk-based table that contains the following script: 

You need to prevent duplicate values in the SKU field. 

Which five code segments should you use? 

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: 


Q38. Topic 8) 

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.) 

Answer: 


Q39. You use SQL Azure to store data used by an e-commerce application. 

You develop a stored procedure named sp1. Sp1 is used to read and change the price of all the products sold on the e-commerce site. 

You need to ensure that other transactions are blocked from updating product data while sp1 is executing. 

Which transaction isolation level should you use in sp1? 

A. Repeatable read 

B. Read committed 

C. Serializable 

D. Snapshot 

Answer: C 


Q40. Topic 7) 

You need to optimize the index and table structures for POSTransaction. 

Which task should you use with each maintenance step? To answer, drag the appropriate tasks to the correct maintenance steps. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. 

Answer: 


70-464  practice exam

Realistic 70-464 bundle:

Q41. Topic 8) 

You plan to deploy SQL Server 2012. You must create two tables named Table1 and Table2 that will have the following specifications: 

. Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of the time. . Table2 will contain a column named Column2 that is the product of two other columns in Table2. . Both Table1 and Table2 will contain more than 1 million rows. 

You need to recommend which options must be defined for the columns. The solution must minimize the storage requirements for the tables. Which options should you recommend? To answer, drag the appropriate options to the correct column in the answer area. 

Answer: 


Q42. The database contains a disk-based table named ContentTable that has 1 million rows and a column named Fax. Fax allows null values. 

You need to update Fax to meet the following requirements: 

. Prevent null values from being used. 

. Always use an empty string instead of a null value. 

Which statement or statements 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 

Answer: A,B,E 

Explanation: E: First change the NULLs to ' '. 

A: Then set the default to the column to ' '. 

B: Finally add the NOT NULL constraint to the column. 


Q43. Topic 7) 

You need to design the UserActivity table. 

Which three steps should you perform in sequence? To answer, move the appropriate three actions from the list of actions to the answer area and arrange them in the correct order. 

Answer: 


Q44. Topic 8) 

You have a SQL Server 2014 database. 

You plan to create a stored procedure that will retrieve the following information: 

. The XML content of the query plans that is stored in memory . The number of times each query plan is used 

You need to identify which dynamic management objects must be used to retrieve the required information for the stored procedure. 

Which dynamic management objects should you identify? 

To answer, drag the appropriate dynamic management object to the correct requirement in the answer area. 

Answer: 


Q45. Your network contains a server that has SQL Server 2014 installed. You create a table by using the following script: 

You need to recommend a solution to ensure that each combination of ProductName and ProductManufacturer is not duplicated. 

What should you recommend creating? 

A. A UNIQUE constraint 

B. A filtered index 

C. A columnstore index 

D. A CHECK constraint 

Answer: A 



see more 70-464 dumps