Free SnowPro Core Exam Braindumps (page: 4)

Page 3 of 287

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

  1. Number of users
  2. Warehouse size
  3. Amount of data processed
  4. # of clusters for the Warehouse

Answer(s): B,D



Which statement best describes `clustering`?

  1. Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
  2. The database administrator must define the clustering methodology for each Snowflake table
  3. The clustering key must be included on the COPY command when loading data into Snowflake
  4. Clustering can be disabled within a Snowflake account

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html



True or False: The COPY command must specify a File Format in order to execute.

  1. True
  2. False

Answer(s): B


Reference:

https://interworks.com/blog/hcalder/2018/07/26/the-basics-of-loading-data-into-snowflake/



Which of the following commands sets the Virtual Warehouse for a session?

  1. COPY WAREHOUSE FROM <<config file>>;
  2. SET WAREHOUSE = <<warehouse name>>;
  3. USE WAREHOUSE <<warehouse name>>;
  4. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Answer(s): C


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-tasks.html






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

SnowPro Core Discussions & Posts