A Data Engineer is building a pipeline to transform a 1 TB table by joining it with supplemental tables. The Engineer is applying filters and several aggregations leveraging Common Table Expressions (CTEs) using a size Medium virtual warehouse in a single query in Snowflake.After checking the Query Profile, what is the recommended approach to MAXIMIZE performance of this query if the Profile shows data spillage?
Which system role is recommended for a custom role hierarchy to be ultimately assigned to?
Which callback function is required within a JavaScript User-Defined Function (UDF) for it to execute successfully?
Which Snowflake feature facilitates access to external API services such as geocoders, data transformation, machine learning models, and other custom code?
A Data Engineer needs to know the details regarding the micro-partition layout for a table named Invoice using a built-in function.Which query will provide this information?
A Data Engineer would like to define a file structure for loading and unloading data.Where can the file structure be defined? (Choose three.)
