What metadata does Snowflake store concerning all rows stored in a micro-partition? (Select TWO)

• A.A count of the number of total values in the micro-partition
• B.The range of values for each partition in the micro-partition
• C.The range of values for each of the rows in the micro-partition
• D.The range of values for each of the columns in the micro-partition
• E.The number of distinct values for each column in the micro-partition

Comment: *

Name: *

Email: *

Verification: *

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

• A.Query parsing and optimization
• B.Virtual warehouse caching
• C.Resource management
• D.Physical storage of micro-partitions
• E.Authentication
• F.Query execution

Comment: *

Name: *

Email: *

Verification: *

Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?

• A.DELETE
• B.DROP
• C.REMOVE
• D.TRUNCATE

Comment: *

Name: *

Email: *

Verification: *

Which data types can be used in a Snowflake table that holds semi-structured data? (Select TWO).

• A.ARRAY
• B.BINARY
• C.TEXT
• D.VARIANT
• E.VARCHAK

Comment: *

Name: *

Email: *

Verification: *

What is a best practice after creating a custom role?

• A.Create the custom role using the SYSADMIN role.
• B.Assign the custom role to the SYSADMIN role
• C.Assign the custom role to the PUBLIC role
• D.Add_CUSTOM to all custom role names

Comment: *

Name: *

Email: *

Verification: *