Tag: Microsoft 70-464 Practice Test

Get Full Version of the Examhttp://www.EnsurePass.com/70-464.html Question No.107You create a table named Customers by using the following code segment:You create a non-clustered index named IX_Name on the name column.You write the following query to retrieve all of the customers that have a name that starts with the letters SMI:You discover that the query performs a table scan. You need to ensure that the query uses the index.What should you do?Replace LEFT(name,3) = #39;smi#39; by using name Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/70-464.html Question No.117You plan to modify a procedure that contains hundreds of lines of code. The modification must support the following guidelines:Use only tables that are not persistent in the database.Minimize the amount of time required to execute and recompile procedures.You need to identify which type of table must be used to support the planned modification. Which type of table should you identify?A system tableA partitioned tableA Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/70-464.html Question No.127You have database objects that were created by using the following script:The dbo.Customers table has 1 million rows.You discover that usp_GetCustomersByDate takes a long time to complete.The query plan used by the stored procedure is shown in the exhibit. (Click the Exhibit button.)You need to ensure that usp_GetCustomersByDate completes as quickly as possible. What should you do?Modify the stored procedure to include Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/70-464.html Question No.77DRAG DROPYou 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 named Column2 that uses one-way hashing. Which code segment should you execute before you remove Column1?To answer, move the appropriate code Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/70-464.html Question No.87You have a database named database1. Database developers report that there are many deadlocks. You need to implement a solution to monitor the deadlocks. The solution must meet the following requirements:Support real-time monitoring. Be enabled and disabled easily.Support querying of the monitored data. What should you implement?More than one answer choice may achieve the goal. Select the BEST answer.Log errors by Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/70-464.html Question No.97You have a database named Database1. Database1 has two stored procedures named Proc1 and Proc2 and a table named Table1. Table1 has millions of rows.Proc1 updates data in Table1. Proc2 reads data from Table1.You discover that when Proc1 is executed to update more than 4,000 rows, Proc2 is blocked. The block affects all rows, including those that are not being updated by Proc1.You need to ensure that when Proc1 is executing, Read more [...]