SCS Tech Interview Questions and Answers

Q1. Explain any 1 of your Project.
Add your answer
Q2. SQL: Explain difference between Delete, Truncate and Drop. Difference between Group by and Having. Asked to write a update query.
Add your answer
Q3. Python: Difference between Set and Dictionary. Can we update key in dictionary? Write solution for given python question (nums = [1,2,3,4,5,7,10] target = 9 output = [1,5])
Ans. 
Set is a collection of unique elements, while dictionary is a collection of key-value pairs. Keys in dictionary can be updated.
• Set does not allow duplicate elements, while dictionary allows duplicate values but not duplicate keys.

• Dictionary uses key-value pairs for storing data, while set only stores individual elements.

• Example: Set - {1, 2, 3}, Dictionary - {'a': 1, 'b': 2}

• Yes, keys in dictionary can be updated by ass
Answered by AI
Add your answer

Q1. Explain projects where you have implemented ETL. Difference between aws lambda and aws glue
Add your answer
Q2. Non-Technical questions
Add your answer

Q1. How many EBS can be attached to single EC2
Ans. 
The maximum number of EBS volumes that can be attached to a single EC2 instance is 40.
• Maximum of 40 EBS volumes can be attached to a single EC2 instance

• Each EBS volume can be up to 16 TiB in size

• EBS volumes can be attached and detached while the instance is running
Answered by AI
Add your answer
Q2. Prerequisites for S3 Cross Region Replication
Ans. 
Prerequisites for S3 Cross Region Replication include enabling versioning, configuring IAM roles, and ensuring proper bucket policies.
• Enable versioning on both source and destination buckets

• Configure IAM roles with proper permissions for replication

• Ensure proper bucket policies are in place for cross region replication
Answered by AI
Add your answer
Q3. Docker Restart will change which attributes of comtainer
Ans. 
Docker Restart changes the container's attributes like IP address, hostname, and uptime.
• IP address of the container will change after restart

• Hostname of the container may change

• Uptime of the container will be reset

• Any changes made to the container's filesystem will be lost
Answered by AI
Add your answer
Q4. S3 vs EFS scenario based use cases.
Ans. 
S3 is ideal for storing static files like images and videos, while EFS is better for shared file storage among multiple EC2 instances.
• S3 is object storage, suitable for storing large amounts of unstructured data like images, videos, backups, and logs.

• EFS is a file storage service that can be mounted on multiple EC2 instances, making it ideal for shared file systems and databases.

• Use S3 for static website hosting, data ...read more
Answered by AI
Add your answer
Q5. Linux Commands and Chmod Calculation
Add your answer

It included mcqs and multiple coding questions.

Q1. Yours technical skillls related questions
Add your answer
Q2. Managerial questions
Add your answer

OOPS , DBMS , OS , and DSA concepts

Q1. DBMS related concepts
Add your answer
Q2. Networking and Network Security
Add your answer