Sequretek It Solutions Associate Consultant Interview Questions and Answers

Q1. I am unable to understand why they conduct interview if the interviewer is not fimilier about the role. waste of time to attend the interview
Add your answer
Q2. Unrelated queations
Add your answer

Q1. Unrelated scenarios and questions
Add your answer

Normal DSA and sql is more then enough.

Q1. Project and subject related questions.
Add your answer

Q1. Project description
Ans. 
The project involves developing a new software application for data analysis.
• Developing a software application for data analysis

• Utilizing programming languages such as Python and R

• Implementing statistical models and algorithms

• Creating visualizations and reports for data interpretation
Answered by AI
Add your answer
Q2. Project, ML & Stats
Add your answer

Q1. Describe the Project Architecture End-to-End
Ans. 
The project architecture end-to-end includes the overall design and structure of the project from start to finish.
• The architecture should include the hardware and software components, as well as the communication protocols and data flow.

• It should also consider the scalability, security, and performance of the system.

• Examples of project architecture include client-server, microservices, and event-driven architectures.

• Th...read more
Answered by AI
Add your answer
Q2. Explain how will you implement SCD Type 2.
Ans. 
SCD Type 2 is implemented by creating a new record for each change and maintaining a history of changes.
• Identify the business key and version number for the dimension table.

• Create a new record with a new version number for each change to the dimension data.

• End-date the previous record and start-date the new record to maintain a history of changes.

• Use effective dates to determine which record is active at any given poin...read more
Answered by AI
Add your answer

Q1. Display only those elements which do not occur more than once.
Ans. 
Display non-repeated elements
• Iterate through the elements and count their occurrences

• Display only those elements with occurrence count of 1

• Use a hash table or dictionary to store the counts

• Time complexity: O(n)
Answered by AI
View 1 more answer
Q2. Difference between a list and a tuple. Explain a use case where you will use a tuple.
Ans. 
List vs Tuple and use case for Tuple
• List is mutable while Tuple is immutable

• List uses square brackets while Tuple uses parentheses

• Tuple is used when data needs to be protected from modification

• Tuple is also used for returning multiple values from a function
Answered by AI
Add your answer

Q1. Ensemble Learning, Optimization techniques, Basics of Python and SQL
Add your answer
Q2. Know basics of ML and why for every model used in your projects
Add your answer

Q1. Leetcode 125: Valid Palindrome
Add your answer
Q2. Leetcode 1971: Find if path exists in graph
Ans. 
Check if a path exists between two nodes in a graph
• Use depth-first search (DFS) or breadth-first search (BFS) to traverse the graph

• Start from the source node and explore all connected nodes until the destination node is reached

• If the destination node is found during the traversal, return true; otherwise, return false
Answered by AI
Add your answer

Q1. How will you store passwords in DB
Ans. 
Store passwords securely using hashing algorithms and salt
• Use strong hashing algorithms like bcrypt or SHA-256

• Add a unique salt to each password before hashing

• Store only the hashed password in the database

• Regularly update hashing algorithms and salts for added security
Answered by AI
Add your answer
Q2. Explain "this" in JS
Ans. 
In JavaScript, 'this' refers to the current object that is executing the current function.
• The value of 'this' is determined by how a function is called.

• When a function is called as a method of an object, 'this' refers to the object itself.

• When a function is called in the global scope, 'this' refers to the global object (window in a browser, global in Node.js).

• Arrow functions do not have their own 'this' value and inste...read more
Answered by AI
Add your answer

Q1. Basic HR questions
Add your answer

Q1. Linear regression? python coding of lists.
Add your answer

Q1. Linear regression? python coding
Add your answer