← Back to exam page

SnowPro-Core – SnowPro Core Certification Exam

Loading demo links...

Showing 10–12 of 20 questions

Question 10

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Select all that apply, then click Submit answer.

  • ○

    Load files that are approximately 25 MB or smaller.
  • ○

    Remove all dates and timestamps.
  • ○

    Load files that are approximately 100-250 MB (or larger)
  • ○

    Avoid using embedded characters such as commas for numeric data types
  • ○

    Remove semi-structured data types
Question 11

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Select an option, then click Submit answer.

  • ○

    Standard
  • ○

    Premier
  • ○

    Enterprise
  • ○

    Business Critical Edition
Question 12

Which statement MOST accurately describes clustering in Snowflake?

Select an option, then click Submit answer.

  • ○

    The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
  • ○

    Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
  • ○

    The clustering key must be included in the COPY command when loading data into Snowflake.
  • ○

    Clustering can be disabled within a Snowflake account.