info@cloudhill.in
+91 8919464699
REGISTER
CH
CloudHill
Corporate Training
Syllabus
Submit Feedback
Feedback
Courses
Snowflake
Syllabus
Daywise Learning
Self paced Learning
Interview Questions
Discussions
DBT
IICS
SQL
Syllabus
Day-wise Learning
Interview Questions
Projects
Snowflake
Practice Sets
Learner Feedback
Login
SQL Interview Questions
Set 1
Set 2
Set 3
1. Introduce your self
2. What is Pipe line?use of pipe line?
3. What is Snow Pipe And how can you intigrate snowpipe to s3?
4. Once data is loaded into snowflake how updated records are distinguished?
5. When will change warehouse Properties?
6. Difference between Delete & Truncate Command?
7. How to get duplicate records from table?
8. Tell me about scd types?
9. Have you worked on data sharing in snowflake what is the process?
10. Can you share the data outside the region?
11. Have you worked on time travel?time travel period for different tables?
12. Difference between Temparory table and transient table?
13. Data loading steps from S3 to Snowflake?
14. What is External Stage?Can you load data without using external stage ?
15. I have CSV file with 10gb of data can we load into a singleshot?
16. how you done file splits before loading?
17. Sum of all positive numbers&negative numbers Seperatly?
18. We have a student tables of 1000 records we want to fetch only odd roll number students?
19. Data Size you have Deal with?
1. Snowflake loading --- you have a text file on desktop should load it into snowflake which method do you use.
2. Where would you create the stage.
3. Stages? external stage location—aws…
4. Let’s say you have file in external stage how do you read it?
5. Convenient method to load files into snowflake
6. Different sizes of warehouses in snowflake
7. If an extra small takes one server what would an small warehouse take
8. Multi cluster warehouses- options to maximize performance / all clusters should be used.
9. Can you use multi cluster warehouse in standard edition.
10. Scenario : taking too long to run queries and queries getting queued up. And the queries are simple not complex. Which approach will you prefer will you increase the size of warehouse or will you increase the no. of clusters.
11. Will snowflake enforce primary keys.
12. Time travel feature in snowflake / based o tables too explain.
13. Why do you need a data warehouse why not we query reports in OLTP. (why OLAP why not OLTP)
14. Let us say we are starting a business how will you move the daily data from an OLTP source to OLAP.
15. ETL tools?
16. How do you distinguish the updates records/ files (may be duplicates) while loading the data by using ETL
17. While loading data into snowflake what transformations/ features you commonly use
18. Could you describe the tasks you have created – code – specific use of task you used in your project
19. Stored procedures used in your project
1. Can you tell me about your project and what kind of activities you have done?
2. What is the source of the files you get?
3. What are the set of activities you are doing in snowfklake?
4. Have you used queue?
5. In staging what kind of activities have you done?
6. Are you using real time ingestion?
7. what kind of challenges did you met from migrating data into snowflake?
8. which file format are you getting in s3?
9. What is the difference of storing data tables in columanar wise in database and row wise in data warehouse?
10. What is the size of micro partition?
11. What is virtual warehouse?
12. As per bussiness requirement what kind of ware house will you select?
13. Some queries are taking more time than usual what will you do to speed up and where will you check?
14. Explain the query performance while using materialised views?
15. What are the types of views in snowflake and explain secure view?
16. What are the streams?
17. What are the tables available in snowflake and what is the difference between them?
18. What is zero copy cloning ?if you make changes in clone table does it effect base table?
19. Write stored procedure?
20. Write a query to alter the time travel?
21. What kind of priviliges and roles in snowflake and difference between them?
Back To Top