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: 44)

Page 43 of 287
PDF with 1268 Questions

Network policies can be set at which Snowflake levels? (Choose two.)

  1. Role
  2. Schema
  3. User
  4. Database
  5. Account
  6. Tables

Answer(s): C,E


Reference:

https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies



What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

  1. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.
  2. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.
  3. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
  4. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
  5. Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.
  6. Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.

Answer(s): D



Which of the following objects are contained within a schema? (Choose two.)

  1. Role
  2. Stream
  3. Warehouse
  4. External table
  5. User
  6. Share

Answer(s): B,D



Which of the following statements describe features of Snowflake data caching? (Choose two.)

  1. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
  2. When the data cache is full, the least-recently used data will be cleared to make room.
  3. A user can only access their own queries from the query result cache.
  4. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
  5. The RESULT_SCAN table function can access and filter the contents of the query result cache.

Answer(s): B,E






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

SnowPro Core Exam Discussions & Posts