Free SnowPro Core Exam Braindumps (page: 24)

Page 23 of 287

The FLATTEN function is used to query which type of data in Snowflake?

  1. Structured data
  2. Semi-structured data
  3. Both of the above
  4. None of the above

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/querying-semistructured.html



True or False: An active warehouse is required to run a COPY INTO statement.

  1. True
  2. False

Answer(s): A



True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html



True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

  1. True
  2. False

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html






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

SnowPro Core Discussions & Posts