Shell Data Analyst Interview Questions and Answers

Mcq and aptitude and also some basic pandas related code

Mcq and aptitude was asked medium difficulty

There are more the 10 people in the group discussion round i was selected one of them

Q1. They asked about azure data factory, azure databricks, azure technology
Add your answer
Q2. What is azure data factory
Ans. 
Azure Data Factory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
• Azure Data Factory is used to move and transform data from various sources to destinations.

• It supports data integration and orchestration of workflows.

• You can create data pipelines using a visual interface or code.

• It integrates with various data sources like Azure Blob Storage, SQL Database, and m
Answered by AI
Add your answer

Q1. They asked about my college project
Add your answer

Q1. SQL MongoDB Postgress MySQL
Add your answer
Q2. What is MySQL and its responsibilities?
Ans. 
MySQL is a popular open-source relational database management system.
• MySQL is used for storing and managing data in a structured format.

• It allows users to create, read, update, and delete data using SQL queries.

• MySQL is commonly used in web applications to store user information, product data, and more.

• It supports features like transactions, indexing, and replication for data consistency and reliability.
Answered by AI
Add your answer
Q3. What is SQL and its main role as db engg.?
Ans. 
SQL is a programming language used for managing and querying relational databases.
• SQL stands for Structured Query Language

• Main role is to interact with databases by querying, updating, and managing data

• Used to create, retrieve, update, and delete data in relational databases

• Allows for data manipulation, data definition, and data control operations

• Examples include SELECT, INSERT, UPDATE, DELETE statements
Answered by AI
Add your answer
Q4. What is mongoDB ?
Ans. 
mongoDB is a popular NoSQL database management system.
• NoSQL database

• Document-oriented

• Scalable and flexible

• Supports dynamic schemas

• Used for handling large volumes of data
Answered by AI
Add your answer
Q5. What is postgress?
Ans. 
PostgreSQL is an open-source relational database management system known for its robustness and extensibility.
• PostgreSQL is commonly referred to as Postgres.

• It is known for its ACID compliance, extensibility, and support for various data types.

• PostgreSQL supports SQL and JSON querying, as well as various programming languages for stored procedures.

• It is widely used in enterprise applications and web development.

• Example...read more
Answered by AI
Add your answer

Mettle test and mcq were given in interview

AS IBPS EXAM QUESTIONS

Q1. SQL,TABLEAU QUESTIONS
Add your answer

Analysis , graph , dp , recursion

Array, string, graph

Q1. Project explaation
Add your answer

30 technical questions

Q1. Technical process
Add your answer
Q2. What are oops concept
Ans. 
Object-oriented programming concepts that focus on objects and classes.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (class).

• Inheritance: Ability of a class to inherit properties and behavior from another class.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex implementation details and showing only the necessary features.
Answered by AI
Add your answer

Q1. Oops questions Database SQL Logic building along with case study
Add your answer