Aress Software and Education Technologies Data Analyst Interview Questions and Answers

Q1. Basis HR questions
Add your answer
Q2. Answer confidently
Add your answer

Q1. Based on previous work
Add your answer
Q2. Answer correctly what you had worked in your previous work
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

30 multiple choice questions
There were many puzzles ,some english ,comp sci related questions
English-arrange sentence in order ,ram,dns server,preposition,smallest unit bit,modem,repeater,lan ,search engine

Q1. What is dns ,www,http,domain name,ip address,html
Ans. 
DNS, WWW, HTTP, domain name, IP address, and HTML are all fundamental components of the internet.
• DNS (Domain Name System) translates domain names into IP addresses.

• WWW (World Wide Web) is a system of interlinked hypertext documents accessed via the internet.

• HTTP (Hypertext Transfer Protocol) is the protocol used for transmitting data on the web.

• A domain name is the human-readable address used to access websites (e.g. g...read more
Answered by AI
Add your answer
Q2. About yourself,family ,would you stay for a year
Add your answer

Q1. Data Sceince related questions
Add your answer

Q1. Introduce yourself and past experience
Add your answer
Q2. Describe slowing changing dimensions
Ans. 
Slowly changing dimensions are attributes that change over time, but at a slow rate.
• SCD is a technique used in data warehousing to handle changes in dimensions over time

• Type 1 SCD overwrites old data with new data

• Type 2 SCD creates a new record for each change and maintains a history

• Type 3 SCD adds a new column to the existing record to store the new value

• Examples of SCD include customer addresses, product prices, and
Answered by AI
Add your answer

They conduct written test

Q1. Asking questions like ur skills and qualification
Add your answer
Q2. Which option u prefer quality or ontime delivery
Add your answer

Q1. Asking about ur capabilities
Add your answer