Arcesium Junior Analyst Interview Questions and Answers

1st Round consisted of Technical Discussion and Coding Round. I was asked to write down the logic for Prime no., Fibonacci Series, Matrix related question, etc.

I was asked to share my screen and write down logic for questions related to Strings, Arrays and 2-D matrix's.

Q1. Discussion About the previous projects done. Detailed questions about the technique used and algorithm related questions.
Add your answer
Q2. Few basic questions about ML. eg: Linear Regression, Logistic Regression, etc.
Add your answer

The aptitude test contains questions MCQs for quants, basic statistics and basic coding questions. The aptitude also has 2 coding problems to solve which would be of easy-medium level.

The second round was live coding test, where the interviewer looks for your approach towards solving a given problem. The approach matters more than the correct syntax. All coding languages were allowed. SQL queries can also be asked.

Q1. Technical cum HR round contains language specific questions as well questions based on mathematics and statistics. Questions can be little bit tricky.
Add your answer

Q1. How SQL DB works
Ans. 
SQL DB works by storing and managing data in a structured format using tables and relationships.
• SQL DB uses tables to store data in rows and columns.

• It allows for querying data using SQL commands like SELECT, INSERT, UPDATE, DELETE.

• Relationships between tables can be established using foreign keys.

• Indexes can be used to optimize query performance.

• ACID properties ensure data integrity and consistency.
Answered by AI
Add your answer

General Aptitude( Probability dominats) and objective coding

Moderate levels coding questions Refer hacker rank

Q1. Coding, guesstimate, probability,
Add your answer

Q1. Generation HR questions refer youtube
Add your answer

We were provided with 3 basic data stucture questions all three were leetcode medium easy question. Total time alloted was 1hr for three questions.

2nd round was again coding round but this time question level was hard plus 10 MCQs were also given based on basic computer science knowledge.
There were 2 data structure question that was leetcode medium hard questions.

Q1. How can you prove to the client that a students with higher classes are taller than that of lower classes?
Ans. 
We can use statistical analysis to prove that students in higher classes are taller than those in lower classes.
• Collect height data of students from different classes

• Use statistical measures like mean, median, and mode to compare the heights of students in different classes

• Perform hypothesis testing to determine if the difference in height between classes is statistically significant

• Visualize the data using graphs and ...read more
Answered by AI
View 3 more answers
Q2. Compare two arrays in python and print if both of them are same or not?
Ans. 
Compare two arrays in python and print if both of them are same or not.
• Use the '==' operator to compare the arrays.

• If the arrays have the same elements in the same order, they are considered the same.

• If the arrays have different elements or different order, they are considered different.

• Print 'Same' if the arrays are the same, otherwise print 'Different'.
Answered by AI
View 2 more answers
Q3. What is permutation and combination and how is it used in data science?
Ans. 
Permutation and combination are mathematical concepts used to count the number of possible outcomes in a given scenario.
• Permutation is the arrangement of objects in a specific order while combination is the selection of objects without considering the order.

• Permutation formula: nPr = n!/(n-r)! where n is the total number of objects and r is the number of objects selected.

• Combination formula: nCr = n!/r!(n-r)! where n i...read more
Answered by AI
Add your answer

2 easy level coding questions and aptitude mcqs

Q1. 3 coding questions easy to medium level. Discussion on my project and past internship experience. Basic maths questions from probability, statistic, pnc etc..
Add your answer

It was an online coding test, with 2 python questions(DP and String) and 8 MCQs.

Q1. Asked about a coding question(easy level array question) , my one of project(explain line by line), permutation and combination question.
Add your answer

Q1. Same as second round.
Add your answer