Delta Air Lines Interview Questions and Answers

5 sections of mcqs and one dsa question

Q1. Project discussion
Add your answer
Q2. Tech stack related questions
Add your answer

Q1. Java , spring boot based questions
Add your answer
Q2. Project based questions
Add your answer

Q1. Explain how did you handle the imbalance in data
Ans. 
I handled data imbalance by using techniques like oversampling, undersampling, SMOTE, or using ensemble methods.
• Used oversampling to increase minority class instances

• Used undersampling to decrease majority class instances

• Applied SMOTE (Synthetic Minority Over-sampling Technique) to generate synthetic samples for minority class

• Utilized ensemble methods like Random Forest or Gradient Boosting to handle imbalance
Answered by AI
Add your answer
Q2. Write a sql query for the given problem statement. Can be solved using advanced concepts like lead and lag
Ans. 
SQL query using LEAD and LAG to analyze sequential data in a dataset.
• LEAD() retrieves the next row's value in a result set, useful for comparing current and future values.

• LAG() retrieves the previous row's value, allowing for comparisons with past data.

• Example: To find the difference in sales between consecutive months, use LAG(sales) to get last month's sales.

• Combining LEAD and LAG can help identify trends over time, ...read more
Answered by AI
Add your answer

Advanced sql and basics of data science

Multiple programming languages ex python, JavaScript, Java, Cloud formation

Q1. What are the aws services worked on
Ans. 
I have worked on various AWS services including EC2, S3, RDS, Lambda, and CloudFormation.
• EC2

• S3

• RDS

• Lambda

• CloudFormation
Answered by AI
Add your answer
Q2. Tell about troubleshooting skills in aws
Ans. 
Troubleshooting skills in AWS involve identifying and resolving issues with cloud services and infrastructure.
• Ability to analyze logs and metrics to identify root causes of issues

• Experience with AWS monitoring tools like CloudWatch and X-Ray

• Knowledge of AWS service limits and best practices for optimizing performance

• Familiarity with AWS support options and escalation procedures
Answered by AI
Add your answer
Q3. What is the approach if you get new task
Ans. 
I prioritize tasks based on deadlines, complexity, and impact on overall project goals.
• Assess the deadline for the task and prioritize accordingly

• Evaluate the complexity of the task and allocate resources accordingly

• Consider the impact of the task on the overall project goals
Answered by AI
Add your answer

Q1. Aws architect level
Ans. 
An AWS architect level question
• Understand the AWS Well-Architected Framework

• Have experience designing scalable and cost-effective AWS solutions

• Familiarity with various AWS services like EC2, S3, RDS, etc.
Answered by AI
Add your answer
Q2. What is the recent aws services you used
Ans. 
I have recently used AWS Lambda, AWS S3, and AWS RDS services.
• AWS Lambda for serverless computing

• AWS S3 for object storage

• AWS RDS for managed relational databases
Answered by AI
Add your answer
Q3. Explain the services how you used in your application in recently
Add your answer
Q4. What is Aws lambda and how will you communicate to s3 in cross account
Ans. 
AWS Lambda is a serverless computing service that runs code in response to events and automatically manages the computing resources required.
• AWS Lambda is event-driven and allows you to run code without provisioning or managing servers.

• To communicate with S3 in a cross-account scenario, you can use IAM roles and policies to grant necessary permissions.

• Create a role in the account where the Lambda function resides with ...read more
Answered by AI
Add your answer
Q5. What is the best approach to cost optimization
Ans. 
The best approach to cost optimization involves identifying inefficiencies, prioritizing cost-saving opportunities, and implementing strategic solutions.
• Conduct a thorough analysis of current expenses to identify areas of inefficiency

• Prioritize cost-saving opportunities based on potential impact and feasibility

• Implement strategic solutions such as renegotiating contracts, optimizing processes, or investing in technolog...read more
Answered by AI
Add your answer
Q6. What is aws landing zones and control tower
Ans. 
AWS Landing Zones and Control Tower are AWS solutions for setting up and managing secure, multi-account AWS environments.
• AWS Landing Zones is a solution that helps customers set up a secure, multi-account AWS environment based on AWS best practices.

• AWS Control Tower is a service that provides the easiest way to set up and govern a secure, multi-account AWS environment based on AWS best practices.

• Both Landing Zones and ...read more
Answered by AI
Add your answer
Q7. How will it work control tower and landing zones
Ans. 
Control towers manage air traffic and guide planes to designated landing zones.
• Control towers communicate with pilots to provide instructions for takeoff, landing, and taxiing.

• Landing zones are designated areas on the runway where planes touch down and come to a stop.

• Control towers use radar and communication systems to monitor and coordinate the movement of aircraft.

• Efficient communication and coordination between con...read more
Answered by AI
Add your answer
Q8. How transit gate ways work
Ans. 
Transit gateways are network devices that connect different networks and control the flow of traffic between them.
• Transit gateways act as a bridge between different networks, such as connecting an on-premises network to a cloud network.

• They enforce security policies and perform routing functions to direct traffic to the appropriate destination.

• Transit gateways can also provide network address translation (NAT) services...read more
Answered by AI
Add your answer

Q1. Why do you want join Delta Airlines
Add your answer
Q2. What is your expectation from Delta Airlines
Add your answer
Q3. What is your strength
Ans. 
My strength lies in my problem-solving skills, adaptability, and ability to collaborate effectively with diverse teams.
• Strong analytical skills: I successfully optimized a complex algorithm, improving processing speed by 30%.

• Adaptability: I quickly learned a new programming language to meet project deadlines, resulting in a successful product launch.

• Collaboration: I led a cross-functional team to deliver a project ahea...read more
Answered by AI
Add your answer

Q1. Explain RANKX function in power bi
Ans. 
RANKX function in Power BI is used to calculate the ranking of a value in a specified column.
• RANKX function assigns a rank to each row in a table based on a specified expression.

• It can be used to rank sales performance, customer satisfaction scores, etc.

• Syntax: RANKX(table, expression, [value], [order], [ties])

• Example: RANKX(Sales, Sales[Revenue], , DESC, Dense)
Answered by AI
Add your answer