Adobe Data Engineer Interview Questions and Answers

Hackerearth problem on reversing the string & one more array question

Q1. Reverse the string
Ans. 
Reverse a given string
• Use built-in functions like reverse() in Python

• Iterate through the string in reverse order and append characters to a new string

• Use stack data structure to reverse the string
Answered by AI
Add your answer
Q2. SQL based windowing function
Add your answer

Q1. Explain surrogate key
Ans. 
Surrogate key is a unique identifier used in databases to uniquely identify each record in a table.
• Surrogate keys are typically generated by the system and have no business meaning.

• They are used to simplify database operations and improve performance.

• Example: Using an auto-incrementing integer column as a surrogate key in a table.
Answered by AI
Add your answer

Coding round of 2 questions of medium level

Q1. About project what are optimization you have done
Add your answer

Q1. How to read files in pandas?
Ans. 
Pandas can read various file formats including CSV, Excel, JSON, HTML, and SQL.
• Use pandas.read_csv() to read CSV files

• Use pandas.read_excel() to read Excel files

• Use pandas.read_json() to read JSON files

• Use pandas.read_html() to read HTML tables

• Use pandas.read_sql() to read SQL tables

• Specify the file path or URL as the argument

• Additional parameters can be used to customize the reading process
Answered by AI
Add your answer
Q2. How to use lambda function
Ans. 
Lambda functions are anonymous functions that can be used to perform a single task or operation.
• Lambda functions are defined using the lambda keyword.

• They can take any number of arguments but can only have one expression.

• Lambda functions are often used as arguments for higher-order functions.

• Example: lambda x: x**2 defines a lambda function that squares its input.

• Example: sorted(my_list, key=lambda x: x[1]) sorts a lis...read more
Answered by AI
Add your answer