Decision Minds Interview Questions and Answers

Q1. Internal and external tables
Add your answer
Q2. What is Hive architecture
Ans. 
Hive architecture is a data warehousing system built on top of Hadoop for querying and analyzing large datasets.
• Hive uses a SQL-like language called HiveQL for querying data stored in Hadoop Distributed File System (HDFS).

• It consists of three main components: Metastore, Driver, and Execution Engine.

• Metastore stores metadata about tables and partitions in a relational database.

• Driver accepts HiveQL queries, compiles the...read more
Answered by AI
Add your answer

Q1. What are List and tuple
Ans. 
List and tuple are data structures in Python used to store collections of items.
• Lists are mutable and can be modified after creation

• Tuples are immutable and cannot be modified after creation

• Lists are defined using square brackets []

• Tuples are defined using parentheses ()

• Lists are used for collections of similar items

• Tuples are used for collections of different items
Answered by AI
Add your answer
Q2. SQL Queries on window functions
Add your answer

Q1. How to remove duplicates
Ans. 
To remove duplicates, we can use various methods such as using sets, pandas, or SQL.
• Using sets: Convert the list to a set and then back to a list

• Using pandas: Use the drop_duplicates() method on a pandas dataframe

• Using SQL: Use the DISTINCT keyword in a SELECT statement

• Using hashable objects: Create a dictionary with the list elements as keys and then convert it back to a list
Answered by AI
Add your answer
Q2. Difference between Hive and Sql
Ans. 
Hive is a data warehousing tool for Hadoop while SQL is a language used to manage relational databases.
• Hive is used for big data processing while SQL is used for relational databases.

• Hive uses Hadoop Distributed File System (HDFS) while SQL uses traditional storage systems.

• Hive queries are written in Hive Query Language (HQL) while SQL queries are written in Structured Query Language.

• Hive is optimized for batch process...read more
Answered by AI
Add your answer

Q1. Snowflake data and biased questions
Add your answer

Dbt and data structure

Q1. Tell me about your self
Ans. 
Experienced team lead with a strong background in project management and team development, passionate about driving results and fostering collaboration.
• Over 8 years of experience in project management, successfully leading teams to deliver projects on time and within budget.

• Implemented agile methodologies in my previous role, resulting in a 30% increase in team productivity.

• Strong communication skills, demonstrated by ...read more
Answered by AI
Add your answer

Q1. What is DDl and DMl Command
Ans. 
DDL stands for Data Definition Language and is used to define and manage the structure of a database. DML stands for Data Manipulation Language and is used to manipulate the data within a database.
• DDL commands are used to create, alter, and drop database objects such as tables, views, indexes, etc.

• Examples of DDL commands include CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX, etc.

• DML commands are used to insert, ...read more
Answered by AI
Add your answer