Samsung Senior Data Analyst Interview Questions and Answers

Q1. Sets and tuple difference and python data structures
Add your answer

Python test on list : reverse a list using a single array

Data ingestion architecture

Easy to answer ,asked mostly on sql and other ml topics

Q1. Differencde between sql and nosql
Ans. 
SQL is a relational database management system, while NoSQL is a non-relational database management system.
• SQL databases are table-based and have a predefined schema, while NoSQL databases are document-based, key-value pairs, graph databases, or wide-column stores.

• SQL databases are good for complex queries and transactions, while NoSQL databases are better for hierarchical data storage and real-time web applications.

• Ex...read more
Answered by AI
Add your answer
Q2. What are the regularization in ml
Ans. 
Regularization in machine learning is a technique used to prevent overfitting by adding a penalty term to the model's loss function.
• Regularization helps in reducing the complexity of the model by penalizing large coefficients.

• Common types of regularization include L1 (Lasso) and L2 (Ridge) regularization.

• L1 regularization adds the absolute value of the coefficients to the loss function, promoting sparsity.

• L2 regulariza...read more
Answered by AI
Add your answer

Q1. Exptected salary
Add your answer
Q2. What do you expect for work
Ans. 
I expect challenging projects, opportunities for growth, collaborative team environment, and work-life balance.
• Challenging projects that allow me to apply my data science skills and learn new techniques

• Opportunities for growth and advancement within the company

• Collaborative team environment where I can share ideas and work together towards common goals

• Work-life balance to ensure I can perform at my best both profession
Answered by AI
Add your answer

Topic was joining and calculating

Basic python questions

Q1. Asked to create a power bi dashboard
Add your answer

Q1. Had coding test on SQL and Python
Add your answer

Q1. Sql rank order explain
Ans. 
SQL rank order function explanation
• Rank order function in SQL assigns a rank to each row based on a specified column

• It can be used to determine the top or bottom N records in a dataset

• Example: SELECT column1, column2, RANK() OVER (ORDER BY column3 DESC) AS rank_order FROM table_name
Answered by AI
Add your answer
Q2. Merging two tables
Ans. 
Merging two tables involves combining data from both tables based on a common key.
• Identify a common key between the two tables

• Use SQL JOIN statements to merge the tables

• Choose the appropriate type of join (e.g. inner join, outer join)

• Consider the size of the tables and the performance implications of the merge
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. About yourself n work profile
Add your answer