Free Microsoft 070-464 Exam Dumps Questions & Answers

You need to design a solution that meets the refactoring requirements.
Which type of object should you include in the solution?

• A.An indexed view
• B.An aggregate function
• C.A table-valued function
• D.A distributed view

You need to resolve the performance issues of the usp_getOpenings stored procedure.
Which three actions should you perform? Each correct answer presents part of the solution.

• A.Replace lines 12, 13, and 14 with the Transact_SQL segment:
  WHERE (CONTAINS(o.Description, @keyword))
• B.Create a full text index on the Description column
• C.Replace lines 12, 13, and 14 with the Transact SQL Segment:
  WHERE (Contains(o.Description, 'FORMSOF(INFLECTIONAL, '+@keyword+')'))
• D.Replace lines 12, 13, and 14 with the Transact-SQL segment:
  WHERE (CONTAINS(o.Description, 'ISABOUT(' +@keyword+' weight (.5))'))
• E.Delete lines 05 through 08

Which data type should you use for ProductType?

• A.char(11)
• B.varchar(11)
• C.bigint
• D.nvarchar(11)

You need to implement a solution that meets the job application requirements.
What should you do?

• A.Add a UNIQUE constraint to the Applications table on the ApplicationID column and CandidateID column.
• B.Create a one-to-one relationship between the Candidates table and the Applications table.
• C.Create a one-to-one relationship between the Openings table and the Applications table.
• D.Add a UNIQUE constraint to the Applications table on the OpeningID column and the CandidateID column.

You need to modify usp_GetOrdersAndItems to ensure that an order is NOT retrieved by usp_GetOrdersAndItems while the order is being updated.
What should you add to usp_GetOrdersAndItems?

• A.Add SET TRANSACTION ISOLATION LEVEL SNAPSHOT to line 03.
• B.Add SET TRANSACTION ISOLATION LEVEL SERIALIZABLE to line 03.
• C.Add (UPDLOCK) to the end of line 06.
• D.Add (READPAST) to the end of line 06.