What is CI test execution in Test Automation?

CI test execution is an important concept in Test Automation. Understand its purpose, how it works, when to use it, and the tradeoffs it introduces before applying it in a production system.