ANSWER:
D:
SQL Server logs every transaction, so that in the event of a system failure, committed changes will be completed, while uncommitted changes will rolled back automatically.
Answer in Depth...