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. COF-R02

Free COF-R02 Exam Braindumps (page: 44)

Page 43 of 83
PDF with 330 Questions

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE)

  1. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
  2. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
  3. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
  4. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
  5. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
  6. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Answer(s): D,E,F



Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

  1. Materialized view
  2. Sequence
  3. Secure view
  4. Transient table
  5. Clustered table

Answer(s): D,E



A user is preparing to load data from an external stage.
Which practice will provide the MOST efficient loading performance?

  1. Organize files into logical paths
  2. Store the files on the external stage to ensure caching is maintained
  3. Use pattern matching for regular expression execution
  4. Load the data in one large file

Answer(s): D



If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

  1. 4
  2. 8
  3. 16
  4. 32

Answer(s): B

Explanation:

Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:


Reference:

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






Post your Comments and Discuss Snowflake COF-R02 exam with other Community members:

COF-R02 Discussions & Posts