70-464 Exam Questions - Online Test

70-464 Premium VCE File

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

It is impossible to pass Microsoft 70-464 exam without any help in the short term. Come to Ucertify soon and find the most advanced, correct and guaranteed Microsoft 70-464 practice questions. You will get a surprising result by our Leading Developing Microsoft SQL Server 2012 Databases practice guides.

Q51. You need to optimize the index structure that is used by the tables that support the fraud detection services. 

What should you do? 

A. Add a hashed nonclustered index to CreateDate. 

B. Add a not hash nonclustered index to CreateDate. 

C. Add a not hash clustered index on POSTransactionId and CreateDate. 

D. Add a hashed clustered index on POSTransactionId and CreateDate. 

Answer: A 

Explanation: The fraud detection service will need to meet the following requirement (among others): 

* Detect micropayments that are flagged with a StatusId value that is greater than 3 and that occurred within the last minute. 

Q52. You need to create a function that filters invoices by CustomerID. The SELECT statement for the function is contained in InvoicesByCustomer.sql. 

Which code segment should you use to complete the function? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: A 

Q53. Topic 8) 

You are planning two stored procedures named SProc1 and SProc2. 

You identify the following requirements: 

. SProc1 must return a table. 

. SProc2 must return a scalar value. You need to identify which option must be implemented for each stored procedure to return the desired data. 

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

Answer: 

Q54. Which code segment should you use to define the ProductDetails column? 

A. ProductDetails xml (DOCUMENT Production.ProductDetailsSchema) NULL 

B. ProductDetails xml NULL 

C. ProductDetails xml (CONTENT Production.ProductDetailsSchema) NULL 

D. ProductDetails varchar(MAX) NULL 

Answer: D 

Q55. Your company has a main office in London and a branch office in New York. 

Your network contains a server named Server5 that has SQL Server 2012 installed. Server5 contains a database name ContentDB and a table named ContentTable. 

You add an additional server named Server9 that runs SQL Server 2012. 

You need to create a distributed partitioned view. The solution must minimize the amount of network traffic. 

What should you do? (Each correct answer presents part of the solution. Choose all that apply.) 

A. Create the view on Server5. 

B. Add Server9 as a linked server. 

C. Create the view on Server9. 

D. Add the Customers table to Server9. 

E. Add Server9 as a Distributor. 

F. Remove the Customers table from Server5. 

Answer: A,B,C,D 

Q56. You have a SQL Azure database. 

You execute the following script: 

You add 1 million rows to Table1. Approximately 85 percent of all the rows have a null value for Column2. 

You plan to deploy an application that will search Column2. 

You need to create an index on Table1 to support the planned deployment. The solution must minimize the storage requirements. 

Which code segment should you execute? 

A. CREATE INDEX IX_Table1 ON Table1 (Column2) WITH FILLFACTOR-0 

B. CREATE INDEX IX_Table1 OK Table1 (Column1) INCLUDE (Column2) 

C. CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NULL 

D. CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NOT NULL 

Answer: D 

Explanation: 

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

Q57. 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: 

Q58. You have an index for a table in a SQL Azure database. The database is used for Online Transaction Processing (OLTP). 

You discover that many page splits occur when records are inserted or updated in the table. 

You need to minimize the number of page splits. 

What should you set from the index options? 

A. FILLFACTOR = 0 

B. STATISTICS_NORECOMPUTE = OFF 

C. STATISTICS_NORECOMPUTE = ON 

D. FILLFACTOR = 80 

Answer: D 

Explanation: 

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

Q59. You need to implement a solution that meets the locking requirements. Which line of code should you modify? 

A. Change line 07 in usp_UpdateOpening to: UPDATE Openings WITH (UPDLOCK) 

B. Change line 09 in usp_GetOpenings to: FROM Openings o (ROWLOCK) 

C. Change line 07 in usp_UpdateOpening to: UPDATE Openings WITH (READPAST) 

D. Change line 09 in usp_GetOpenings to: FROM Openings o (NOLOCK) 

Answer: D 

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