CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. SnowPro Core

Free SnowPro Core Exam Braindumps (page: 41)

Page 40 of 287
PDF with 1268 Questions

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no queries have been executed previously? (Choose three.)

  1. MIN(<< column value >>)
  2. COPY
  3. SUM(<< column value >>)
  4. UPDATE

Answer(s): B,C,D



What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

  1. VIEWS_HISTORY
  2. OBJECT_HISTORY
  3. ACCESS_HISTORY
  4. LOGIN_HISTORY

Answer(s): C



Which feature is only available in the Enterprise or higher editions of Snowflake?

  1. Column-level security
  2. SOC 2 type II certification
  3. Multi-factor Authentication (MFA)
  4. Object-level access control

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/intro-editions.html#enterprise-edition



Will data cached in a warehouse be lost when the warehouse is resized?

  1. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
  2. Yes, because the compute resource is replaced in its entirety with a new compute resource.
  3. No, because the size of the cache is independent from the warehouse size.
  4. Yes, because the new compute resource will no longer have access to the cache encryption key.

Answer(s): A






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

SnowPro Core Exam Discussions & Posts