Lockbox AI Interview Questions and Answers

Q1. End to end architecture of current project
Add your answer
Q2. Basic spark code to read & write files
Add your answer
Q3. How to upsert data in table in spark
Add your answer
Q4. How do you handle sudden increase in data volume
Add your answer
Q5. Discussion on delta tables & ACID transactions
Add your answer
Q6. Explain autoloader and use case in Databricks
Add your answer
Q7. SQL question using window functions Lead, row number
Add your answer
Q8. Python question using hashmap & String
Add your answer

Q1. Current project understanding end to end
Add your answer
Q2. Data pipeline design for a ride sharing company, ask bunch of follow up questions on the conclude a particular design.
Add your answer
Q3. Explain how you follow SDLC(Agile, waterfall) ?
Add your answer
Q4. Why are you looking for a change now
Add your answer

Q1. Basic introductions
Add your answer
Q2. What kind of work are you looking for? what do you know about the company
Add your answer
Q3. Willing to relocate?
Add your answer
Q4. Personal hobbies and aspirations
Add your answer

All the assignment to improve our self

Case study all knowledge edias

Share the thought process inorpove our self

Html and other project

Q1. All thrcnical kholwleghe
Add your answer
Q2. All types of design
Add your answer
Q3. All graphics design idiaas
Add your answer
Q4. All types of the assessment
Add your answer
Q5. And cultural activities
Add your answer

It was conducted in hacker earth
Around 1:55hr

Q1. Write a code for encrypting and decryption of character
Ans. 
Code for encrypting and decrypting characters using a simple algorithm
• Use a simple algorithm like shifting the characters by a fixed number of positions in the ASCII table

• For encryption, add the fixed number to the ASCII value of each character

• For decryption, subtract the fixed number from the ASCII value of each character
Answered by AI
Add your answer
Q2. Given a python code find the bugs
Ans. 
Identify bugs in a given Python code
• Check for syntax errors such as missing colons or parentheses

• Look for logical errors in the code that may cause unexpected behavior

• Test edge cases and boundary conditions to ensure code handles all scenarios

• Use debugging tools like print statements or a debugger to trace the flow of the code
Answered by AI
Add your answer

It included mcqs and multiple coding questions.

Q1. Yours technical skillls related questions
Add your answer
Q2. Managerial questions
Add your answer

Q1. About yourself ?
Add your answer
Q2. Just asked questions on previous role
Add your answer
Q3. How many types of IOT devices are there
Ans. 
There are three main types of IoT devices: consumer, commercial, and industrial.
• Consumer IoT devices: Smart home devices like thermostats, lights, and security cameras.

• Commercial IoT devices: Smart meters, asset tracking systems, and connected vending machines.

• Industrial IoT devices: Sensors and actuators used in manufacturing, agriculture, and healthcare.
Answered by AI
Add your answer

Q1. Generate a Dataframe
Add your answer

Assignment was to create an API for an expenses sharing application where users can input the total amount and the people to be shared the amount with and each individual amount in terms of either actual amount, percentage or split equally

Q1. Difference between process and threads
Ans. 
Processes are independent instances of a program, while threads are smaller units within a process sharing resources.
• Processes have their own memory space, while threads share the same memory space within a process.

• Processes are heavyweight, requiring more resources, while threads are lightweight.

• Processes communicate with each other through inter-process communication mechanisms, while threads can communicate directly...read more
Answered by AI
Add your answer
Q2. What is indexing in DBMS
Ans. 
Indexing in DBMS is a technique used to improve the performance of queries by allowing faster retrieval of data.
• Indexes are data structures that store a small portion of the table data in an optimized format for quick retrieval.

• They help in speeding up data retrieval operations like SELECT, UPDATE, DELETE queries.

• Examples of indexes include primary keys, unique keys, and composite keys.
Answered by AI
Add your answer
Q3. Examples and description of asymmetric encryption alogorithms
Ans. 
Asymmetric encryption algorithms use a pair of keys to encrypt and decrypt data, providing secure communication.
• RSA (Rivest-Shamir-Adleman) is a popular asymmetric encryption algorithm.

• Elliptic Curve Cryptography (ECC) is another commonly used asymmetric encryption algorithm.

• Asymmetric encryption is slower than symmetric encryption but provides better security.

• Public key is used for encryption and private key is used f
Answered by AI
Add your answer
Q4. Which sorting method is beneficial in which scenario
Ans. 
Different sorting methods are beneficial in different scenarios based on factors like time complexity, space complexity, and input size.
• Quick Sort: Best for large datasets due to its average time complexity of O(n log n)

• Bubble Sort: Simple and easy to implement, but inefficient for large datasets with its time complexity of O(n^2)

• Merge Sort: Stable and efficient for large datasets with its time complexity of O(n log n)

• ...read more
Answered by AI
Add your answer

Q1. What are ACID properties in DBMS
Ans. 
ACID properties are a set of properties that guarantee reliability and consistency in database transactions.
• Atomicity: Ensures that either all operations in a transaction are completed successfully or none at all.

• Consistency: Ensures that the database remains in a consistent state before and after the transaction.

• Isolation: Ensures that the execution of multiple transactions concurrently does not interfere with each ot...read more
Answered by AI
Add your answer
Q2. Underlying data structure in Indexing and its time complexity
Ans. 
Indexing typically uses data structures like B-trees or hash tables for efficient retrieval, with time complexity of O(log n) or O(1) respectively.
• Common data structures for indexing include B-trees and hash tables

• B-trees are typically used for indexing in databases due to their balanced nature and efficient search operations

• Hash tables are used for indexing in scenarios where constant time lookup is desired, but may h
Answered by AI
Add your answer
Q3. Time complexity of a recursive fibonacci code
Ans. 
Time complexity of recursive fibonacci code is O(2^n)
• The time complexity of a recursive fibonacci code is exponential, O(2^n)

• This is because each call branches into two recursive calls, leading to exponential growth

• For example, calculating fibonacci(5) would result in 15 function calls
Answered by AI
Add your answer
Q4. The protocol behind Web Sockets (because it was in my resume)
Ans. 
Web Sockets is a communication protocol that provides full-duplex communication channels over a single TCP connection.
• Web Sockets allow for real-time, bi-directional communication between a client and a server.

• They are commonly used in chat applications, online gaming, and live data streaming.

• Web Sockets use the ws:// or wss:// protocol scheme in URLs.

• The protocol is initiated with a handshake between the client and se...read more
Answered by AI
Add your answer

Weather dashboard app

Js coding test on array and loops