DEA-C01

If an external function is secure, the URL, the HTTP headers, and the context headers are hidden from all users who are not owners of the function.A . TRUE B. FALSEView AnswerAnswer: A Explanation https://docs.snowflake.com/en/sql-reference/sql/create-external-function.html#optional-parameters Optional Parameters SECURE Specifies that the function is secure. If a function is secure, the...

Which snowflake parameter limits the number of iterationsA . MAX_RECURSIONS B. MAX_ITERATIONS C. MAX_LOOPView AnswerAnswer: A Explanation Recursive CTE Considerations Potential for Infinite Loops In theory, constructing a recursive CTE incorrectly can cause an infinite loop. In practice, Snowflake prevents this by limiting the number of iterations that the recursive...

Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?A . Column reordering B. Column renaming C. Column omission D. Casts E. Truncating text strings that exceed the target column lengthView AnswerAnswer: A, C, D, E Explanation Simple Transformations During a Load Snowflake...

Bytes spilled to remote storage 8.16 GB Which of the below techniques will you be using to decrease remote spilling?A . Review the query for optimization, especially if it is a new query B. Reduce the amount of data processed by trying to improve partition pruning C. Decrease the number...

FORMAT_NAME and TYPE are mutually exclusive in the COPY command.A . TRUE B. FALSEView AnswerAnswer: A Explanation FILE_FORMAT = ( FORMAT_NAME = 'file_format_name' ) or FILE_FORMAT = ( TYPE = CSV | JSON | AVRO | ORC | PARQUET | XML [ ... ] ) Specifies the format of the...

Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?A . Column reordering B. Column renaming C. Column omission D. Casts E. Truncating text strings that exceed the target column lengthView AnswerAnswer: A, C, D, E Explanation Simple Transformations During a Load Snowflake...

; call sp1(); SELECT * FROM EMPLOYEE ORDER BY ID;A . 1 MOHAN 2 RON B. 1 MOHAN 2 RON 3 RANJAN C. 1 MOHAN 3 RANJAN D. 1 MOHANView AnswerAnswer: A Explanation https://docs.snowflake.com/en/sql-reference/transactions.html#scoped-transactions Scoped Transactions A stored procedure that contains a transaction can be called from within another transaction....

CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20; Later you dropped the schema. In this scenario what data retention value will be honored for the table, if we need to retrieve the table data A. 10 B. 20 C. 30View AnswerAnswer: A Explanation https://docs.snowflake.com/en/user-guide/data-time-travel.html#dropped-containers-and-object-retention-inh eritance Dropped Containers and Object...

Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?A . Column reordering B. Column renaming C. Column omission D. Casts E. Truncating text strings that exceed the target column lengthView AnswerAnswer: A, C, D, E Explanation Simple Transformations During a Load Snowflake...

Which of the below functions are recommended to be used to understand the clustering ratio of a table?A . SYSTEM$CLUSTERING_RATIO B. SYSTEM$CLUSTERING_DEPTH C. SYSTEM$CLUSTERING_INFORMATIONView AnswerAnswer: B, C Explanation https://docs.snowflake.com/en/sql-reference/functions/system_clustering_ratio.html