CRED Interview Questions, Process, and Tips

SQL and metrics based questions

Q1. How would you find the top triplet from data set
Ans. 
To find the top triplet from a data set, sort the data in descending order and select the first three values.
• Sort the data in descending order

• Select the first three values

• Consider ties if applicable
Answered by AI
Add your answer
Q2. Questions around the aptitude test
Add your answer

Q1. Top Metrics for Instagram platform
Ans. 
Top metrics for Instagram platform include engagement rate, reach, impressions, follower growth, and click-through rate.
• Engagement rate measures the level of interaction with your content.

• Reach refers to the number of unique accounts that have seen your content.

• Impressions refer to the total number of times your content has been viewed.

• Follower growth measures the rate at which your follower count is increasing.

• Click-t...read more
Answered by AI
Add your answer
Q2. How would you find the batsmen with fastest 5000 runs
Ans. 
To find the batsmen with fastest 5000 runs, we need to analyze the data of all the batsmen who have scored 5000 runs or more.
• Create a database of all batsmen who have scored 5000 runs or more in their career.

• Sort the database based on the time taken by each batsman to reach 5000 runs.

• Identify the batsman who reached 5000 runs in the shortest time.

• Verify the accuracy of the data and the methodology used to calculate the...read more
Answered by AI
Add your answer
Q3. Which is better. 5% discount to get 30% increase in trips or 10% discount to get 50% increase in trips or 15% discount to get 65% increase in trips, considering avg trip value is constant
Ans. 
15% discount to get 65% increase in trips is the best option.
• The percentage increase in trips is directly proportional to the discount offered.

• The increase in trips should be weighed against the decrease in revenue due to the discount.

• In this case, the 15% discount offers the highest increase in trips while still maintaining a reasonable revenue.

• It is important to consider the long-term effects of offering discounts on
Answered by AI
Add your answer

Build a typeahead component

Q1. Build a form for personal details
Ans. 
Build a form for personal details
• Include fields for name, email, phone number, address, date of birth

• Use input fields, dropdowns, and date pickers for user input

• Add validation for required fields and correct formats

• Consider user experience with clear labels and easy navigation
Answered by AI
Add your answer
Q2. Add validations to different fields
Ans. 
Implement validations for different fields in software development.
• Identify the fields that require validation such as email, password, phone number, etc.

• Use regular expressions to validate input data format.

• Implement client-side and server-side validations to ensure data integrity.

• Display error messages for invalid input to guide users on correct data entry.
Answered by AI
Add your answer

Q1. Test case writing
Add your answer
Q2. Scenario based question
Add your answer

String separation using any languages

Q1. Problem solving questions
Add your answer
Q2. Critical thinking
Add your answer

Q1. How to cover miscellaneous expenses
Ans. 
Miscellaneous expenses can be covered by creating a separate budget category, tracking expenses closely, and adjusting spending as needed.
• Create a separate budget category specifically for miscellaneous expenses

• Track all miscellaneous expenses closely to ensure they do not exceed the allocated budget

• Regularly review and adjust spending in the miscellaneous expenses category as needed

• Consider setting aside a small amoun...read more
Answered by AI
Add your answer
Q2. What is audit or gst
Ans. 
Audit is a systematic examination of financial records to verify their accuracy. GST is a value-added tax levied on most goods and services sold for domestic consumption.
• Audit involves reviewing financial statements, transactions, and internal controls to ensure accuracy and compliance with regulations.

• GST (Goods and Services Tax) is a consumption tax levied on the supply of goods and services in a country.

• Audit is con...read more
Answered by AI
Add your answer