Find Interview Questions for Actioniq

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:
JSON (JavaScript Object Notation) is a lightweight data interchange format that is easy for humans to read and write, and easy for machines to parse and generate. In APIs, JSON is commonly used to format data exchanged between a client and a server, allowing for structured data representation in requests and responses.

Right Answer:
An API Gateway acts as a single entry point for clients to access multiple microservices, handling requests, routing them to the appropriate services, managing authentication, rate limiting, and aggregating responses.

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:
API versioning is the practice of managing changes to an API by assigning version numbers to different iterations of the API. It is important because it allows developers to introduce new features or make changes without breaking existing client applications that rely on older versions, ensuring backward compatibility and a smoother transition for users.

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.

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:
The fields used for Project Planning in MS Project include:

1. Task Name
2. Duration
3. Start Date
4. Finish Date
5. Predecessors
6. Resources
7. Percent Complete
8. Work
9. Cost
10. Milestones

Right Answer:
To analyze data for different formats like pivot tables and matching datasets, you should:

1. **Identify Key Variables**: Determine the key fields that will be used for matching and pivoting.
2. **Clean the Data**: Ensure that the data is free from duplicates, errors, and inconsistencies.
3. **Use Pivot Tables**: Create pivot tables to summarize and analyze the data by aggregating values based on categories.
4. **Match Data**: Use functions like VLOOKUP or JOIN operations in SQL to match data from different sources based on the identified key variables.
5. **Validate Results**: Check the accuracy of the matched data and the pivot table outputs to ensure they meet business requirements.

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:
The purpose of feature engineering in data analysis is to create, modify, or select variables (features) that improve the performance of machine learning models by making the data more relevant and informative for the analysis.

Right Answer:
Correlation is a statistical measure that indicates the extent to which two variables fluctuate together, while causation implies that one variable directly affects or causes a change in another variable.

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:
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:
**Difference between DWH and Data Mart:**
- A Data Warehouse (DWH) is a centralized repository that stores large volumes of data from multiple sources for analysis and reporting. A Data Mart is a subset of a Data Warehouse, focused on a specific business area or department.

**Difference between Views and Materialized Views:**
- A View is a virtual table that provides a way to present data from one or more tables without storing it physically. A Materialized View, on the other hand, stores the result of a query physically, allowing for faster access at the cost of needing to refresh the data periodically.

**Indexing:**
- Indexing is a database optimization technique that improves the speed of data retrieval operations on a database table. Common indexing techniques include B-tree indexing, hash indexing, and bitmap indexing.

Right Answer:
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. The main types of normalization are:

1. **First Normal Form (1NF)**: Ensures that all columns contain atomic values and each entry in a column is of the same type.
2. **Second Normal Form (2NF)**: Achieves 1NF and ensures that all non-key attributes are fully functionally dependent on the primary key.
3. **Third Normal Form (3NF)**: Achieves 2NF and ensures that all non-key attributes are not only dependent on the primary key but also independent of each other.
4. **Boyce-Codd Normal Form (BCNF)**: A stronger version of 3NF that deals with certain types of anomalies not handled by 3NF.
5. **Fourth Normal Form (4NF)**: Achieves BCNF and addresses multi-valued dependencies.
6. **Fifth Normal Form (5NF)**: Achieves 4

Right Answer:
LIS stands for Laboratory Information System, which is a software system that manages and processes laboratory data, including test orders, results, and patient information.

Right Answer:
Denormalization should be considered when you need to improve read performance, reduce the complexity of queries, or when you have specific reporting requirements that benefit from fewer joins in the database.

Right Answer:
The role of a QA (Quality Assurance) is to ensure that the software meets specified requirements and is free of defects by conducting testing, identifying issues, and verifying that fixes are implemented correctly.