Free Download Microsoft 70-464 PDF Full Version Now (41-50)

QUESTION 41
You have a SQL Server 2012 database named DB1 that is accessed by 650 concurrent users.
You need to log all of the queries to DB1 that become deadlocked. The solution must minimize the impact on the server.
What should you create?

A.    A SQL Server Agent job that retrieves information from the sys.dm_tran_active_transactions dynamic
management views
B.    A script that enables trace flags
C.    A SQL Server Agent job that retrieves information from the sys.dm_tran_session_transactions dynamic
management views
D.    A SQL Server Profiler trace

Answer: B

QUESTION 42
You have a Microsoft SQL Azure database that contains a table named Employees.

image
You create a non-clustered index named EmployeeName on the name column.
You write the following query to retrieve all of the employees that have a name that starts with the letters JOH:

image
You discover that the query performs a table scan.
You need to ensure that the query uses EmployeeName.
What should you do?

A.    Recreate EmployeeName as a unique index
B.    Recreate EmployeeName as a clustered index
C.    Replace LEFT(name,3) = ‘JOH’ by using name like ‘JOH%’
D.    Replace LEFT(name,3) = ‘JOH’ by using substring(name, 1, 3) = ‘JOH’

Answer: C

QUESTION 43
You have a SQL Server 2012 environment that contains two servers. The servers are configured as shown in the following table.

image
After the failover is complete, a user receives the following error message when connecting to DB1 on Server2:
“Msg 916, Level 14, State 1, Line 1
The server principal “Account1” is not able to access the database “DB1″ under the current security context.”
You verify that there is a server login for Account1 on Server2.
You need to ensure that Account1 can connect to DB1.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

A.    Update the SID for Account1 on DB1.
B.    Add Account1 to the db_datareader role.
C.    Create a new database user on DB1.
D.    Implement Windows authentication.

Answer: B

QUESTION 44
Drag and Drop Question
You 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 that uses two-way encryption. Which code segment should you execute before you remove Column1? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

image
Answer:

image

QUESTION 45
Drag and Drop Question
You have a database named database1. Each table in database1 has one index per column. Users often report that creating items takes a long time. You need to perform the following maintenance tasks:
– Identify unused indexes.
– Identify indexes that need to be defragmented.
What should you use?
To answer, drag the appropriate function to the correct management task in the answer area. (Answer choices may be used once, more than once, or not at all.)

image
Answer:

image

QUESTION 46
You have a SQL Server 2012 instance. You plan to create an application that uses spatial data. You need to create an object that will support the representation of the surface area of all the oceans.
Which code segment should you use?

image

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: B

Case Study 1: Scenario 1 (Question 47 ~ Question 52)
Application Information
You have two servers named SQL1 and SQL2 that have SQL Server 2012 installed. You have an application that is used to schedule and manage conferences. Users report that the application has many errors and is very slow. You are updating the application to resolve the issues. You plan to create a new database on SQL1 to support the application. A junior database administrator has created all the scripts that will be used to create the database. The script that you plan to use to create the tables for the new database is shown in Tables.sql. The script that you plan to use to create the stored procedures for the new database is shown in StoredProcedures.sql. The script that you plan to use to create the indexes for the new database is shown in Indexes.sql. (Line numbers are included for reference only.)
A database named DB2 resides on SQL2. DB2 has a table named SpeakerAudit that will audit changes to a table named Speakers.
A stored procedure named usp_UpdateSpeakersName will be executed only by other stored procedures. The stored procedures executing usp_UpdateSpeakersName will always handle transactions.
A stored procedure named usp_SelectSpeakersByName will be used to retrieve the names of speakers. Usp_SelectSpeakersByName can read uncommitted data. A stored procedure named usp_GetFutureSessions will be used to retrieve sessions that will occur in the future.
Procedures.sql
Indexes.sql
Tables.sql

QUESTION 47
You need to recommend a solution to ensure that SQL1 supports the auditing requirements of usp_UpdateSpeakerName. What should you include in the recommendation?

A.    the Distributed Transaction Coordinator (DTC)
B.    transactional replication
C.    change data capture
D.    change tracking

Answer: A

QUESTION 48
You need to modify usp_SelectSpeakersByName to support server-side paging. The solution must minimize the amount of development effort required. What should you add to usp_SelectSpeakersByName?

A.    an OFFSET-FETCH clause
B.    a table variable
C.    the ROWNUMBER keyword
D.    a recursive common table expression

Answer: A
Explanation:
http://www.mssqltips.com/sqlservertip/2696/comparing-performance-for-different-sql- server-paging-methods/
http://msdn.microsoft.com/en-us/library/ms188385.aspx http://msdn.microsoft.com/en-us/library/ms180152.aspx http://msdn.microsoft.com/en-us/library/ms186243.aspx http://msdn.microsoft.com/en-us/library/ms186734.aspx http://www.sqlserver-training.com/how-to-use-offset-fetch-option-in-sql-server-order-by- clause/-
http://www.sqlservercentral.com/blogs/juggling_with_sql/2011/11/30/using-offset-and-fetch/

QUESTION 49
You are evaluating the table design. You need to recommend a change to Tables.sql that reduces the amount of time it takes for usp_AttendeesReport to execute. What should you add at line 14 of Tables.sql?

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: D
Explanation:
http://msdn.microsoft.com/en-us/library/ms188300.aspx http://msdn.microsoft.com/en-us/library/ms191250.aspx

QUESTION 50
You need to provide referential integrity between the Sessions table and Speakers table. Which code segment should you add at line 47 of Tables.sql?

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: B
Explanation:
http://msdn.microsoft.com/en-us/library/ms189049.aspx http://msdn.microsoft.com/en-us/library/ms179610.aspx http://msdn.microsoft.com/en-us/library/ff878370.aspx

If you want to pass Microsoft 70-464 successfully, donot missing to read latest lead2pass Microsoft 70-464 practice tests.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

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

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Up-to-Dated
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back