Free SnowPro Core Exam Braindumps (page: 32)

Page 31 of 287

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

  1. Users
  2. Tables
  3. Databases
  4. Internal Stages

Answer(s): B,C,D



What is the default File Format used in the COPY command if one is not specified?

  1. CSV
  2. JSON
  3. Parquet
  4. XML

Answer(s): A


Reference:

https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html



True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

  1. True
  2. False

Answer(s): A


Reference:

https://acrotrend.com/snowflake-data-sharing/



True or False: You can define multiple columns within a clustering key on a table.

  1. True
  2. False

Answer(s): A


Reference:

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






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

SnowPro Core Discussions & Posts