Home › Archive for Quick Prep Big Data Interview
Blog Archives
1 2 3 4 5 … 23

0: 20+ SQL best practices & optimisation interview Q&As

SQL Best Practices

SQL is very easy to learn, but lots of hands-on experience is required to master to perform the below tasks.

1) Translating any business requirements into SQL.

2) Writing efficient, readable & maintainable SQL.

3) Breaking down &

…

Read more ›


0: 25+ Big Data Engineering key concepts that Data Engineers must know

#01 Data Cardinality

In data modelling, cardinality is the numerical relationship between rows of one table & rows in another. Common cardinalities are one-to-one, one-to-many and many-to-many.

Data cardinality also refers to the uniqueness of the values contained in a database column.

…

Read more ›


0: 50+ SQL scenarios based interview Q&As – What is wrong with this SQL code?

This extends 18+ SQL best practices & optimisation interview Q&As. You can practice these SQLs by setting up the data on db-fiddle MySQL V8.0 or a database server & SQL client of your choice.

Interviewers can use these 11 questions to quickly judge your real SQL experience without relying on what you say on your CV.

…

Read more ›


00: 13 Data modelling interview Q&As – Fact Vs Dimension, CDC, SCD, etc – part 1

Star schema dimensional modelling with Facts & Dimensions

Q1. What is dimensional modelling in a Data Warehouse (i.e. DWH)? A1. A dimensional model is a data structure technique optimised for Data Warehousing tools (i.e. OLAP products). The concept of Dimensional Modelling is comprised of Fact and Dimension tables. … Read more ›...

This content is for 100-Day-Full-Access, 200-Day-Full-Access, 365-Day-Full-Access, and 2-Year-Full-Access members only. Register 50+ Free Java FAQs 50+ Free Big Data FAQs
Already a member? Log in here

00: 13 Data modelling interview Q&As – Fact Vs Dimension, CDC, SCD, etc – part 2

Star schema dimensional modelling with Facts & Dimensions

This extends Q1 to Q5 at 13 Data Warehouse interview Q&As – Fact Vs Dimension, CDC, SCD, etc – part 1. Q6. What is a Factless Fact table? A6. From the above store sales example we know that fact table is a collection of many facts having multiple keys joined...

This content is for 100-Day-Full-Access, 200-Day-Full-Access, 365-Day-Full-Access, and 2-Year-Full-Access members only. Register 50+ Free Java FAQs 50+ Free Big Data FAQs
Already a member? Log in here

00: 50+ SQL scenarios based interview Q&As on identifying & deleting duplicate records

DB Fiddle - Practice SQL

50+ SQL interview questions and answers to solve real business scenarios. SQL is widely used in building microservices & Big Data projects. Learning SQL syntax is easy, but being able to convert a given business requirement into a query takes lots of practice. These scenarios based interview questions can assesses your experience.

…

Read more ›


00: A roadmap to become a Big Data Engineer – What skills are required?

Big Data Engineer road map. What skills are required?

Data Engineer road map

Read more ›


00: Apache Spark eco system & anatomy interview questions and answers

Q01. Can you summarise the Spark eco system?
A01. Apache Spark is a general purpose cluster computing system. It provides high-level API in Java, Scala, Python, and R. It has 6 components Core, Spark SQL, Spark Streaming,

…

Read more ›


00: Data Lake Vs. Data Warehouse Vs. Data Lakehouse Vs Data Fabric Vs Data Mesh

Modern data architectures will have both the Data Lakes and Data Warehouses. The Data Engineers build the data pipelines for the data analysts and scientists to build business reports & models to analyse the data.

What is Big Data?

Big Data is huge volumes of structured (e.g.…

Read more ›


00: Python dynamic typing, module Vs package and Class Vs Object interview Q&As

Python packages vs modules

Python is a very popular interpreted programming language with the features like strongly typed, dynamically typed, object oriented (i.e. polymorphism, inheritance & encapsulation) & supports functional programming. Also, introduces beginner terminologies like packages, modules, classes, objects, attributes, member variables, class variables, methods & functions. These are are all must-know for beginner level interviews &

…

Read more ›


00: Q1 – Q6 Hadoop based Big Data architecture & basics interview Q&As

There are a number of technologies to ingest & run analytical queries over Big Data (i.e. large volume of data). Big Data is used in Business Intelligence (i.e. BI) reporting, Data Science, Machine Learning, and Artificial Intelligence (i.e. AI). Processing a large volume of data will be intensive on disk I/O,

…

Read more ›


00a: Python modules, packages, PYTHONPATH, sys.path, dependencies, etc interview Q&As

Q01. What is a Python Module?
A01. All “.py” or “.pyw” files are Python modules, even scripts. For example, calculation.py that you create is a module. A Python module is a Python file that’s intended to be imported into scripts or other modules.

…

Read more ›


00b: Python variable scopes, assigning types optionally and execution order interview Q&As

Q01. What are the Python variable scopes?
A01. Python uses variable scopes to determine where a variable is accessible and recognized within code. Python follows a strict hierarchy for resolving names, commonly known as the LEGB rule.

…

Read more ›


1 2 3 4 5 … 23

300+ Java Interview FAQs

Java Interview FAQs 300+
Java FAQs - 01: Prepared?
(2)
Java FAQs - 02: Ice Breaker
(5)
Java FAQs - 03: Core Java
(15)
Java FAQs - 03 Java versions 9 to 20
(7)
Java FAQs - 04: OOP & FP
(10)
Java FAQs - 05: JEE
(12)
Java FAQs - 06: Spring
(10)
Java FAQs - 07: Hibernate
(4)
Java FAQs - 08: Web Services
(6)
Java FAQs - 09: Microservices
(12)
Java FAQs - 10: Messaging
(4)
Java FAQs - 11: Architecture
(5)
Java FAQs - 12: RDBMS
(2)
Java FAQs - 13: SQL
(6)
Java FAQs - 14: Code Quality
(4)
Java FAQs - 15: Key Areas
(14)
Java FAQs - 16: UML
(1)
Java FAQs - 17: GIT
(4)
Java FAQs - 18: Linux
(3)
Java FAQs - 19: DevOps (CI/CD)
(9)
Java FAQs - 20: AWS (Cloud)
(5)
Java FAQs - 21: Maven
(1)
Java FAQs - 22: Regex
(2)
Java FAQs - 23: JSON & XML
(3)
Java FAQs - 24: JMeter
(2)
Spring & Hibernate FAQs
Framework - Hibernate Q&As
(13)
Framework - Spring Core
(6)
Framework - Spring MVC
(7)
Framework - Spring Cloud
(1)
Framework - Spring boot
(4)
Framework - Spring IO
(1)
Framework - Spring Config
(5)
Java Architect FAQs
Architecture - Patterns
(10)
Architecture - How to
(17)
Architecture - AWS
(10)
Architecture - Azure
(6)
Architecture - Distributed
(8)
Architecture - Microservices
(11)
Architecture - Networking
(6)
Architecture - QoS
(1)
Architecture - ERD
(1)
Architecture - ETL
(3)
Architecture - Low Latency
(6)
Architecture - UML
(1)
Java code quality Q&As
Code Quality - Automation
(1)
Code Quality - Code Coverage
(2)
Code Quality - FAQs
(7)
Code Quality - Profiling
(3)
Code Quality - Performance
(2)
Code Quality - Unit Testing
Code Quality - BDD
(4)
Code Quality - JMockit
(15)
Code Quality - Mockito
(4)
Code Quality - Unit Testing FAQs
(3)
Code Quality – Testing DAOs
(4)
Code Quality – JUnit & Mockito
(6)
Code Quality – JUnit Web
(2)
Code Quality - Spring TXN
(2)
Java coding Q&As
Coding - Can you write code?
(22)
Coding - Complete the code
(13)
Coding - Converting from A to B
(6)
Coding - Designing your classes
(9)
Coding - Data Structures
Coding - Arrays
(2)
Coding - Big O notation
(2)
Coding - Graph Structure
(2)
Coding - LinkedList Structure
(2)
Coding - Map Structure
(1)
Coding - Pointer Algorithms
(3)
Coding - Queue Structure
(1)
Coding - Searching Algo
(1)
Coding - Sorting Algo
(4)
Coding - Stack Structure
(1)
Coding - Tree structure
(14)
Coding - Data Which & Why
(2)
Coding - Passing the unit tests
(5)
Coding - What is wrong?
(10)
Coding - Home Assignments
(8)
Coding - Written Test Core Java
(4)
Coding - Written Test JEE
(1)

Tutorials on Java & Big Data

Tutorials - Golang
5
Tutorials - Big Data
TUT - ⏯ Starting Big Data
2
TUT - Starting Spark & Scala
10
TUT - Starting with Python
2
TUT - Pig
3
TUT - Apache Storm
3
TUT - Spark Scala on Zeppelin
14
TUT - Cloudera
4
TUT - Cloudera on Docker
21
TUT - File Formats
8
TUT - Spark on Docker
8
TUT - Flume
2
TUT - Hadoop (HDFS)
5
TUT - HBase (NoSQL)
5
TUT - Hive (SQL)
1
TUT - Hadoop & Spark
16
TUT - MapReduce
3
TUT - Spark and Scala
2
TUT - Spark & Java
14
TUT - Apache Kafka
8
TUT - Hadoop
1
TUT - PySpark on Databricks
28
TUT - Zookeeper
2
Tutorials - Enterprise Java
TUT - Starting with Java
22
TUT - ⏯ Java Video Tutorials
TUT - ⏯ Starting with Java
12
TUT - ⏯ Spring Core
1
TUT - ⏯ Spring MVC
5
TUT - ⏯ JDBC, Hibernate
6
TUT - ⏯ Spring Boot
2
TUT - ⏯ Angular with Spring
TUT - ⏯ Q&As
2
TUT - Diagnosis
2
TUT - Akka
TUT - Akka Scala
3
TUT - Akka Java
6
TUT - AWS EC2
4
TUT - CI/CD Jenkins
3
TUT - Core Java
TUT - Debugging
4
TUT - Java 8
4
TUT - JSON and Java
1
TUT - Java Beginner
1
TUT - XML and Java
8
TUT - CSV and Java
2
TUT - Docker
9
TUT - Java gRPC
3
TUT - JEE
TUT - Web & Web Services
7
TUT - REST Client
1
TUT - JSF
1
TUT - JDBC
5
TUT - FIX and Java
3
TUT - JAXB
8
TUT - JMX
1
TUT - JPA
1
TUT - MySQL
1
TUT - Scala
TUT - Scala Actors
1
TUT - Spring & Hibernate
TUT - Hibernate
2
TUT - Spring Basics
10
TUT - Spring batch
3
TUT - Hibernate & Spring
5
TUT - Spring Boot
6
TUT - Spring IO
1
TUT - Spring ORM
2
TUT - Spring other
2
TUT - Spring OXM
2
TUT - Spring Cloud
9
TUT - Tools
TUT - JMeter
3
TUT - Maven
4
TUT - Maven Assembly
2
TUT - Maven Profiles
1
TUT - Productivity Tools
9
TUT - Apache Kafka
3
TUT - Redis Tutorial
2
TUT - Kubernetes & Docker
5
TUT - Other
TUT - SQL
3
TUT - Drools
5
TUT - Apache POI
3
TUT - DOS
2
TUT - Dozer
2
TUT - ESB
1
TUT - Groovy
3
TUT - Jasper Reports
4
TUT - Logging and auditing
6
TUT - Metrics
2
TUT - Orika Mapping
2
TUT - Pentaho Kettle ETL
4
TUT - Linux
7
TUT - Webspeher MQ
3
TUT - YAML
1

50+ Free Java & Big Data Interview Q&As