Clearly, there is a potential risk of cancer
from radiation exposure.
The greater the exposure(s), the greater the risk. One cannot quantify the risk, but it is likely quite low. This has to be balanced against the reason for doing the scan. When there is a legitimate reason for scanning, the risk of not doing the scan and missing something vastly outweighs the risks.