Snowflake Certified SnowPro Associate - Platform Certification - SOL-C01 Exam Questions

A. List the file formats in the currently-selected schema. B. Create a list of all of the file formats currently supported by Snowflake. C. List all of the files in a database that have data in a given file format. D. Get information about how different file formats should be used.

A. Using path notation to access specific elements within the VARIANT B. Using standard SQL WHERE clauses on the entire VARIANT column. C. Only through stored procedures. D. By converting the VARIANT column to a relational table first.

A. JSON B. Parquet C. CSV D. XML

A. Proprietary data sets B. Public data sets C. Third-party data sets D. Financial market data

A. Warehouse size B. Auto-resume C. Auto-suspend time D. Cloud provider region

A. A data stream B. Another Snowflake table C. An internal or external stage D. A local file system

A. Limited to simple queries B. Manual data storage configuration C. Pre-built queries only D. An intuitive SQL editor for writing and running queries

A. A schema is an immutable object. B. Each schema is available to a single role. C. A schema is contained in a database. D. Schemas are used to organize database objects. E. Schemas contain virtual warehouses.

A. BLOB B. JSON C. VARCHAR D. VARIANT

A. R B. Java C. Markdown D. SQL E. Scala F. Python