SnowPro Core Practice Test

SnowPro Core Practice Test practice questions, page 52 of 54, with answer review and explanations.

Question 256

What is a core benefit of clustering?

  1. To guarantee uniquely identifiable records in the database
  2. To increase scan efficiency in queries by improving pruning
  3. To improve performance by creating a separate file for point lookups
  4. To provide data redundancy by duplicating micro-partitions

Question 257

Which statement is true about Multi-Factor Authentication (MFA) in Snowflake?

  1. MFA can be enforced or applied for a given role.
  2. Snowflake users are automatically enrolled in MFA.
  3. Users enroll in MFA by submitting a request to Snowflake Support.
  4. MFA is an integrated Snowflake feature.

Question 258

What data type should be used to store JSON data natively in Snowflake?

  1. JSON
  2. String
  3. Object
  4. VARIANT

Question 259

What should be considered when deciding to use a Secure View? (Choose two.)

  1. No details of the query execution plan will be available in the query profiler.
  2. Once created there is no way to determine if a view is secure or not.
  3. Secure views do not take advantage of the same internal optimizations as standard views.
  4. It is not possible to create secure materialized views.
  5. The view definition of a secure view is still visible to users by way of the information schema.

Question 260

The information schema provides storage information for which of the following objects? (Choose two.)

  1. Users
  2. Databases
  3. Internal stages
  4. Resource monitors
  5. Pipes