Blog Archives
1 2 3 4 5 6 7 8 9 … 16

05: ETL & ELT architecture interview Q&As

Q1. What is an ETL process? A1. ETL is a architectural style, and it stands for Extract, Transform and Load. Extract does the process of reading data from an input data source like file, database, etc. … Read more ›...

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


05: Linear regression outputs, null hypothesis, t-test & p-value interview Q&As

Q1. How do you produce & interpret Linear Regression output? A1. Scatter plots can only detect obvious relationships between variables by looking at the graph, but we can use statistics to comment about the variable relationships as outlined below. The link 11A: Databricks – Spark ML – Pandas Dataframe &...

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


05: Pyspark read from a file & add new columns interview Q&As with tutorial

This extends Pyspark with schema & a simple join of two data frames example.

Q08: How would you read csv data into a spark Dataframe?
A08: Here is the tutorial step by step that reads employee.csv file into the Dataframe.

…

Read more ›



05: Q37 – Q50 Apache Flume interview questions & answers

Q37. Where do use Apache Flume in the BigData world? A37. Apache Flume is used to ingest big data into HDFS. BigData is generally ingested from 1) Sporadic bulk loading processes, such as database and mainframe offloads and batched data dumps from legacy systems. … Read more ›...

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


05: Q37-Q41 – Data lake & metadata interview Q&As

Q37. What is a Data Lake? A37. A data lake is a storage repository that holds a vast amount of structured, semi-structured, and unstructured raw data in its native format (aka pristine condition). The data structure and requirements are not defined until the data is needed. … Read more ›...

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


05: Snowflake interview questions & answers – Stored Procedures, Session Variables, UDFs, etc

Q01. What is stored procedure in Snowflake? A01. Snowflake stored procedure lets you perform database operations by executing multiple SQL statements by automating repetitive tasks like cleaning up data by deleting records older than a specified date. … Read more ›...

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


06: 50+ SQL scenarios based interview Q&As on unique N items per group

This extends 15+ SQL scenarios based interview Q&As on N items per group – part 5 This SQL scenarios based interview questions & answers focus on N items per group. These examples were done on MySQL v8.0 at www.db-fiddle.com. … Read more ›...

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


06: Azure interview Q&As on Resource Groups & Resource Manager

Q01. What is an Azure Resource Manager (i.e. ARM)? A01. ARM is the native platform for infrastructure as code (IaC) in Azure. It enables you to centralise the management, deployment, and security of Azure resources. … Read more ›...

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


06: Databricks interview questions & answers – SQL connectivity

Q01. How can you connect to Databricks for SQL? A01. SQL connectivity is very useful to access data from Databricks lakehouse from your code, JMeter for performance testing and from the command line (e.g. dbsqlcli) or SQL GUI clients like DBeaver for interactive querying. … Read more ›...

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


06: Learn how to access Hive from Spark via SparkSQL & Dataframes by example

These Hadoop tutorials assume that you have installed Cloudera QuickStart, which has the Hadoop eco system like HDFS, Spark, Hive, HBase, YARN, etc. This example extends Learn Hive to write to and read from AVRO & Parquet files by examples to access Hive metastore via Spark SQL. … Read more...

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


06: Pyspark SCD Type 1 & Type 2 Interview Q&As with tutorials

This extends Pyspark with schema & a simple join of two data frames example. Q13: What is SCD Type 1, and how will you implement it in pyspark? A13: SCD stands for Slowly Changing Dimension, … Read more ›...

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


06: Q51 – Q61 HBase Interview Questions & Answers

Q51. Is HBase a relational database? A51. HBase is not a relational database. It is a NoSQL database. Hbase is a column-oriented (aka columnar) database management system, which runs on top of HDFS (Hadoop Distribute File System). Q52. … Read more ›...

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


07: 50+ SQL scenarios based interview Q&As on Pivot Vs. Unpivot

Q01 Often you will have a requirement to report on a certain dimension, which requires you to convert rows into columns or columns into rows. How will you go about accomplishing this using SQL?
A01 The process of converting rows into columns is know as “

…

Read more ›



1 2 3 4 5 6 7 8 9 … 16

300+ Java Interview Questions - FAQs

Tutorials on Java & Big Data