Preview Questions Data Analyst | Role Specific Skill

Question 1: What is the best method to handle financial data that violates expected value ranges (e.g., transactions that are too large or too small)?

Which action should you take?

Choose only one option

Normalize the values to fit within expected ranges

Perform a deeper investigation and report errors

Replace out-of-range values with mean or median

Remove these records entirely

Question 2: Which of the following would be the most effective method for detecting fraud in financial transactions using statistical analysis?

Which action should you take?

Choose only one option

Time series forecasting

Regression analysis

Anomaly detection

Chi-square tests

Question 3: In hypothesis testing, what does a p-value less than 0.05 generally indicate?

Which action should you take?

Choose only one option

Weak evidence to reject the null hypothesis

The test is not valid and should be ignored

Strong evidence to reject the null hypothesis

Strong evidence to accept the null hypothesis

Question 4: Which NoSQL database type is most suitable for handling unstructured data, such as customer interactions and communication logs, in BFSI applications?

Which action should you take?

Choose only one option

Columnar Databases

Document-Oriented Databases

Key-Value Stores

Graph Databases

Question 5: When designing a database schema for loan transactions in BFSI, which of the following relationships should be represented as a one-to-many relationship?

Which action should you take?

Choose only one option

A loan can have many customers

A customer can have many bank branches

A loan can have many repayments

A customer can have many loan applications

Question 6: Which chart type is most suitable for visualizing the distribution of a large financial dataset with multiple variables?

Which action should you take?

Choose only one option

Boxplot

Histogram

Line chart

Heatmap