Absolutely. You can use the QSFP ports on the SX1024 to connect two hosts and they will be able to communicate at 40 or 56GbE. The documentation may have referred to them as uplinks as on the 10GbE TOR switch, the 40GbE ports are typically used as uplinks to the core switch.
That does not limit them from being used as 40GbE directly to the servers/hosts. If you are only looking for 40GbE ports, SX1036 and SX1012 are also suitable options. If you need help choosing the right switch, feel free to drop us a note.
Great - thanks for the quick reply and clarification.