Snowflake does not provide which of following set of SQL functions to support retrieving infor-mation about tasks?

• A.SYSTEM$CURRENT_USER_TASK_NAME
• B.TASK_HISTORY
• C.TASK_DEPENDENTS
• D.TASK_QUERY_HISTORY
• E.SYSTEM$TASK_DEPENDENTS_ENABLE

Comment: *

Name: *

Email: *

Verification: *

Which output is provided by both theSYSTEM$CLUSTERING_DEPTHfunction and theSYSTEM$CLUSTERING_INFORMATIONfunction?

• A.average_depth
• B.notes
• C.average_overlaps
• D.total_partition_count

Comment: *

Name: *

Email: *

Verification: *

Which one is not the Core benefits of micro-partitioning

• A.Snowflake micro-partitions are derived automatically they do not need to be explicitly defined up-front or maintained by users.
• B.Enables extremely efficient DML and fine-grained pruning for faster queries.
• C.Micro-partitions can overlap in their range of values, helps data skewing.
• D.Columns are stored independently within micro-partitions, often referred to as colum-nar storage.
• E.Columns are also compressed individually within micro-partitions.

Comment: *

Name: *

Email: *

Verification: *

Mark the Correct Statements:
Statement 1. Snowflake's zero-copy cloning feature provides a convenient way to quickly take a "snapshot" of any table, schema, or database.
Statement 2. Data Engineer can use zero-copy cloning feature for creating instant backups that do not incur any additional costs (until changes are made to the cloned object).

• A.Statement 1
• B.Statement 2
• C.Both are False.
• D.Statement 1 & 2 are correct.

Comment: *

Name: *

Email: *

Verification: *

Marko, a Data Engineer is using Snowpipe for data loading in micro batches for one of the Finance Data workloads. There are set of files he attempted to load into the snowflake table using Snow-pipe. While monitoring he found that there are set of files has multiple issue, He queried the COPY_HISTORY view & checked the STATUS column which indicates whether a particular set of files was loaded, partially loaded, or failed to load. But he wants to view all errors in the files along with Load status, how he can check all errors?

• A.He can check RETURN_ALL_ERROR_MESSAGE column in the COPY_HISTORY view which can provides a reason and view all errors in the files.
• B.He can view all errors in the files, by executing a COPY INTO <table> statement with the VALIDATION_ERROR_MODE copy option set to RE-TURN_ALL_PIPE_ERRORS.
• C.Marko can look out for FIRST_ERROR_MESSAGE column in the COPY_HISTORY view which can provides a reason why a file partially loaded or failed for all the files.
• D.He can view all errors in the files, by executing a COPY INTO <table> statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS.

Comment: *

Name: *

Email: *

Verification: *