Weblink In Data Scientist Intern Interview Questions and Answers

Common logical and reasoning questions and also has a pseudocode

Q1. Gamified round with time limits and essay writing for the given picture
Add your answer

Q1. Asked about whatever you put in the resume and mainly focus on aptitude
Add your answer

First round is gaming round with 13 levels
And the aptitude with science, technical and non technical questions

Q1. General questions were asked Tell me about yourself And then technical he round with puzzles and aptitude to solve
Add your answer
Q2. Long term and short term goals
Add your answer
Q3. Strength and weakness
Add your answer
Q4. Puzzles and aptitude questions
Add your answer

Well designed to test the aptitude competence of the candidate.

Q1. Explanations for the answers given to the aptitude questions.
Add your answer
Q2. Questions from python.
Add your answer

Logical and aptitude test, game round

Q1. Introduction and CV based
Add your answer

Basic aptitude questions, statics, probability etc

Q1. Where do you live in the USA
Ans. 
I live in New York City, the bustling metropolis known for its iconic landmarks and diverse culture.
• I reside in the heart of Manhattan, surrounded by towering skyscrapers.

• New York City is home to famous attractions like Times Square, Central Park, and the Statue of Liberty.

• The city offers a vibrant arts and entertainment scene, with Broadway shows and world-class museums.

• I enjoy exploring the diverse neighborhoods and ...read more
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years
Ans. 
In 5 years, I see myself as a senior data analyst leading a team, utilizing advanced analytics to drive strategic decision-making.
• Leading a team of data analysts

• Utilizing advanced analytics techniques

• Driving strategic decision-making

• Continuously learning and staying updated with the latest trends in data analysis
Answered by AI
Add your answer

Q1. Difference between Primary Key and Unique Key ?
Add your answer

The first round was a combination of MCQs and SQL Coding test. It consisted of 23 MCQs on SQL, 10 MCQs on Power BI and 5 SQL Coding questions.

Q1. Simple questions on SQL were asked.
Add your answer

Q1. What is pivot table in Excel?
Add your answer
Q2. What is 'Data Validation' in Excel?
Ans. 
Data Validation in Excel ensures that data entered in a cell meets certain criteria or conditions.
• Data Validation allows you to set rules for what can be entered in a cell, such as a range of values, a list of items, or a custom formula.

• Examples of Data Validation include setting a drop-down list of options for a cell, restricting input to a certain number range, or ensuring dates are entered in a specific format.

• Data ...read more
Answered by AI
Add your answer
Q3. What is the order of execution of an SQL query?
Ans. 
The order of execution of an SQL query involves multiple steps to retrieve data from a database.
• 1. Parsing: The SQL query is first parsed to check for syntax errors.

• 2. Optimization: The query optimizer creates an execution plan to determine the most efficient way to retrieve data.

• 3. Compilation: The optimized query is compiled into an executable form.

• 4. Execution: The compiled query is executed by the database engine t...read more
Answered by AI
Add your answer
Q4. What is the difference between Tree Map and Heatmap in Tableau?
Ans. 
Tree Map visualizes hierarchical data using nested rectangles, while Heatmap displays data values using color gradients.
• Tree Map displays data hierarchically with nested rectangles, where the size and color represent different measures.

• Heatmap visualizes data values using color gradients, with darker colors indicating higher values.

• Tree Map is useful for showing hierarchical data structures, while Heatmap is effective ...read more
Answered by AI
Add your answer
Q5. What is the difference between 'Extract Data' and 'Live Connection' in Tableau?
Ans. 
Extract Data saves a snapshot of data in Tableau workbook, while Live Connection directly connects to data source.
• Extract Data creates a static copy of data in Tableau workbook, while Live Connection directly queries data source in real-time.

• Extract Data is useful for working offline or with small datasets, while Live Connection is ideal for large datasets or when data is frequently updated.

• Extract Data can improve per...read more
Answered by AI
Add your answer