Yes, you must enable predictive optimization at the account level. Once enabled, predictive optimization will be applied by default to all catalogs, schemas, and tables within the account. To prevent predictive optimization from being applied to specific catalogs, you should disable it for those catalogs before enabling it at the account level. You can do this using the following command:
ALTER CATALOG [catalog_name] DISABLE PREDICTIVE OPTIMIZATION;
This way, when you enable predictive optimization at the account level, it will not be applied to the catalogs where you have explicitly disabled it.