Thursday, July 22, 2021

Snowflakes interview questions -2

Questions specific to data loading/unloading :

1. Difference between copy and put command.
2. Steps involved in creation of stages.
3. Different type of stages.
4. Rejected/bad records- how to view them.
5. Considering a scenario where you need to load files as soon as it arrives, how would you implement it.
6. Loading semi structured data - through variant column.
7. How does snowflake always load the incremental data files ignoring the ones already loaded.
8. How would you force to load all the files in a given folder/directory.
9. Can you query data on external storage without loading them, if yes how ?
10. Bulk vs Continuous loading.

Snowflakes interview questions -1

Probable Interview Questions on Snowflake :

Snowflake being relatively new most of the interview questions would be based on how you have implemented and used it in your project.

Some which I could recall are -

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
20.Data 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.

Saturday, June 5, 2021

linux basics +DevOps+AWS+python basics

Linux basics and commands, real time trouble shooting, 
Git
Github
Jenkins
Maven
Apache Tomcat
Nexus
Sonar qube
Pipeline code
Docker
Ansible
Terraform
Kubernetes
Prometheus
Garafana
cAdvisor
Node exporter 
Zabbix doc

Load balancer realtime usage nginx

Each topic with real time scenario based explanation and hadsson from scratch. 

Project explanation
Each topic handson
Each topic real time interview questions.

Realtime tools 
Putty, mputty, mobaexterm, winscp, Filezilla, putty gen. 

Aws
_______

Ec2
S3
Iam
Elb
Auto scalling
Sns
Sqs
Cloud watch
Cloudfront
Vpc
Elastic beanstalk
Rds
Aws cli
Route 53
Ecr
Ecs
Fargate
Cidr
Lambda



Python basics

Python modules

Boto3 package to automate infrastructure


*Course* : linux basics +DevOps+AWS+python basics
*Duration*: 5 months
Monday to friday

Time : 9pm to 10pm IST 

More information

Interview Questions on Snowflake


Snowflake being relatively new most of the interview questions would be based on how you have implemented and used it in your project.

Some which I could recall are -

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
20.Data 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.

Friday, May 21, 2021

Devops interview Questions

Kubernetes :
==========================================
1) what is taint and toleration 
2) node affinity an pod affinity 
3) how to check the logs of a pod or deployment?
4) how to check how many pods are running
5) what are deployment strategy used in your project
6) what is init container
7) what is statefullset
8) what is ingress
9) difference between headfull and headless service
10) difference between secret and configmap
11) what is livenessprobe and readynesspeobe
12) how to access other pods in a cluster
13) what is a pod
14) how you will make sure that the database should start first and then application
15) Types of storage class used in your project
16) difference between statefullset and stateless
17) describe kubernetes architecture
18) difference between PV and pvc
19) 2 containers are running inside a pod if one container goes down then will it affect other running container
20)  Update the password in secret without restarting the pod or deployment ,is it possible ?
21) how to rollback the deployment?
22) what is the reason for pod eviction?
22) pod is in pending state ,what are the possible reasons?
23) how you will make sure that in rolling update strategy 2 pods are always available?
24) crashloopbackoff, what are the possible reasons?
25) why you are using 3 master node in production?
26) how you will make sure that pod should be running on a specific node?
27) how to check what are the activities performed by the container while creating the pod
28) how to get the ip of a pod ?
29) which network plugin you are using?
30) how you are monitoring the kubernetes cluster and the containers
31) Job should be terminated after 40 seconds ? ActiveDeadLineSeconds: 40
32) 
==================================================================================
DOCKER :
=============================================================================================

1) difference between add and copy ?
2) difference between CMD and entry point ?
3) ADD . .
4) what is docker file ?
5) how to check how many containers are running ?
6) docker logging driver ?
7) what is difference between bridge network and custom bridge network?
8) difference between  overlay network and host network ?
9) what is port forwarding in docker what is the use of it ? 
10) how to login/enter to a container? 
11) what is docker  system prune and docker image prune?
12) how many types of volumes are there in Docker? (Local and network)
13) How to check image vulnerabilty ? 

AWS:
==============================
1) What is EFS ?
2) how to configure S3 with SDN?
3) s3 lifecycle policy
4) static website hosting using s3
5) Describe your project architecture ?
6) What is private subnet and public subnet?
7) what is NAT gateway ?  other way , No one can access the database server from internet but from database server we can download the patch?
8) can we mount s3 on ec2 instance?
9) can we make s3 bootable?
10) what are routing policy in rout53?
12) how to take snapshots of a rds database in every 3 hours?
13) how to get the public ips of all ec2 instance under a single user acount ?
14) user's are complaing they are not able to access the server ,what is approach to fix this ?
15) differnece between security group and NACL?

Terraform:
===========================
1) What is statefile and what is the use of it ?
2) where you are keeping the statefile ?
3) how to declare a varible ?
4) what is the difference between provisioner and provider?
5) how pass a value from one resource block to another ?
6) how to reuse a module?
7) what is the differnece between Terrform init and terraform apply?
8) how to validate the the terraform file ?
9) what terraform plan does?
10) how to create 10 ec2 instance using the same script ? ( count= 10) 
11) By mistake if you downgrade the instance from t2.large to t2.micro ,then what will happen when you run the terraform script?

===================================================================
Jenkins:
==========================================
1) What is CI and CD flow of your project?
2) your jenkis job should run onc

Kubernates more interview questions


How is Kubernetes related to Docker?
What is Container Orchestration?
What are the features of Kubernetes?
How does Kubernetes simplify containerized Deployment?
What is Google Container Engine?
What is Heapster?
What is Minikube?
What is Kubectl?
What is the syntax for the Kube-proxy command?
What is the syntax for the Kubectl command?
What is Kubelet?
What are the different components of Kubernetes Architecture?
What do you understand by Kube-proxy?
What is the Kubernetes controller manager?
What are the different types of controller manager running on the master node?
What is ETCD?
What do you understand by load balancer in Kubernetes?
Write a command to create and fetch the deployment.
What is Ingress network?
What do you understand by Cloud controller manager?
What are the different types of cloud controller manager?
What is a Headless Service?
What are federated clusters?
What is a pod?
What is the difference between a daemonset, a deployment, and a replication controller?
What is a sidecar container, and what would you use it for?
How can you separate resources?
What are K8s?
What is a node in Kubernetes?
What does the node status contain?
What process runs on Kubernetes Master Node?
What is the job of the kube-scheduler?
What is a cluster of containers in Kubernetes?
What is a Namespace in Kubernetes?
Name the initial namespaces from which Kubernetes starts?
What are the different services within Kubernetes?
What is ClusterIP?
What is NodePort?
What is Kube-proxy?
How can you get a static IP for a Kubernetes load balancer?
What is the difference between config map and secret?
If a node is tainted, is there a way to still schedule the pods to that node?
Can we use many claims out of a persistent volume?
What is Kube-proxy?
What are the tools that are used for container monitoring?
What are the important components of node status?
What is minikube?
Explain Prometheus in Kubernetes.
List tools for container orchestration.
Define Stateful sets in Kubernetes.
Explain Replica set.
Why uses Kube-apiserver?
Explain the types of Kubernetes pods.
What are the labels in Kubernetes?
What is Sematext Docker Agent?
Define OpenShift.
What is ContainerCreating pod?
What do you mean by Persistent Volume Claim?
What will happen while adding new API to Kubernetes?
How do you make changes in the API?
What is kubectl drain?
Define Autoscaling in Kubernetes.
What is the “Master”?
What is a Swarm in Docker?
What is Kubernetes Log?
What are the types of Kubernetes Volume?
Explain PVC.
What is the Kubernetes Network Policy?

Git and Git hub Interview Questions

1. What is git?
2. What is difference between git and GitHub and GitLab?
3. Any other version control tools other than git?
4. What is difference between svn and git?
5. What is merge conflicts have you faced ever in you experience? if you face how you
resolve?
6. What is git stash?
7. What is git HEAD?
8. What is staging area in git?
9. What is difference between git fetch and pull and clone?
10. What is difference between git merge and rebase?
11. What is .gitignore file? What is the purpose of the file?
12. What is git branch? Have you worked on branches?
13. How to merge branches?
14. What is cherry-pick in git?
15. How to create a git project?
16. How to check difference in between two files?
17. How edit the committed message?
18. How to check the last few commits?
19. How to delete remote branch and local branch?
20. How to create local branch?
21. What is tag? How many types in tag? How we will create tags?
22. How to roll back committed code.
23. Git branch strategy
24. How to check the difference in file between working are and staging area ?

Thursday, May 20, 2021

Kubernetes real- time interview questions

1. how you do setup Kubernetes cluster
2. what are the components in master node
3. what are the component in slave
4. what is pod
5. what is replicaset object
6. what is deployment object
7. what is service object
8. what is difference between deployment and service
9. if pod exceed memory what error will get
10. what is namespace
11. how to communicate from one namespace pod to another namespace pod
12. what is init contianer
13. what is difference between pod and container
14. how many containers can ran i single pod
15. what is secret object
16. what is difference between secret vs configmaps
17. what is daemonset
18. what is scheduler
19. how to run a pod on a particular node
20. what is persistence volume and persistence volume claim
21. what is ambassador container
22. how many service types we have in Kubernetes
23. what is default service type
24. what is difference between ingress and load balancer
25. how to schedule pod in Kubernetes
26. how many masters are there in your cluster
27. what is controller manager
28. what is kubeproxy will do
29. what is controller manager will do
30. what is purpose of api server

31. how to troubleshoot if pod is not running
32. how to scale your pods though the command
33. how to rollback previous version
34. Kubernetes upgrade from one version to another version if certification will expire
35. etcd back and restore how to create a new Kubernetes cluster
36. recent issue in Kubernetes
37. node affinity and pod affinity
38. application has domain external communication how to validate your domain from ingress
39. how do you know about in NACL
40. pod security policy for your container
41. how to add new nodes in cluster
42. what is node port range
spinnaker
helm chart
argocd
eks
kops
kubeadm
EphemeralContainers
aws
---
https://kubernetes.io/docs/concepts/services-networking/

https://kubernetes.io/docs/reference/kubernetes-api/workloads-resources/pod-v1/
https://kubernetes.io/blog/2015/06/the-distributed-system-toolkit-patterns/

Wednesday, May 19, 2021

SPFX

 

SharePoint Framework (SPFx) development environment Setup step by step

 

In this tutorial, we’ll learn about how to set up the development environment for the SharePoint framework aka SPFx. Before that, we should know what is SharePoint framework or SPFx – These days, it is a buzz word in the Sharepoint market, in the long run, SPFx is the way to go when it comes to customizing the SharePoint solution as Microsoft does not recommend to use any javascript directly into the SharePoint Online page, in fact by the design out of the box the script editor web part is disabled. The definition from MSDN as – The SharePoint Framework (SPFx) is a page and web part model that provides full support for client-side SharePoint development, easy integration with SharePoint data, and support for open source tooling. With the SharePoint Framework, we can use modern web technologies like React JS, Angular JS, etc.  The SharePoint Framework works for SharePoint Online both for classic and modern experience and also for on-premises (SharePoint 2016 Feature Pack 2 and SharePoint 2019). Step by step process to set up the SharePoint Framework (SPFx) development machine: Now, I will explain how to set up the development environment for the SharePoint Framework (SPFx) for your development environment. In just 5 steps, we can prepare the development environment for SPFx – we just need to install the below tools or Softwares one by one:

  1. Install NodeJS
  2. Install Code editor
  3. Install Yeoman and gulp
  4. Install Yeoman SharePoint generator
  5. Trusting the self-signed developer certificate