1. Yes, the Groovy Console is part of ACS AEM Commons, not a standalone feature of AEM itself. When I mentioned "Groovy script via ACS AEM Commons", I meant running scripts using the Groovy Console provided by the ACS AEM Commons package.
2. Yes, to make querying on dam:failedRenditions performant, ...