Successfully Pass 70-464 Exam with the Help of Lead2pass New Microsoft 70-464 Study Guides (161-170)

You will pass your Microsoft 70-464 exam GUARANTEED using our accurate 70-464 practice questions and answers PDF&VCE dumps. Lead2pass exam dumps will help you not only pass in the first try, but also save your valuable time. Give your career a boost and start earning your Microsoft certification today!

QUESTION 161
You need to modify the usp_DetectSuspiciousActivity stored procedure.
Which two actions should you perform? Each correct answer presents part of the solution.
Choose two.

wps696D.tmp

A.    Option A
B.    Option B
C.    Option C
D.    Option D
E.    Option E
F.    Option F

Answer: DE
Explanation:
Note:
* Move micropayments to dbo.POSException table by using a stored procedure named ups_DetectSuspiciousActivity.

QUESTION 162
Drag and Drop Question
You 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.

wpsC5FF.tmp

Answer:

wpsF588.tmp

QUESTION 163
Drag and Drop Question
You 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.

wps4109.tmp

Answer:

wps6185.tmp

QUESTION 164
You need to modify the stored procedure usp_LookupConcurrentUsers.
What should you do?

A.    Add a clustered index to the summary table.
B.    Add a nonclustered index to the summary table.
C.    Add a clustered columnstore index to the summary table.
D.    Use a table variable instead of the summary table.

Answer: A
Explanation:
Scenario: Query the current open micropayments for users who own multiple micropayments by using a stored procedure named usp.LookupConcurrentUsers

QUESTION 165
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.

QUESTION 166
You 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 167
You need to identify which long running transactions use an index.
Which dynamic management view should you use?

A.    sys.dm_exec_query_optimizer_info
B.    sys.dm_exec_connections
C.    sys.dm_exec_query_stats
D.    sys.dm_exec_sessions

Answer: B

QUESTION 168
You create a table named Customers by using the following code segment:

wpsB6F5.tmp

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:

wpsFD1A.tmp

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 index
D.    Recreate IX Name as a clustered index

Answer: A

QUESTION 169
You 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.    nvarchar
B.    varbinary
C.    image
D.    FileStream

Answer: D

QUESTION 170
You 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 table
B.    A partitioned table
C.    A table variable
D.    A temporary table

Answer: C

Whether you are an IT professional or even a newbie, using Lead2pass Microsoft 70-464 exam questions is the best way to get the certification in a minimum possible time. Preparing for Microsoft 70-464 exams is a daunting task and equally rewarding. But for a person busy with day jobs, it is really a tough task to accomplish. Lead2pass Microsoft 70-464 training material uses latest exam questions to get your targets achieved in a hassle free way.

http://www.lead2pass.com/70-464.html