Deloitte Interview Questions, Process, and Tips

Q1. How can we connection between 2 EC2 instance
Ans. 
You can connect between 2 EC2 instances by using their private IP addresses or public DNS names.
• Use private IP addresses for communication within the same VPC

• Use public DNS names for communication across different VPCs or over the internet
Answered by AI
Add your answer
Q2. How do you connections between public subnet and private subnet.
Ans. 
Connections between public and private subnets are established using a NAT gateway or a NAT instance.
• Use a NAT gateway to allow instances in a private subnet to initiate outbound traffic to the internet while preventing inbound traffic from reaching those instances.

• Alternatively, use a NAT instance with a security group that only allows inbound traffic from instances in the public subnet.

• Ensure that the route tables fo...read more
Answered by AI
Add your answer

Online Test with 30 Question on SQL and PLSQL. Mostly on Joins , DML, and SQL basic

Q1. What is DenseRank and Partition
Ans. 
DenseRank is a function in SQL that assigns a rank to each row within a partition of a result set.
• DenseRank is used to assign a unique rank to each row within a partition, with no gaps in the ranking.

• It is similar to the Rank function, but it does not skip ranks when there are ties.

• Partitions are used to divide the result set into smaller groups, and DenseRank is applied within each partition.

• For example, if you have a...read more
Answered by AI
Add your answer
Q2. Find Second highest Salary.
Add your answer

Q1. Assumptions of linear regression
Ans. 
Assumptions of linear regression include linearity, independence, homoscedasticity, and normality.
• Linearity: The relationship between the independent and dependent variables is linear.

• Independence: The residuals are independent of each other.

• Homoscedasticity: The variance of the residuals is constant across all levels of the independent variables.

• Normality: The residuals are normally distributed.

• Outliers and influentia
Answered by AI
Add your answer
Q2. If Gini of two models is the same, what alternate measure can you refer to for model performance?
Ans. 
You can refer to other measures like ROC-AUC, precision-recall curve, F1 score, etc.
• ROC-AUC: Receiver Operating Characteristic - Area Under the Curve

• Precision-recall curve: Trade-off between precision and recall

• F1 score: Harmonic mean of precision and recall
Answered by AI
Add your answer

Q1. Cloud computing
Add your answer
Q2. Phising attack , Big data architecture
Add your answer