An SPU in Netezza architecture consists of a CPU for general processing, RAM for memory operations, FPGA (Field-Programmable Gate Array) for accelerated data processing, and Disk for storage. This combination enables high-performance data warehousing operations.