Free SnowPro Core Exam Braindumps (page: 36)

Page 35 of 287

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

  1. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
  2. Scaling out adds clusters of varying sizes to a virtual warehouse.
  3. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
  4. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
  5. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
  6. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Answer(s): A,E



What is the minimum Snowflake edition that has column-level security enabled?

  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake

Answer(s): B



What parameter controls if the Virtual Warehouse starts immediately after the CREATE WAREHOUSE statement?

  1. INITIALLY_SUSPENDED = TRUE/FALSE
  2. START_AFTER_CREATE = TRUE/FALSE
  3. START_THE = 60 // (seconds from now)
  4. START_TIME = CURRENT_DATE()

Answer(s): A



When cloning a database, what is cloned with the database? (Choose two.)

  1. Privileges on the database
  2. Existing child objects within the database
  3. Future child objects within the database
  4. Privileges on the schemas within the database
  5. Only schemas and tables within the database

Answer(s): B,D






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

SnowPro Core Discussions & Posts