Postman Data Analyst Interview Questions and Answers

SQL Based Test - Joins, Order of Execution

Q1. Basic Excel based Questions
Add your answer
Q2. Basic SQL questions
Add your answer

Case study on how you would place a shop outlet in an airport?

They asked a guesstimate case question. The question was, If you are the manager of McDonalds, where would you place it in the international chennai airport (Arrival or departure).
What will be the yearly revenue McDonalds if all items are priced at Rs.100.

Q1. Advanced Excel Based questions
Add your answer
Q2. Basic SQL based questions
Add your answer

Q1. Previous experience
Add your answer

A list of behavior questions were shared to be filled.

M maximum numbers from array.
Merge sort

Q1. Build Recommendation system
Add your answer
Q2. Top products for user queries
Ans. 
Top products for user queries can be determined by analyzing search logs and user behavior.
• Analyze search logs to identify frequently searched products

• Use machine learning algorithms to predict user preferences

• Consider user behavior and purchase history to recommend products

• Examples: Amazon's 'Frequently Bought Together' and 'Customers Who Bought This Item Also Bought' sections
Answered by AI
Add your answer

Q1. Why do I want to join,
Add your answer
Q2. What kind of work I did in past
Add your answer

Q1. Write a lambda function in python
Ans. 
A lambda function in Python is a small anonymous function defined using the lambda keyword.
• Lambda functions can have any number of arguments, but can only have one expression.

• Syntax: lambda arguments : expression

• Example: lambda x, y : x + y
Answered by AI
Add your answer
Q2. Dbutils in databricks
Ans. 
dbutils is a utility provided by Databricks for interacting with files and directories in the Databricks environment.
• dbutils.fs.ls('/') - list files in root directory

• dbutils.fs.cp('dbfs:/file.txt', 'file.txt') - copy file from DBFS to local file system

• dbutils.fs.mkdirs('dbfs:/new_dir') - create a new directory in DBFS
Answered by AI
Add your answer
Q3. Persist and cache
Add your answer
Q4. What is commit in SQL
Ans. 
A commit in SQL is a command that saves all the changes made in a transaction to the database.
• A commit is used to make all the changes made in a transaction permanent.

• Once a commit is issued, the changes cannot be rolled back.

• It is important to use commit to ensure data integrity and consistency.

• Example: COMMIT; - this command is used to commit the changes in a transaction.
Answered by AI
Add your answer
Q5. Rank and dans_rank
Add your answer

There is a test where you build data pipeline

Q1. Streaming use case with spark
Ans. 
Spark can be used for real-time data processing in streaming use cases.
• Spark Streaming allows for processing real-time data streams.

• It can handle high-throughput and fault-tolerant processing.

• Examples include real-time analytics, monitoring, and alerting.
Answered by AI
View 1 more answer