Load testing tools are specifically designed to simulate a high volume of concurrent users accessing the system. This type of testing helps assess the system's ability to handle increased loads and ensures its scalability under heavy usage conditions. Stress testing also evaluates system performance under extreme conditions, but it may not necessarily focus solely on simulating concurrent users.

Manually deleting affected rows is not a recommended approach as it might lead to data inconsistency. Restarting the SQL Server service is a drastic measure and may disrupt other ongoing operations. Executing a new COMMIT TRANSACTION statement would finalize the changes, which is contrary to the goal of rolling back. The correct step is to use the ROLLBACK TRANSACTION statement to undo the changes made so far and maintain data integrity.

Access control testing involves assessing the methods used to authenticate users and enforce authorization policies. Therefore, the correct option is "Authorization," as it pertains to defining and enforcing access rights. Authentication verifies the identity of users, encryption secures data during transmission or storage, and firewalls protect networks from unauthorized access but are not directly related to access control testing.

This suggests a data integrity issue. Data integrity ensures the accuracy, reliability, and consistency of data throughout its lifecycle. In this scenario, the presence of duplicate records in the target database that were not in the source data indicates a failure in maintaining the integrity of the data during the ETL process.

Profiling in database monitoring refers to the process of monitoring and analyzing database query performance. It involves examining various aspects such as query execution time, resource usage, and query optimization to identify bottlenecks and optimize query performance. By profiling queries, database administrators can gain insights into how queries are executed and identify opportunities for improving database performance.

Test data generation tools play a crucial role in populating databases with relevant data for comprehensive testing. Relevant data closely resembles real-world scenarios and helps in uncovering potential issues that might not be apparent with random or synthetic data.

Duplicates

The immediate action to mitigate SQL injection vulnerabilities is to sanitize input data. This involves validating and cleaning user inputs before using them in SQL queries. Sanitization prevents attackers from injecting malicious SQL code into the application, thus protecting it from SQL injection attacks.

AES

Data partitioning involves dividing the data into smaller, manageable chunks distributed across multiple nodes in a distributed system. This allows for parallel processing and efficient utilization of resources, enabling better performance and scalability when dealing with large data sets.