Automated testing cannot replace manual testing because of following reason:

- Automated testing cannot replace the analytical skills required to conduct testing. It can only enhance or supplement manual testing,

- Through manual testing, information can be gathered about the application, and real-time decisions can be made about how to enhance a test that would be too difficult to program into an automated script.

- We need a manual tester to analyze and maintain the automated scripts after they can run.

The main attributes are discussed below:

Maintainability: For each new release need to update the test automation suites.

Reliability: Accuracy and repeatability of the test automation.

Flexibility: Ease of working with all the different kinds of automation test ware. 

Efficiency: Total cost related to the effort needed for the automation.

Portability: Ability of the automated test to run on different environments.

Robustness: Effectiveness of automation on an unstable or rapidly changing system. 

Usability: Extent to which automation can be used by different types of user.

The Data Source attribute of the connection string contains the name, instance or network address of the instance of SQL Server to which to connect. In this scenario we are to connect to the Factory Instance on XYZ01 so we use XYZ01\Factory as data source. To specify the database we should either use the Database or the Initial Catalog attribute. Here we use Database=FactoryDB.

Incorrect Answers:

A, B: There is no Server attribute in the connection string. Instead we should use the Data Source attribute to specify the server and the instance.

C: There is no Initial Category attribute in the connection string. We can use Database or the Initial Catalog attribute to specify the database.

The biggest concern is the cost incurred for test automation. Also, often s/w test automation requires skilled personnel and authentic test automation tools. Purchasing license of such tools is a costly affair.

Also the time required for test automation is more. Automation often requires recording the sequence of operations you need to perform in order to execute a particular test case and comparing the final o/p with the expected o/p. Functions/macros need also be written sometimes for some test cases. All this could be a time consuming job.