Find Interview Questions for Mnc

Right Answer:
Some common data analysis tools and software include:

1. Microsoft Excel
2. R
3. Python (with libraries like Pandas and NumPy)
4. SQL
5. Tableau
6. Power BI
7. SAS
8. SPSS
9. Google Analytics
10. Apache Spark

Right Answer:
To handle missing data in a dataset, you can use the following methods:

1. **Remove Rows/Columns**: Delete rows or columns with missing values if they are not significant.
2. **Imputation**: Fill in missing values using techniques like mean, median, mode, or more advanced methods like KNN or regression.
3. **Flagging**: Create a new column to indicate missing values for analysis.
4. **Predictive Modeling**: Use algorithms to predict and fill in missing values based on other data.
5. **Leave as Is**: In some cases, you may choose to leave missing values if they are meaningful for analysis.

Right Answer:
A pivot table is a data processing tool that summarizes and analyzes data in a spreadsheet, like Excel. You use it by selecting your data range, then inserting a pivot table, and dragging fields into rows, columns, values, and filters to organize and summarize the data as needed.

Right Answer:
Regression analysis is a statistical method used to examine the relationship between one dependent variable and one or more independent variables. It is used to predict outcomes, identify trends, and understand the strength of relationships in data.

Right Answer:
Exploratory Data Analysis (EDA) is the process of analyzing and summarizing datasets to understand their main characteristics, often using visual methods. It helps identify patterns, trends, and anomalies in the data before applying formal modeling techniques.

Right Answer:
Rate limiting in APIs is a technique used to control the number of requests a user can make to an API within a specific time period. It is implemented by setting thresholds (e.g., requests per minute) and using mechanisms like tokens, counters, or IP address tracking to monitor and restrict access when the limit is exceeded.

Right Answer:
API documentation is a technical manual that explains how to use an API, including its endpoints, request and response formats, authentication methods, and examples. It is necessary because it helps developers understand how to integrate and interact with the API effectively, ensuring proper usage and reducing errors.

Right Answer:
An API endpoint is a specific URL or URI where an API can be accessed by a client to perform operations like retrieving or sending data. It defines the location and method (such as GET, POST) for interacting with the API.

Right Answer:
Webhooks are user-defined HTTP callbacks that are triggered by specific events in a web application, allowing real-time data transfer. They differ from APIs in that APIs require a request to be made to receive data, while webhooks automatically send data when an event occurs without needing a request.

Right Answer:
OAuth is an open standard for access delegation commonly used for token-based authentication and authorization. It allows third-party applications to access a user's resources without sharing their credentials.

In API authentication, OAuth works by having the user authorize the application to access their data. The process involves:

1. The user is redirected to an authorization server to log in and grant permission.
2. The authorization server issues an access token to the application.
3. The application uses this access token to make API requests on behalf of the user.
4. The API validates the token and grants access to the requested resources.

Right Answer:
The role of test engineers is to design, implement, and execute tests to ensure software quality, identify defects, and verify that the software meets specified requirements before it is released.

Right Answer:
Working capital is the difference between a company's current assets and current liabilities, indicating the short-term financial health and operational efficiency of the business.

Right Answer:
To depict dependency in MS Project, you can link tasks by selecting the tasks you want to connect, then clicking on the "Link Tasks" button in the toolbar or using the shortcut Ctrl + F2. This creates a finish-to-start dependency by default. You can also adjust the type of dependency (finish-to-start, start-to-start, finish-to-finish, or start-to-finish) by double-clicking on the task and modifying the "Predecessors" tab.

Right Answer:
Yes, banks face significant challenges from money laundering when attracting deposits. Money laundering can lead to reputational damage, regulatory penalties, and financial losses. Banks must implement strict compliance measures and due diligence processes to detect and prevent illicit activities, which can complicate their efforts to attract legitimate deposits.

Right Answer:
MS Project is used for project management to plan, schedule, and track project progress, allocate resources, manage budgets, and analyze workloads.

Right Answer:
BRD (Business Requirements Document) outlines the high-level business needs and objectives. SRS (Software Requirements Specification) details the functional and non-functional requirements for the software. Use Case documents describe specific interactions between users and the system to achieve particular goals.