Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 613

Which statistic displayed in a Query Profile is specific to external functions?

    Correct Answer: B

    The statistic 'Total invocations' is specific to external functions in a Query Profile. It indicates the number of times an external function was called, which can include multiple calls due to row batch divisions or retries. This statistic directly pertains to the behavior of external functions, unlike other options provided.

Discussion
KnightVictorOption: B

for sure B total invocations

chuks_charleyOption: B

External Functions — information about calls to external functions: The following statistics are shown for each external function called by the SQL statement. If the same function was called more than once from the same SQL statement, then the statistics are aggregated. Total invocations — number of times that an external function was called. (This can be different from the number of external function calls in the text of the SQL statement due to the number of batches that rows are divided into, the number of retries (if there are transient network problems), etc.)

nexerSnowOption: D

The following statistics are shown for each external function called by the SQL statement. If the same function was called more than once from the same SQL statement, then the statistics are aggregated. Total invocations — number of times that an external function was called. (This can be different from the number of external function calls in the text of the SQL statement due to the number of batches that rows are divided into, the number of retries (if there are transient network problems), etc.)

Rameez1Option: B

for sure B total invocations

shujazOption: B

Sorry I mean B

shujazOption: B

C is correct: Total invocations https://docs.snowflake.com/en/user-guide/ui-query-profile

learner2023Option: B

https://docs.snowflake.com/en/user-guide/ui-query-profile

chuks_charley

https://docs.snowflake.com/en/user-guide/ui-query-profile