Hi. You will not have questions related to the programing language in the procedures, but your understanding of procedure would be tested. No need to remember all the file format options but the frequently used once should be enough.

Do check for more insights on the Data Engineer certification exam here - https://medium.com/@snowflakewiki/snowpro-advanced-data-engineer-certification-guide-e7a5a54980bd