Free Microsoft 70-464 Exam Dumps Questions & Answers

You execute the following code:

You need to select the task that has an IsFinished value of true from the Project that has an Id value of 1.
Which code segment should you use?

• A.  Option A
• B.  Option C
• C.  Option D
• D.  Option B

You plan to modify a stored procedure to use temporary data.
The stored procedure must meet the following requirements:
Favor physical memory when physical memory is available.
Be able to roll back changes to the temporary data.
You need to recommend which object to add to the stored procedure.
Which T-SQL command should you recommend?

• A.  CREATE TABLE ##Table...
• B.  DECLARE TABLE @ Table...
• C.  CREATE VIEW Table...
• D.  CREATE TABLE Table...
• E.  CREATE PARTITION SCHEME Table...

You need to implement a solution that addresses the page split issues.
Which statement should you execute?

• A.  ALTER INDEX IX_Orders_ShipDate ON Orders
  REBUILD WITH (PAD_INDEX=OFF, DROP_EXISTING = ON);
• B.  ALTER INDEX IX_Orders_ShipDate ON Orders
  REBUILD WITH (PAD_INDEX=ON, DROP_EXISTING = ON);
• C.  ALTER INDEX IX_Orders_ShipDate ON Orders
  REBUILD WITH (FILLFACTOR=50, DROP_EXISTING = ON);
• D.  ALTER INDEX IX_Orders_ShipDate ON Orders
  REBUILD WITH (FILLFACTOR = 0, DROP_EXISTING = ON);

You need to implement a change to usp_ExportOpenings that meets the integration requirements.
What should you modify in usp_ExportOpenings? (Each correct answer presents part of the solution. Choose all that apply?)

• A.  To line 10, add FOR XML RAW.
• B.  To the end of line 04, add [Opening].
• C.  To line 10, add FOR XMLEXPLICIT.
• D.  To the end of line 04, add [Opening!ELEMENT].
• E.  To the end of line 06, add [Opening!salary!ELEMENT].
• F.  To the end of line 05, add [Opening! title].
• G.  To the end of line 05, add [Opening!title!ELEMENT].
• H.  To the end of line 06, add [Opening! salary].
• I.  To line 10, add FOR XML AUTO.

You are testing disaster recovery procedures.
When you attempt to restore ProductsDB to another server, you receive the following error message: "Msg
33111, Level 16, State 3, Line 5
Cannot find server certificate with thumbprint ' 0x9D876A3468B911ElBA4CFCBF4724019B\ Msg 3013, Level 16, State 1, Line 5 RESTORE DATABASE is terminating abnormally." You need to ensure that you can restore ProductsDB to another server.
Which code segment should you execute on the other server?

• A.  Option A
• B.  Option C
• C.  Option D
• D.  Option B