When heated, yes. THCa turns into Delta-9 THC through smoking, vaping, or cooking, and that conversion creates psychoactive effects. The strength of the effects depends on the strain, your tolerance, and how much you use.
If you don’t want a traditional THC-style experience, THCa flower may not be the right fit.