[Free] 2019(Nov) EnsurePass Microsoft 70-464 Dumps with VCE and PDF 11-20

Get Full Version of the Exam
http://www.EnsurePass.com/70-464.html

Question No.87

You 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:

image

image

Support real-time monitoring. Be enabled and disabled easily.

image

Support querying of the monitored data. What should you implement?

More than one answer choice may achieve the goal. Select the BEST answer.

  1. Log errors by using trace flag 1222

  2. Log errors by using trace flag 1204

  3. A SQL Server Profiler template

  4. An Extended Events session

Correct Answer: D

Explanation:

http://www.sqlservercentral.com/blogs/james-sql-footprint/2012/08/12/monitor-deadlock-in- sql- 2012/

http://blogs.technet.com/b/mspfe/archive/2012/06/28/how_2d00_to_2d00_monitor_2d00_d eadlocks_2d00_in_2d00_sql_2d00_server.aspx

Question No.88

You execute the following code:

image

The execution plan for the query is shown in the exhibit. (Click the Exhibit button.)

image

You need to prevent the key lookup. What should you modify?

More than one answer choice may achieve the goal. Select the BEST answer.

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: C

Question No.89

DRAG DROP

You have a table named Table1. Table1 has 1 million rows. Table1 has a columnstore index for a column named Column1. You need to import data to Table1. The solution must minimize the amount of time it takes to import the data. What should you do?

To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

image

Correct Answer:

image

Question No.90

You have a database for a mission-critical web application. The database is stored on a SQL Server 2012 instance and is the only database on the instance. The application generates all T- SQL statements dynamically and does not use stored procedures. You need to maximize the amount of memory available for data caching. Which advanced server option should you modify?

  1. Optimize for Ad hoc Workloads

  2. Enable Contained Databases

  3. Allow Triggers to Fire Others

  4. Scan for Startup Procs

Correct Answer: A

Question No.91

DRAG DROP (Topic 8)

You are designing two stored procedures named Procedure1 and Procedure2. You identify the following requirements:

image

Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored procedure.

image

Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly. You need to identify the appropriate technology for each stored procedure.

Which technologies should you identify?

To answer, drag the appropriate technology to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)

image

Correct Answer:

image

Question No.92

You have an application that uses a view to access data from multiple tables. You need to ensure that you can insert rows into the underlying tables by using the view. What should you do?

  1. Create an INSTEAD OF trigger on the view.

  2. Define the view by using the SCHEMABINDING option.

  3. Define the view by using the CHECK option.

  4. Materialize the view.

Correct Answer: C

Explanation:

http://msdn.microsoft.com/en-us/library/ms180800.aspx http://msdn.microsoft.com/en- us/library/ms187956.aspx

Question No.93

You have a database that contains a user-defined function named Schema1.Udf1 and two tables named Schema1.Table1 and Schema1.Table2.

Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as shown in the following table.

image

Schema1.Udf1 was defined by using the following code:

image

You need to write a query that will contain the following columns:

image

image

image

Country CountryID CustomerName

The solution must meet the following requirements:

image

Rows must be returned only if the function returns data.

image

The amount of time it takes the query to execute must be minimized. Which query should you use?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: B

Question No.94

You have a database hosted on SQL Azure. You are developing a script to create a view that will be used to update the data in a table. The following is the relevant portion of the script. (Line numbers are included for reference only.)

image

You need to ensure that the view can update the data in the table, except for the data in Column1. Which code segment should you add at line 06?

  1. WITH CHECK OPTION

  2. WITH VIEW_METADATA

  3. WITH ENCRYPTION

  4. WITH SCHEMABINDING

Correct Answer: A

Explanation:

The question concerning the view that has a clause quot;WHERE Column1 = #39;City1#39; is wrong. That#39;s not what the CHECK option is made for. Actually you will be able to update ONLY the rows satisfied by that WHERE clause, that is, only the rows with the Column1 being #39;City1#39;.

You need a trigger to achieve that. http://msdn.microsoft.com/en-us/library/ms187956.aspx

Question No.95

DRAG DROP

You are planning two stored procedures named SProc1 and SProc2. You identify the following requirements:

image

image

SProc1 must return a table. SProc2 must return a status code.

You need to identify which options must be implemented to meet each stored procedure requirement. Which options should you identify?

To answer, drag the appropriate option to the correct requirement in the answer area. (Answer choices may be used once, more than once, or not at all.)

image

Correct Answer:

image

Question No.96

You have a Microsoft SQL Azure database. You have the following stored procedure:

image

You discover that the stored procedure periodically fails to update HR.Employees.

You need to ensure that HR.Employees is always updated when up_employees executes.

The solution must minimize the amount of time required for the stored procedure to execute and the number of locks held.

What should you do?

  1. Add the following line of code to line 05:

    SET TRANSACTION ISOLATION LEVEL SNAPSHOT

  2. Add the following line of code to line 13: WITH (UPDLOCK)

  3. Add the following line of code to line 05:

    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

  4. Add the following line of code to line 08: WITH (UPDLOCK)

Correct Answer: D

Get Full Version of the Exam
70-464 Dumps
70-464 VCE and PDF

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.