Free COF-R02 Exam Braindumps (page: 39)

Page 38 of 83

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

  1. An FTP server with TLS encryption
  2. An HTTPS server with WebDAV
  3. A Google Cloud storage bucket
  4. A Windows server file share on Azure

Answer(s): C



Which data type can be used to store geospatial data in Snowflake?

  1. Variant
  2. Object
  3. Geometry
  4. Geography

Answer(s): D


Reference:

https://docs.snowflake.com/en/sql-reference/data-types- geospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point



What can be used to view warehouse usage over time? (Select Two).

  1. The load HISTORY view
  2. The Query history view
  3. The show warehouses command
  4. The WAREHOUSE_METERING HISTORY View
  5. The billing and usage tab in the Snowflake web Ul

Answer(s): D,E



Which Snowflake feature is used for both querying and restoring data?

  1. Cluster keys
  2. Time Travel
  3. Fail-safe
  4. Cloning

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.






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

COF-R02 Discussions & Posts