Find Interview Questions for Transparent value

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:
The different types of data analysis are:

1. Descriptive Analysis
2. Diagnostic Analysis
3. Predictive Analysis
4. Prescriptive Analysis
5. Exploratory 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:
1. Remove duplicates
2. Handle missing values
3. Correct inconsistencies
4. Standardize formats
5. Filter out irrelevant data
6. Validate data accuracy
7. Normalize data if necessary

Right Answer:
The different types of data distributions include:

1. Normal Distribution
2. Binomial Distribution
3. Poisson Distribution
4. Uniform Distribution
5. Exponential Distribution
6. Log-Normal Distribution
7. Geometric Distribution
8. Beta Distribution
9. Chi-Squared Distribution
10. Student's t-Distribution

Right Answer:
To remove duplicate records from a table in SQL Server, you can use a Common Table Expression (CTE) with the `ROW_NUMBER()` function. Here’s an example query:

```sql
WITH CTE AS (
SELECT *,
ROW_NUMBER() OVER (PARTITION BY column1, column2 ORDER BY (SELECT NULL)) AS rn
FROM your_table
)
DELETE FROM CTE WHERE rn > 1;
```

Replace `column1`, `column2` with the columns that define duplicates, and `your_table` with the name of your table.

Right Answer:
Subscriber Identity Module

Right Answer:
The area of the curved surface of the cone is 125.6 m².

Right Answer:
The number of leaves applicable as per the Worker Act varies by country and specific legislation, but typically includes provisions for annual leave, sick leave, and public holidays. Please specify the country for a precise answer.

Right Answer:
Gold loans are secured loans where gold jewelry or ornaments are used as collateral, while business loans are unsecured or secured loans specifically intended for business purposes, often based on the creditworthiness of the business.

Right Answer:
Finance is the management of money, including the processes of acquiring, investing, and managing funds to achieve financial goals.