128 ) Cognizant qsns - 21jul26

 

1. Explain your previous project 
2. Data modeling side what you did 
1. can you tell about how you design table
2. were there any performance issues happened 
3. how you move from one layer to another layer 
4. how the data model works 
3. how do you implement the principles of data model 
4. you said medallion arch . what is the business benefit with your model
5. how the forward engineering works
6. qsns on views 
1. you worked on redshift ...did you create any views on tables .. 
2. how many types of views are there
3. diff materialized and normal views 
4. can we use any joins in materialized views 
7. diff between bottom up and top down approach
8. diff surrogate and primary key 
9. How many types of SQL CONSTRAINTS ARE THERE 
10. DATA MODEL TUNING :
1. With fact table of 50 billion records , we genereate report in powerbi , it is taking 20 to 30 secs ....what shd we do to improve the performance of the report query ... what changes should we do in MODEL 
11. SQL 
1. find salary of empid =21
2. find highest salary
3. 2nd highest salary
4. What is diff - delete and truncate