This page was exported from 100% Free Lead2pass Practice Test Download [ ] Export date:Mon Jun 24 9:55:52 2019 / +0000 GMT ___________________________________________________ Title: [2016-New] Latest Released Microsoft 70-464 Practice Exam Question Free Download From GreatExam (161-175) --------------------------------------------------- In recent years, many people choose to take Microsoft 70-464 certification exam which can make you get the Microsoft certificate and that is the passport to get a better job and get promotions. How to prepare for Microsoft 70-464 exam and get the certificate? Please refer to Microsoft 70-464 exam questions and answers on GreatExam. QUESTION 161Drag and Drop QuestionYou need to implement a new version of usp_AddMobileLocation.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: QUESTION 162You need to modify the usp_DetectSuspiciousActivity stored procedure.Which two actions should you perform? Each correct answer presents part of the solution.Choose two. A.    Option AB.    Option BC.    Option CD.    Option DE.    Option EF.    Option F Answer: DEExplanation:Note:- Move micropayments to dbo.POSException table by using a stored procedure named ups_DetectSuspiciousActivity. QUESTION 163Drag and Drop QuestionYou need to redesign the system to meet the scalability requirements of the application.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: QUESTION 164Drag and Drop QuestionYou 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: QUESTION 165You 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: AExplanation: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. QUESTION 166You need to modify the stored procedure usp_LookupConcurrentUsers.What should you do? A.    Use the summary table as an in-memory optimized table with a non-hash clustered index.B.    Use the summary table as an in-memory optimized table with a non-hash nonclustered index.C.    Use a type variable instead of the summary table.D.    Add a clustered index to the summary table. Answer: A QUESTION 167You need to identify which long running transactions use an index.Which dynamic management view should you use? A.    sys.dm_exec_query_optimizer_infoB.    sys.dm_exec_connectionsC.    sys.dm_exec_query_statsD.    sys.dm_exec_sessions Answer: B QUESTION 168You 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? A.    Replace LEFT(name,3) = 'smi' by using name like 'smi%'B.    Replace LEFT(name,3) = 'smi' by using substring(name,l,3) = 'smi'C.    Recreate IX_Name as a unique indexD.    Recreate IX Name as a clustered index Answer: A QUESTION 169You plan to create a new column in a table.The column must meet the following requirements:- Be able to store images that are larger than 1 MB each.- Be able to access the images from Microsoft .NET Framework applications.You need to recommend which data type must be used in the column.Which data type should you recommend? More than one answer choice may achieve the goal. Select the BEST answer. A.    nvarcharB.    varbinaryC.    imageD.    FileStream Answer: D QUESTION 170You 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.    A system tableB.    A partitioned tableC.    A table variableD.    A temporary table Answer: C QUESTION 171You have a SQL Server 2014 instance named SQLInstance1.Instance1 contains a database named Database1.You need to recommend an index defragmentation solution for an index named ContentIndex. ContentIndex must meet the following requirements:- Remain online during the defragmentation.- Update distribution statistics.- Perform defragmentation as quickly as possible.Which type of index defragmentation solution should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST answer. A.    DBCC DBREINDEXB.    REORGANIZEC.    REBUILDD.    DBCC INDEXDEFRAG Answer: B QUESTION 172Your 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. Serverscontains 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: ABCD QUESTION 173You have a SQL Server 2012 database named Database1.You execute the following code:You insert 3 million rows into Sales.You need to reduce the amount of time it takes to execute Proc1.What should you do? A.    Option AB.    Option BC.    Option CD.    Option D Answer: A QUESTION 174You 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? A.    Modify the stored procedure to include the OPTIMIZEFOR UNKNOWN query hint.B.    Execute the sp_recompile 'dbo.GetCustomersByDate' statement.C.    Execute the ALTER INDEXIX_Cust:omers_CreationDateWITH REBUILD statement.D.    Modify the stored procedure to include the OPTIMIZE FOR('1/1/2008') query hint. Answer: A QUESTION 175Drag and Drop QuestionYou create a table that contains the following script:You need to prevent duplicate values in the EmployeeID 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: GreatExam is a good website that provides all candidates with the latest IT certification exam materials. GreatExam will provide you with the exam questions and verified answers that reflect the actual exam. The Microsoft 70-464 exam dumps are developed by experienced IT professionals. 99.9% of hit rate. Guarantee you success in your 70-464 exam with our exam materials. --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2016-05-14 03:38:05 Post date GMT: 2016-05-14 03:38:05 Post modified date: 2016-05-14 03:38:05 Post modified date GMT: 2016-05-14 03:38:05 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from