According to the fcc internal photos it's a ipq8074 002 (without the a) and that's a ipq8074 hw revision v1 i believe.
Additionally QSDK uses q6 firmware labeled hw revision v1.
There is nothing in the logs regarding "Skip QCA8074V1 in V2 platform"
Edit: it's the other way around:
Skip QCA8074V2 in V1 platform
I have only the q6 firmware version from QSDK 10 and from the gpl dump. none of these works.
I haven't found any other fw versions.