Scribd
Upload
25 views1 page

SQL Questions

This document outlines topics to discuss regarding experience with Snowflake including its architecture, data loading processes, handling duplicates and performance optimization, using features like time travel and UDFs, migration challenges, implementing tasks and streams, loading structured/semi-structured files while handling large volumes of data, project architecture, orchestrating pipelines, managing transactions, roles, and views. The interview may involve scenario-based questions about the applicant's specific Snowflake projects and knowledge. A strong understanding of Snowflake basics to intermediate cloud and data concepts is important.

Uploaded by

veerendrab935
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
25 views1 page

SQL Questions

This document outlines topics to discuss regarding experience with Snowflake including its architecture, data loading processes, handling duplicates and performance optimization, using features like time travel and UDFs, migration challenges, implementing tasks and streams, loading structured/semi-structured files while handling large volumes of data, project architecture, orchestrating pipelines, managing transactions, roles, and views. The interview may involve scenario-based questions about the applicant's specific Snowflake projects and knowledge. A strong understanding of Snowflake basics to intermediate cloud and data concepts is important.

Uploaded by

veerendrab935
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

1.

Snowflake Architecture and it's various components


2. Data loading and challenges faced
3. Data loading include copy command, how do you create stages, various stage -
table/internal/external.
4. How does stages differ from each other.
5. How to create external stage referencing S3 bucket/ADSL
6. Scenarios like how do you handle duplicates as integrity constraints are not
enforced in SF.
7. What are warehouses and how do you design it.
8. Performance optimization - Auto Scaling, Caching and clustering
9. Scenarios where you have used time travel feature.
10. UDF and how have you used it.
11. Restrictions in SF as compared to RDBMS database.
12. If you have worked on migration what are challenges faced and how did you
overcome it.
13. Task, streams implementation scenario.
14. Structured/semi- structured files how have you loaded them.
15. Volume of data you have handled.
16. Architecture of your project.
17. Orchestration of SF pipelines - tools being used for it.
18. How do you handle transactional transactions in Snowflake.
19. Snowpipe
[Link] Unloading.
21. Role based access management - important to have knowledge on this.
22. How does normal views and materials views differ in Snowflake

There can be various scenario based question based on what you explain about your
project and how knowledgeable interviewer is.

With Snowflake you need to have basic to intermediate knowledge on cloud technology
and orchestration will be add on.

You might also like