Kyndryl Interview Questions, Process, and Tips

Extract India players from a dictionary using list comprehension

• Use list comprehension to filter out players with nationality as 'India'

• Create a new list with only the India players

• Example: [player for player, nationality in CSK.items() if nationality == 'India']

Use sets to find common elements in three lists.

• Convert the lists to sets for efficient comparison.

• Use the intersection method to find common elements.

• Return the common elements as a set or list.

Printing specific rows from a database using Pandas in Python

• Use Pandas library to read the database into a DataFrame

• Use iloc method to select specific rows by index

• Print the selected rows

Use scikit-learn library to split dataset into train, test, and validation sets

• Import train_test_split from sklearn.model_selection

• Specify test_size and validation_size when splitting the dataset

• Example: X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=42)

Use DISTINCT keyword to print unique values and DELETE with a subquery to remove duplicate rows.

• Use SELECT DISTINCT column_name FROM table_name to print unique values.

• Use DELETE FROM table_name WHERE row_id NOT IN (SELECT MAX(row_id) FROM table_name GROUP BY column_name) to delete duplicate rows.

Use SQL SELECT statement with WHERE clause to filter rows based on a specific criterion.

• Use SELECT statement with WHERE clause to specify the criterion (ex: salary > 100000)

• Example: SELECT * FROM employees WHERE salary > 100000;

• Ensure proper syntax and column names are used in the query

Use subquery to find rows with second highest criterion value in SQL without using offset function.

• Use a subquery to find the maximum criterion value

• Then use another subquery to find the maximum value that is less than the maximum value found in the first subquery

• Finally, select rows with the second highest criterion value

Print rows with the same set of values in a column

• Identify unique sets of values in the column

• Group rows based on these unique sets of values

• Print out the rows for each unique set of values

Power BI is a Microsoft product focused on business intelligence and data visualization, while Tableau is a standalone data visualization tool.

• Power BI is more user-friendly and integrates well with other Microsoft products.

• Tableau is known for its powerful data visualization capabilities and flexibility in creating complex visualizations.

• Power BI is often preferred by organizations already using Microsoft products, wh...read more

Power BI and Tableau have limitations in terms of data connectivity, customization, and pricing.

• Limited data connectivity options compared to other tools

• Limited customization capabilities for advanced analytics

• High pricing for enterprise-level features

• Tableau has better visualization capabilities but can be more complex to use

• Power BI is more user-friendly but may lack certain advanced features

Types of regression models include linear regression, logistic regression, polynomial regression, ridge regression, and lasso regression.

• Linear regression: used to model the relationship between a dependent variable and one or more independent variables.

• Logistic regression: used for binary classification problems, where the output is a probability value between 0 and 1.

• Polynomial regression: fits a curve to the data by...read more

Linear regression is used for continuous variables, while logistic regression is used for binary outcomes.

• Linear regression predicts continuous outcomes, while logistic regression predicts binary outcomes.

• Linear regression uses a linear equation to model the relationship between the independent and dependent variables.

• Logistic regression uses the logistic function to model the probability of a binary outcome.

• Linear reg...read more

Random Forest is an ensemble method using multiple decision trees, while Decision Tree is a single tree-based model.

• Random Forest is a collection of decision trees that are trained on random subsets of the data.

• Decision Tree is a single tree structure that makes decisions by splitting the data based on features.

• Random Forest reduces overfitting by averaging the predictions of multiple trees.

• Decision Tree can be prone t...read more

ETL stands for Extract, Transform, Load. It is a process of extracting data from various sources, transforming it into a usable format, and loading it into a target database.

• ETL tools include Informatica PowerCenter, Talend, Apache Nifi, Microsoft SQL Server Integration Services (SSIS), and IBM InfoSphere DataStage.

• Extract: Data is extracted from various sources such as databases, files, APIs, etc.

• Transform: Data is cl...read more

Cybersecurity is the practice of protecting systems, networks, and data from digital attacks and unauthorized access.

• Involves measures to safeguard information technology assets.

• Includes practices like encryption, firewalls, and intrusion detection systems.

• Examples of threats include malware, phishing, and ransomware attacks.

• Cybersecurity is crucial for protecting sensitive data in sectors like finance and healthcare.

The current version of Microsoft Windows Server is Windows Server 2019. Hyper-V is a virtualization platform. Active Directory is a directory service. DNS is a system that translates domain names to IP addresses. DHCP is a network protocol that assigns IP addresses to devices. WSUS is Windows Server Update Services. The current version of client Windows operating system is Windows 10.

• Windows Server 2019 is the latest v...read more

VMware vSphere is a virtualization platform that provides virtualization, management, resource optimization, and more.

• DRS (Distributed Resource Scheduler) in VMware is a feature that automatically balances computing workloads across a cluster of ESXi hosts.

• High availability in VMware ensures that virtual machines are restarted on another host in case of a host failure.

• Fault Tolerance in VMware provides continuous avail...read more

Microsoft Azure Cloud is a cloud computing service provided by Microsoft, offering a variety of services and resources for building, deploying, and managing applications.

• Provides infrastructure as a service (IaaS), platform as a service (PaaS), and software as a service (SaaS) offerings

• Offers services such as virtual machines, databases, AI and machine learning tools, and more

• Allows for scalability, flexibility, and co...read more

FSMO stands for Flexible Single Master Operations. They are specialized roles in Active Directory that handle specific tasks.

• There are 5 FSMO roles: Schema Master, Domain Naming Master, RID Master, PDC Emulator, and Infrastructure Master.

• Each FSMO role is responsible for a specific aspect of the Active Directory environment.

• For example, the PDC Emulator role handles password changes and time synchronization within a do

Service Delivery involves providing services to customers in a timely and efficient manner.

• Service Delivery focuses on meeting customer needs and expectations

• It involves ensuring services are delivered on time and within budget

• Service Delivery often includes managing relationships with customers and stakeholders

• Examples of Service Delivery include IT support, logistics, and customer service

Incident is an unplanned event that disrupts or degrades a service, while Problem is the underlying cause of one or more incidents.

• Incident is a specific event that causes an interruption or reduction in the quality of a service.

• Problem is the root cause of one or more incidents and is identified through the analysis of incidents.

• Incidents are typically resolved quickly to restore service, while problems require invest...read more

I prioritize tasks, stay organized, communicate effectively, and remain calm to manage work under pressure.

• Prioritize tasks based on urgency and importance

• Stay organized by creating to-do lists and setting deadlines

• Communicate effectively with team members and stakeholders to manage expectations

• Remain calm by taking deep breaths and focusing on solutions rather than problems