Home » New Updated Microsoft MCSE 70-464 Real Exam Questions and Answers Download 41-50

New Updated Microsoft MCSE 70-464 Real Exam Questions and Answers Download 41-50

Ensurepass

QUESTION 41

DRAG DROP

You have a database that contains three tables. The tables are configured as shown in the following table.

 

70-464-demo-44

 

You have the following query:

 

70-464-demo-45

 

The execution plan for the query is shown in the exhibit.

 

70-464-demo-46

 

You need to create one index to minimize the amount of time it takes to execute the query. What should you do?

 

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

 

Select and Place:

70-464-demo-47

 

Correct Answer:

70-464-demo-48

 

 

QUESTION 42

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.

Select and Place:

70-464-demo-49

 

Correct Answer:

70-464-demo-50

 

 

 

QUESTION 43

You have a table named Rooms that contains three columns. You execute the following query:

 

70-464-demo-51

 

You discover the execution plan shown in the exhibit.

 

70-464-demo-52

 

You need to recommend a solution to reduce the amount of time it takes to execute the query. What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

 

  1. Use the WITH (INDEX( Room_IX),NOLOCK) query hint.

  2. Create a clustered index for Id.

  3. Include the RoomName column and the Position column in the Room_IX index.

  4. Create a nonclustered index for RoomName, Id, and Position.

 

Correct Answer: D

 

 

QUESTION 44

You have a server that has SQL Server 2012 installed. You need to identify which parallel execution plans are running in serial. Which tool should you use?

 

  1. Data Profile Viewer

  2. Database Engine Tuning Advisor

  3. Performance Monitor

  4. Extended Events

 

Correct Answer: D

 

 

QUESTION 45

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:

 

  • 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.

 

  1. an Extended Events session

  2. a SQL Server Profiler template

  3. log errors by using trace flag 1204

  4. log errors by using trace flag 1222

 

Correct Answer: A

 

 

QUESTION 46

You have a SQL Server 2012 database named database1. Database1 contains a table named OrderDetails. For a given sales order, you need to retrieve the OrderID, Quantity, and LineTotal columns for all of the items in the OrderDetails table. The solution must ensure that the results can be joined to other tables. Which code segment should you execute?

 

70-464-demo-53

 

  1. Option A

  2. Option B

  3. Option C

  4. Option D

 

Correct Answer: A

 

 

QUESTION 47

DRAG DROP

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

 

  • SProc1must 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.)

 

Select and Place:

70-464-demo-54

 

Correct Answer:

70-464-demo-55

 

 

 

QUESTION 48

You have a database that contains a user-defined function named Schema1.Udf1 and two tables named Schema1.Table1 and Schemal.Table2. Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as shown in the following table.

 

70-464-demo-56

 

Schema1.Udf1 was defined by using the following code:

 

70-464-demo-57

 

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

 

  • Country

  • CountryID

  • CustomerName

 

The solution must meet the following requirements:

 

  • Rows must be returned only if the function returns data.

  • The amount of time it takes the query to execute must be minimized.

 

Which query should you use?

 

70-464-demo-58

 

  1. Option A

  2. Option B

  3. Option C

  4. Option D

 

Correct Answer: C

 

 

QUESTION 49

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.)

 

70-464-demo-59

 

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 ENCRYPTION

  2. WITH VIEW_METADATA

  3. WITH CHECK OPTION

  4. WITH SCHEMABINDING

 

Correct Answer: C

 

 

QUESTION 50

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. Define the view by using the SCHEMABINDING option.

  2. Define the view by using the CHECK option.

  3. Create an INSTEAD OF trigger on the view.

  4. Materialize the view.

 

Correct Answer: C

 

Instant Access to Download Latest Complete Collection of Microsoft MCSE 70-464 Real Exam

Try Microsoft MCSE 70-464 Free Demo

 

New Updated Microsoft MCSE 70-464 Real Exam Questions and Answers Download 51-60
New Updated Microsoft MCSE 70-464 Real Exam Questions and Answers Download 29-40

Name of author

Name: admin