Snowflake interview questions

11. How data is organized in Snowflake?
Snowflake organizes the data into multiple micro partitions that are internally optimized and compressed. It uses a columnar format to store. Data is stored in the cloud storage and works as a shared-disk model thereby providing simplicity in data management.

12. What is Snowflake storage?
Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings. The Snowflake data platform is not built on any existing database technology or “big data” software platforms such as Hadoop.

13. What does Snowflake actually do?
The Snowflake architecture allows storage and compute to scale independently, so customers can use and pay for storage and computation separately. And the sharing functionality makes it easy for organizations to quickly share governed and secure data in real time.

14. What kind of database is snowflake ?
Snowflake is fundamentally built to be a complete SQL database. It is a columnar-stored relational database and works well with Tableau, Excel and many other tools familiar to end users. Snowflake has its own query tool, supports role-based security, multi-statement transactions, full DML, windowing functions and everything else expected in a SQL database. It’s the SQL you know and love – be gone, lesser-than imitators!

15. What are the unique features of the Snowflake ?
Database and Object Closing
Support for XML
External tables
Hive metastore integration
Supports geospatial data
Security and data protection
Data sharing
Search optimisation service
Table streams on external tables and shared tables
Result Caching

Author: user

Leave a Reply