For a Cable Internet Transfer, is a Technician visit to my premises required?

No, if you are approved for a cable internet transfer then a Technician visit is not needed and activation is done remotely.