Free Snowflake SnowPro-Core Exam Dumps Questions & Answers

Which use case does the search optimization service support?

• A.  LIKE/ILIKE/RLIKE join predicates
• B.  Join predicates on VARIANT columns
• C.  Disjuncts (OR) in join predicates
• D.  Conjunctions (AND) of multiple equality predicates

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

• A.  Default Time Travel Retention is set to 0 days.
  Maximum Time Travel Retention is 30 days.
  Fail Safe retention time is 1 day.
• B.  Default Time Travel Retention is set to 90 days.
  Maximum Time Travel Retention is 7 days.
  Fail Safe retention time is 356 days.
• C.  Default Time Travel Retention is set to 0 days.
  Maximum Time Travel Retention is 90 days.
  Fail Safe retention time is 7 days.
• D.  Default Time Travel Retention is set to 7 days.
  Maximum Time Travel Retention is 1 day.
  Fail Safe retention time is 90 days.
• E.  Default Time Travel Retention is set to 1 day.
  Maximum Time Travel Retention is 365 days.
  Fail Safe retention time is 7 days.
• F.  Default Time Travel Retention is set to 1 day.
  Maximum Time Travel Retention is 90 days.
  Fail Safe retention time is 7 days.

When does a materialized view get suspended in Snowflake?

• A.  When the base table is reclustered
• B.  When a column is dropped from the base table
• C.  When a DML operation is run on the base table
• D.  When a column is added to the base table

How do secure views compare to non-secure views in Snowflake?

• A.  Secure views are similar to materialized views in that they are the most performant.
• B.  Non-secure views are preferred over secure views when sharing data.
• C.  There are no performance differences between secure and non-secure views.
• D.  Secure views execute slowly compared to non-secure views.

What information is found within the Statistic output in the Query Profile Overview?

• A.  Table pruning
• B.  Operator tree
• C.  Most expensive nodes
• D.  Nodes by execution time