The correct SOQL query to retrieve all fields for a specific Account is to use the FIELDS(ALL) function within the SELECT clause of the SOQL query. This will return all fields for the Account named 'Acme'.
References: SOQL and SOSL Reference Guide - FIELDS() Function