Curriculum
- 1 Section
- 100 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Snowflake Interview Questions and Answers100 Snowflake Interview Questions and Answers100
- 1.1What is Snowflake?
- 1.2What are the key features of Snowflake?
- 1.3Explain Snowflake’s architecture.
- 1.4What is a Virtual Warehouse in Snowflake?
- 1.5How does Snowflake separate storage and compute?
- 1.6What is Time Travel in Snowflake?
- 1.7What is Fail-safe in Snowflake?
- 1.8What is Zero-Copy Cloning?
- 1.9How does Snowflake handle semi-structured data?
- 1.10What is Snowpipe?
- 1.11What are Streams and Tasks in Snowflake?
- 1.12What is Query Result Caching?
- 1.13Explain Micro-partitions.
- 1.14What is Secure Data Sharing in Snowflake?
- 1.15What is a Stage in Snowflake?
- 1.16What is the use of Materialized Views?
- 1.17What is Role-Based Access Control (RBAC) in Snowflake?
- 1.18What is the difference between Standard and Enterprise Editions?
- 1.19What is a Reader Account?
- 1.20Which cloud providers does Snowflake support?
- 1.21Difference between AUTO_INGEST and MANUAL Snowpipe?
- 1.22How do you unload data from Snowflake?
- 1.23Explain the role of metadata in Snowflake.
- 1.24What is Dynamic Data Masking?
- 1.25How do you restrict access to specific rows or columns?
- 1.26What is the difference between a Custom Role and a System Role?
- 1.27How can you audit user activity in Snowflake?
- 1.28What is Access History in Snowflake?
- 1.29What is automatic clustering?
- 1.30How do you monitor warehouse usage?
- 1.31How does query pruning work in Snowflake?
- 1.32How do you reduce costs in Snowflake?
- 1.33What are the different cache layers in Snowflake?
- 1.34How do you build a Data Pipeline in Snowflake?
- 1.35What is the role of Tasks and Streams in CDC?
- 1.36How do you orchestrate tasks in Snowflake?
- 1.37What are Procedures in Snowflake?
- 1.38Can you use control structures in procedures?
- 1.39How do you connect BI tools to Snowflake?
- 1.40How does Snowflake integrate with AWS S3 or Azure Blob?
- 1.41How do you create External Tables in Snowflake?
- 1.42Difference between External Table and Transient Table?
- 1.43How does Snowflake support JSON or XML querying?
- 1.44What is a Masking Policy?
- 1.45What is Column-level Security?
- 1.46What are limitations of Time Travel and Fail-safe?
- 1.47What is Database Replication in Snowflake?
- 1.48How does Secure Data Sharing work in Snowflake?
- 1.49What is a Transient Table in Snowflake and when should you use it?
- 1.50How does Snowflake handle concurrency?
- 1.51What is LATERAL FLATTEN in Snowflake?
- 1.52What is VARIANT data type in Snowflake?
- 1.53How is automatic scaling different from auto-suspend in Snowflake?
- 1.54What are resource monitors in Snowflake?
- 1.55What is the difference between transient and temporary tables in Snowflake?
- 1.56How do you schedule a Snowflake task?
- 1.57How do you ingest data from Kafka into Snowflake?
- 1.58What is a masking policy and how do you apply it?
- 1.59What is session context in Snowflake?
- 1.60How do streams and tasks work together in Snowflake?
- 1.61How does data replication work in Snowflake?
- 1.62What is the difference between a SCHEMA and a DATABASE in Snowflake?
- 1.63What is the maximum data retention time in Snowflake?
- 1.64What are system functions in Snowflake?
- 1.65How do you execute dynamic SQL in Snowflake?
- 1.66How do you migrate data from Redshift to Snowflake?
- 1.67What are user-defined functions (UDFs)?
- 1.68What is the difference between streams and change tracking?
- 1.69What is semi-structured indexing in Snowflake?
- 1.70How do you implement SCD Type 2 in Snowflake?
- 1.71What is Unistore in Snowflake?
- 1.72What are sequences in Snowflake?
- 1.73How do you use COPY INTO with file format options?
- 1.74What is the use of warehouse resume and suspend?
- 1.75How can cost be controlled in Snowflake?
- 1.76What is a secondary role in Snowflake?
- 1.77What are secure views?
- 1.78How do you monitor failed tasks?
- 1.79How is Snowflake billed?
- 1.80What are the types of caching in Snowflake?
- 1.81How does MATERIALIZED VIEW refresh work?
- 1.82How do you control access using future grants?
- 1.83What are roles and role hierarchy in Snowflake?
- 1.84How do you move Snowflake objects between environments?
- 1.85What is a hybrid table?
- 1.86What is a pipe in Snowflake?
- 1.87How do you enable auditing in Snowflake?
- 1.88What is the default data retention for transient tables?
- 1.89What are limitations of Time Travel?
- 1.90How do you process multi-level JSON?
- 1.91What is a multi-table insert?
- 1.92What are INFORMATION_SCHEMA views used for?
- 1.93What is masking vs. row access policy?
- 1.94What is CURRENT_ROLE and why is it important?
- 1.95What happens when a task fails?
- 1.96How can Snowflake be integrated with third-party tools?
- 1.97How do you define default role for a user?
- 1.98What is the best way to manage schema migrations?
- 1.99What is the difference between Snowflake and Databricks?
- 1.100How can you track lineage in Snowflake?
What is the difference between Snowflake and Databricks?
Prev