Question 6 of 294
You administer several Microsoft SQL Server 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?
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?
Correct Answer: A
Question 7 of 294
DRAG DROP -
You administer two Microsoft SQL Server 2012 servers named ServerA and ServerB. You use a database named AdventureWorks.
You need to prepare the AdventureWorks database for database mirroring. ServerB will act as the mirror in a mirroring partnership along with ServerA.
Which three actions should you perform in sequence? (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:
You administer two Microsoft SQL Server 2012 servers named ServerA and ServerB. You use a database named AdventureWorks.
You need to prepare the AdventureWorks database for database mirroring. ServerB will act as the mirror in a mirroring partnership along with ServerA.
Which three actions should you perform in sequence? (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:
Correct Answer:
Reference:
http://msdn.microsoft.com/en-us/library/ms189852.aspx
http://msdn.microsoft.com/en-us/library/ms190941.aspx
http://msdn.microsoft.com/en-us/library/ms189852.aspx
http://msdn.microsoft.com/en-us/library/ms190941.aspx
Question 8 of 294
You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA.
Currently, Server01/HA is the primary replica.
You need to ensure that the following requirements are met:
✑ Backup operations occur on Server02/HA.
✑ If Server02/HA is unavailable, backup operations occur on Server03/HA.
✑ Backup operations do not occur on Server01/HA.
How should you configure HaContoso?
Currently, Server01/HA is the primary replica.
You need to ensure that the following requirements are met:
✑ Backup operations occur on Server02/HA.
✑ If Server02/HA is unavailable, backup operations occur on Server03/HA.
✑ Backup operations do not occur on Server01/HA.
How should you configure HaContoso?
Correct Answer: B
Question 9 of 294
You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured.
When SQL Server Agent jobs fail, the error messages returned by the job steps are truncated.
The following error message is an example of the truncated error message:
"Executed as user CONTOSO\ServiceAccount....0.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2011. All rights reserveD. Started 63513 PM Error 2012-06-23 183536.87 Code 0XC001000E Source UserImport Description Code 0x00000000
Source Log Import Activity Descript... The package execution fA. .. The step failed. "
You need to ensure that all the details of the job step failures are retained for SQL Server Agent jobs.
What should you do?
When SQL Server Agent jobs fail, the error messages returned by the job steps are truncated.
The following error message is an example of the truncated error message:
"Executed as user CONTOSO\ServiceAccount....0.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2011. All rights reserveD. Started 63513 PM Error 2012-06-23 183536.87 Code 0XC001000E Source UserImport Description Code 0x00000000
Source Log Import Activity Descript... The package execution fA. .. The step failed. "
You need to ensure that all the details of the job step failures are retained for SQL Server Agent jobs.
What should you do?
Correct Answer: D
To ensure that all details of job step failures are retained for SQL Server Agent jobs, configuring output files is the best option. This approach allows each step in the SQL Server Agent jobs to write its output to a specified file, thereby capturing full error messages without truncation. It provides a straightforward way to keep comprehensive logs for review whenever there is a job failure.
Question 10 of 294
DRAG DROP -
You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server
2012 instance named SQL2012.
The development team develops a new application that uses the SQL Server 2012 functionality. You are planning to migrate a database from SQL2005 to
SQL2012 so that the development team can test their new application.
You need to migrate the database without affecting the production environment.
Which three actions should you perform in sequence? (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:
You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server
2012 instance named SQL2012.
The development team develops a new application that uses the SQL Server 2012 functionality. You are planning to migrate a database from SQL2005 to
SQL2012 so that the development team can test their new application.
You need to migrate the database without affecting the production environment.
Which three actions should you perform in sequence? (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:
Correct Answer:
Reference:
http://msdn.microsoft.com/en-us/library/ms177429.aspx
http://msdn.microsoft.com/en-us/library/ms177429.aspx