READ Free Dumps For Microsoft- 70-461
| Question ID 15102 | 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?
|
| Option A | Set the Merge agent on the problem subscribers to use the slow link agent profile.
|
| Option B | Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication.
|
| Option C | Change the Merge agent on the problem subscribers to run continuously.
|
| Option D | Set the Remote Connection Timeout on the Publisher to 0.
|
| Correct Answer | A |
Explanation
| Question ID 15103 | You have a database named Sales that contains the tables shown in the exhibit. (Click the
Exhibit button.)
You have an application named Appl. You have a parameter named @Count that uses the
int data type. App1 is configured to pass @Count to a stored procedure.
You need to create a stored procedure named usp_Customers for App1 that returns only
the number of rows specified by the @Count parameter.
The solution must NOT use BEGIN, END, or DECLARE statements.
Part of the correct Transact-SQL statement has been provided in the answer area.
Complete the Transact-SQL statement
|
| Option A | Answer : Please review the explanation part for this answer
|
| Correct Answer | A |
Explanation Explanation: CREATE PROCEDURE usp_Customers @Count int SELECT TOP(@Count) Customers.LastName FROM Customers ORDER BY Customers.LastName