Cardano achieves transaction atomicity and consistency through transactional guarantees, rollback mechanisms, and state reconciliation protocols that ensure all or none of the operations within a transaction are executed and committed to the blockchain, maintaining data integrity and consistency in the event of failures or errors during transaction processing.