SnowPro Core Practice Test

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

Question 191

What is the default file size when unloading data from Snowflake using the COPY command?

  1. 5 MB
  2. 8 GB
  3. 16 MB
  4. 32 MB

Question 192

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

  1. Row level access policies
  2. Data masking policies
  3. Data encryption
  4. Time Travel
  5. External tokenization

Question 193

Which Snowflake layer is always leveraged when accessing a query from the result cache?

  1. Metadata
  2. Data Storage
  3. Compute
  4. Cloud Services

Question 194

Which connectors are available in the downloads section of the Snowflake web interface (UI)? (Choose two.)

  1. SnowSQL
  2. JDBC
  3. ODBC
  4. HIVE
  5. Scala

Question 195

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be met?

  1. Use data encryption.
  2. Use dynamic data masking.
  3. Use secure materialized views.
  4. Revoke all roles for functional managers and end users.