Find Interview Questions for Fingent

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:
I use tools like Microsoft Project, Trello, Asana, Jira, and Gantt charts to monitor and control projects. Additionally, I utilize dashboards and reporting tools for tracking progress and performance.

Right Answer:
I inform all stakeholders of the project's progress through regular status reports, scheduled meetings, and updates via email or project management tools. This ensures everyone is aligned and aware of any changes or issues.

Right Answer:
No, it is not advisable to put all the reinforcing steel at the top of the beam because beams primarily experience bending moments that cause tension at the bottom and compression at the top. Placing all the steel at the top would not effectively resist the tensile forces, leading to structural failure.

Right Answer:
Effort variance is the difference between the planned effort (the amount of work estimated) and the actual effort (the amount of work completed) in a project. It helps assess whether a project is on track in terms of the resources allocated versus what has been used.

Right Answer:
Yes, there are distinct kinds of activities in a project, typically categorized as:

1. **Initiation Activities** - Defining the project and obtaining approval.
2. **Planning Activities** - Developing the project plan, including scope, schedule, and resources.
3. **Execution Activities** - Implementing the project plan and delivering the project outputs.
4. **Monitoring and Controlling Activities** - Tracking progress and making adjustments as needed.
5. **Closing Activities** - Finalizing all project work and formally closing the project.

Right Answer:
CORS, or Cross-Origin Resource Sharing, is a security feature implemented by web browsers that allows or restricts web applications from making requests to a domain different from the one that served the web page. It affects API development by requiring developers to configure their APIs to specify which origins are allowed to access their resources, ensuring that only trusted domains can interact with the API.

Right Answer:
GET is used to retrieve data from a server, POST is used to send data to a server to create a resource, PUT is used to update an existing resource on the server, and DELETE is used to remove a resource from the server.

Right Answer:
HTTP methods are standardized request types used in APIs to perform actions on resources. The main methods are:

1. **GET**: Retrieve data from a server.
2. **POST**: Send data to a server to create a new resource.
3. **PUT**: Update an existing resource on the server.
4. **DELETE**: Remove a resource from the server.
5. **PATCH**: Apply partial modifications to a resource.

These methods define the action to be performed on the specified resource in the API.

Right Answer:
API authentication is the process of verifying the identity of a user or application trying to access an API. Common methods include:

1. **API Keys**: Unique keys provided to users to access the API.
2. **Basic Authentication**: Uses a username and password encoded in Base64.
3. **OAuth**: A token-based authentication method that allows users to grant limited access to their resources without sharing credentials.
4. **JWT (JSON Web Tokens)**: A compact, URL-safe means of representing claims to be transferred between two parties, often used for stateless authentication.
5. **HMAC (Hash-based Message Authentication Code)**: Uses a secret key to create a hash of the request, ensuring data integrity and authenticity.

Right Answer:
The different types of APIs are:

1. **Open APIs (Public APIs)** - Available to developers and third parties.
2. **Internal APIs (Private APIs)** - Used within an organization.
3. **Partner APIs** - Shared with specific business partners.
4. **Composite APIs** - Combine multiple endpoints into a single call.
5. **Web APIs** - Accessible over the internet using HTTP/HTTPS.

Right Answer:
```sql
CREATE PROCEDURE GetEmployeeByID
@EmployeeID INT
AS
BEGIN
SELECT * FROM Employees
WHERE EmployeeID = @EmployeeID;
END;
```