NTT Global Data Centers and Cloud Infrastructure Senior Information Security Analyst Interview Questions, Process, and Tips

Prepare well on basics of SQL, Python and Machine learning

Q1. Prior experiences, Future growth, case studies
Add your answer

Q1. Python SQL spark AWS and big data
Add your answer
Q2. Python SQL pyspark aws
Add your answer

Q1. How random forest decides the variables
Ans. 
Random forest decides variables based on feature importance and information gain.
• Random forest calculates feature importance by measuring how much the tree nodes that use a particular feature reduce impurity.

• Variables with higher feature importance are considered more important in making predictions.

• Random forest also uses information gain to decide which variables to split on at each node in the trees.

• The variables th...read more
Answered by AI
Add your answer
Q2. We need to use gini index for variable selection
Ans. 
Gini index is a measure of impurity used in decision trees for variable selection.
• Gini index ranges from 0 (pure node) to 0.5 (impure node)

• Variables with lower Gini index are preferred for splitting

• Higher Gini index indicates higher impurity and less predictive power
Answered by AI
Add your answer

Q1. SQL queries scenario based
Add your answer
Q2. Just gave schema and asked 5 questions.
Add your answer

Logical Reasoning, Comprehension

General discussion on current affairs

Q1. C++ coding questions
Add your answer

Q1. PowerApps and PowerBI related questions
Add your answer

Q1. High level scenerio based analytical questions
Add your answer

Q1. Basic ml qiestions
Add your answer

Q1. Ml related questions
Add your answer

Q1. Write a query to obtain the third transaction of every user
Ans. 
Query to retrieve the third transaction of every user
• Use a subquery to rank the transactions for each user

• Filter the results to only include the third transaction for each user
Answered by AI
Add your answer
Q2. Write a query that outputs the name of the credit card and how many cards are issued in it's launch month
Ans. 
Query to output the name of credit card and number of cards issued in launch month
• Use GROUP BY to group by launch month

• Count the number of cards issued in each launch month

• Select the name of the credit card and the count of cards issued
Answered by AI
Add your answer