70-457 무료 덤프문제 온라인 액세스

You administer a Microsoft SQL Server 2012 database. The database has a table named Customers owned by UserA and another table named Orders owned by UserB. You also have a stored procedure named GetCustomerOrderInfo owned by UserB. GetCustomerOrderInfo selects data from both tables.
You create a new user named UserC. You need to ensure that UserC can call the GetCustomerOrderInfo stored procedure. You also need to assign only the minimum required permissions to UserC. Which permission or permissions should you assign to UserC? Choose all that apply.

• A.The Execute permission on GetCustomerOrderInfo
• B.The Take Ownership permission on Orders
• C.The Select permission on Orders
• D.The Control permission on GetCustomerOrderInfo
• E.The Select permission on Customers
• F.The Take Ownership permission on Customers

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01. What should you create?

• A.a Server Audit Specification
• B.an Alert
• C.a SQL Profiler Trace
• D.a Resource Pool
• E.a Database Audit Specification
• F.an Extended Event session
• G.a Policy

You administer a Microsoft SQL Server 2012 instance. You need to stop a blocking process that has an SPID of 64 without stopping other processes. What should you do?

• A.Execute the following Transact-SQL statement:
  ALTER SESSION KILL '64'
• B.Execute the following Transact-SQL statement:
  KILL 64
• C.Restart the SQL Server service.
• D.Execute the following Transact-SQL statement:
  EXECUTE sp_KillSPID 64

You administer several Microsoft SQL Server 2012 database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). Many of the tables involved in replication use the XML and varchar(max) data types. Occasionally, merge replication fails due to timeout errors. You need to reduce the occurrence of these timeout errors. What should you do?

• A.Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication.
• B.Set the Merge agent on the problem subscribers to use the slow link agent profile.
• C.Change the Merge agent on the problem subscribers to run continuously.
• D.Set the Remote Connection Timeout on the Publisher to 0.

You want to add a new GUID column named BookGUID to a table named dbo.Book that already contains data. BookGUID will have a constraint to ensure that it always has a value when new rows are inserted into dbo.Book. You need to ensure that the new column is assigned a GUID for existing rows. Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)
Build List and Reorder:

정답:

Explanation:
--Burgos - NO
Verified answer as correct. Actually, in the real world, you don't have to use WITH VALUES at the end of the statement and it works just as well. But because the question specifically states which FOUR TSQL statements to use, we have to include it.
Reference: http://msdn.microsoft.com/en-us/library/ms190273.aspx