Preview Questions Data Analyst | Role Specific Skill

Question 1: What is the primary purpose of using stored procedures in a database for financial reporting?

Which action should you take?

Choose only one option

To store raw data

To manage database security

To automate repetitive data operations

To optimize query execution plans

Question 2: How would you handle schema changes in a live production database with minimal downtime in a financial institution?

Which action should you take?

Choose only one option

Use database versioning and revert to older schemas if needed

Use online schema changes or rolling migrations

Drop the old schema and rebuild the database from scratch

Perform schema changes during system maintenance windows

Question 3: In the context of BFSI, which statistical test is most appropriate for comparing the means of loan approval rates between two different branches of a bank?

Which action should you take?

Choose only one option

ANOVA

Independent Samples t-Test

Chi-Square Test

Mann-Whitney U Test

Question 4: For visualizing the distribution of loan amounts across different customer categories, which chart would provide the clearest insight?

Which action should you take?

Choose only one option

Box plot

Histogram

Bar chart

Line chart

Question 5: Which method is most suitable for handling missing data in large-scale financial datasets to ensure robust statistical analysis?

Which action should you take?

Choose only one option

Listwise Deletion

Pairwise Deletion

Multiple Imputation

Mean Imputation

Question 6: When optimizing a database for financial transactions in BFSI, which index type would be most effective for fast lookups of customer records by their loan account number?

Which action should you take?

Choose only one option

Full-text index

B-tree index

Hash index

Bitmap index