Free SnowPro Core Exam Braindumps (page: 49)

Page 48 of 287

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

  1. Optimizes the virtual warehouse size and multi-cluster setting to economy mode
  2. Allows a user to import the files in a sequential order
  3. Increases the latency staging and accuracy when loading the data
  4. Allows optimization of parallel operations

Answer(s): D



Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

  1. Database replication and failover
  2. Automated index management
  3. Customer managed keys (Tri-secret secure)
  4. Extended time travel
  5. Native support for geospatial data

Answer(s): D,E



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

Answer(s): C



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

Answer(s): C,D






Post your Comments and Discuss Snowflake SnowPro Core exam with other Community members:

SnowPro Core Exam Discussions & Posts