Preview Questions Data Analyst | Role Specific Skill

Question 1: What is the most appropriate way to document the steps of data preparation and cleaning in a BFSI data analysis report?

Which action should you take?

Choose only one option

Not needed if the data is clean

In the main report body under methodology

In the appendix with references to the main body

As an external document

Question 2: When analyzing credit card transaction data, which SQL window function is best suited to calculate the running total of transactions per customer over time?

Which action should you take?

Choose only one option

ROW_NUMBER()

SUM() OVER (PARTITION BY CustomerID ORDER BY TransactionDate)

COUNT() OVER (PARTITION BY CustomerID)

RANK()

Question 3: How do you ensure that identified financial trends are not a result of overfitting, especially when using complex models?

Which action should you take?

Choose only one option

I assume that if a model fits the training data well, the trend is valid

I apply cross-validation techniques and use simpler models to check for overfitting, ensuring the trend is generalizable

I use the most complex model and assume it represents the true trend

I focus on short-term data and ignore the possibility of overfitting

Question 4: When assessing financial stability using financial ratios, how do you interpret the "Quick Ratio" and what threshold indicates liquidity risk?

Which action should you take?

Choose only one option

A quick ratio above 1.5 suggests high risk of bankruptcy

A quick ratio below 1.0 suggests the company is highly liquid and stable

A quick ratio below 2.0 is acceptable for most businesses

A quick ratio below 1.0 indicates liquidity risk as the company may not have enough liquid assets to cover current liabilities

Question 5: How should a data analyst handle inconsistent column names in a dataset that comes from multiple sources?

Which action should you take?

Choose only one option

Use a script to automatically standardize column names

Drop all columns with inconsistent names

Ignore the inconsistencies and proceed with analysis

Rename all columns manually to be consistent

Question 6: When performing a chi-square test in BFSI, which of the following is required?

Which action should you take?

Choose only one option

The dependent variable must be continuous

The sample size should be less than 30

Observations must be independent of each other

Data must be normally distributed