SG Analytics Jr. Data Scientist Interview Questions and Answers

Excel data analytics case

Q1. Data analytics, data visualisation tools
Add your answer

Difficult To solve in 30 minutes

Q1. Python libraries pandas sql
Add your answer

SQL, Python coding …

Q1. What's the CI/CD workflow that's followed in your team?
Ans. 
Our team follows a CI/CD workflow that includes automated testing, code reviews, and continuous integration.
• Automated testing is run on every code change to catch bugs early.

• Code reviews are conducted before merging changes to ensure code quality.

• Continuous integration is used to automatically build and test code changes in a shared repository.

• Deployment pipelines are set up to automate the release process.

• Version cont...read more
Answered by AI
Add your answer
Q2. Has there been any security incident and how have you handled those ?
Ans. 
Yes, there have been security incidents and I have handled them effectively.
• Implemented security protocols to prevent future incidents

• Conducted thorough investigation to identify the root cause

• Collaborated with IT team to strengthen security measures

• Communicated with stakeholders to ensure transparency and trust

• Provided training to employees on cybersecurity best practices
Answered by AI
Add your answer
Q3. Difference between authorization and authentication ?
Ans. 
Authentication verifies the identity of a user, while authorization determines what actions a user is allowed to perform.
• Authentication confirms the identity of a user through credentials like passwords or biometrics.

• Authorization determines the level of access or permissions a user has once their identity is confirmed.

• Authentication is the process of logging in, while authorization is the process of granting or denyin...read more
Answered by AI
Add your answer
Q4. LLD for an authentication and authorization system
Ans. 
LLD for an authentication and authorization system
• Separate modules for authentication and authorization

• Use of secure hashing algorithms for storing passwords

• Role-based access control implementation

• Audit logging for tracking user actions

• Integration with external identity providers
Answered by AI
Add your answer

Q1. Design a document managed storage like google drive as an E2E solution.
Ans. 
Design a document managed storage like Google Drive as an E2E solution.
• Implement user authentication and authorization for secure access.

• Create a user-friendly interface for uploading, organizing, and sharing documents.

• Include features like version control, file syncing, and search functionality.

• Utilize cloud storage for scalability and accessibility.

• Implement encryption for data security.

• Integrate with third-party app
Answered by AI
Add your answer

I was asked to write SQL queries for 3rd highest salary of the employee, some name filtering, group by tasks.
Python code to find the index of the maximum number without using numpy.

Q1. Explain the Project undertaken during the research and follow-up questions
Add your answer

Q1. Write pandas query to separate the names as first and last name from the full name. Drop the duplicate columns and also the missing values. Write output for the Python code. Write SQL query to retrieve t...read more
Ans. 
Answering questions related to data science concepts and techniques.
• Recall is the ratio of correctly predicted positive observations to the total actual positives. Precision is the ratio of correctly predicted positive observations to the total predicted positives.

• To reduce variance in an ensemble model, techniques like bagging, boosting, and stacking can be used. Bagging involves training multiple models on different ...read more
Answered by AI
Add your answer

Q1. What are sql aggregate functions?
Ans. 
SQL aggregate functions perform calculations on a set of values and return a single value.
• Aggregate functions include COUNT, SUM, AVG, MAX, and MIN.

• COUNT returns the number of rows in a table or the number of non-null values in a column.

• SUM returns the sum of all values in a column.

• AVG returns the average of all values in a column.

• MAX returns the highest value in a column.

• MIN returns the lowest value in a column.
Answered by AI
Add your answer
Q2. What is sub quires how its was working befif exolanation they asked for me
Add your answer