Hi Carlos,
Kentico is using ADO.NET under the hood to work with the database. According to MS docs, it should work. However, you can't customize SqlTransaction call, therefore you'd also need to configure READ_COMMITTED_SNAPSHOT ON option (refer to MS docs above). Is there any specific reason you need it? If you have troubles with concurrent work with the database via Kentico API this may not help and probably would be easier to resolve this on code level.