Which privilege is needed for a SnowFlake user to see the definition of a secure view?

• A.MODIFY
• B.OWNERSHIP
• C.USAGE
• D.CREATE

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake partner specializes in data catalog solutions?

• A.Alation
• B.DataRobot
• C.dbt
• D.Tableau

Comment: *

Name: *

Email: *

Verification: *

Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?

• A.Data classification
• B.Query acceleration service
• C.Search optimization service
• D.Tagging

Comment: *

Name: *

Email: *

Verification: *

What does a table with a clustering depth of 1 mean in Snowflake?

• A.The table has only 1 micro-partition.
• B.The table has 1 overlapping micro-partition.
• C.The table has no overlapping micro-partitions.
• D.The table has no micro-partitions.

Comment: *

Name: *

Email: *

Verification: *

An external stage many_stage contains many directories including one, app_files that contains CSV files How can all the CSV files from this directory be moved into table my_table without scanning files that are not needed?

• A.Use a command with the set to , and manually list each file in the directory.
• B.Load all files from the external stage and filter out the non-CSV files within the statement.
• C.Use a (CTAS) statement to import CSV files from the directory.COPY INTOFILE_FORMATCSVCOPY INTOapp_filesCOPY INTOCREATE TABLE AS SELECT
• D.Use a command with a regular expression pattern to match only CSV files from the directory.

Comment: *

Name: *

Email: *

Verification: *