Free COF-R02 Exam Braindumps (page: 32)

Page 31 of 83

What is the MOST performant file format for loading data in Snowflake?

  1. CSV (Unzipped)
  2. Parquet
  3. CSV (Gzipped)
  4. ORC

Answer(s): A



Which copy INTO command outputs the data into one file?

  1. SINGLE=TRUE
  2. MAX_FILE_NUMBER=1
  3. FILE_NUMBER=1
  4. MULTIPLE=FAISE

Answer(s): A



Where would a Snowflake user find information about query activity from 90 days ago?

  1. account usage . query history view
  2. account usage.query history archive View
  3. information schema . cruery_history view
  4. information schema - query history_by_ses s i on view

Answer(s): A



Which Snowflake technique can be used to improve the performance of a query?

  1. Clustering
  2. Indexing
  3. Fragmenting
  4. Using INDEX HINTS

Answer(s): A


Reference:

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






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

COF-R02 Discussions & Posts