ServiceNow Data Engineer Interview Questions and Answers

A generic swap function swaps two values of any data type.

• The function should take two parameters of any data type.

• Use a temporary variable to store the value of one parameter.

• Assign the value of the second parameter to the first parameter.

• Assign the value of the temporary variable to the second parameter.

Search for an element in a rotated sorted linked list.

• Find the pivot point where the list is rotated.

• Divide the list into two sublists based on the pivot point.

• Perform binary search on the appropriate sublist.

• Handle edge cases such as empty list and list with only one element.

Search an element in a rotated sorted array

• Find the pivot point where the array is rotated

• Divide the array into two sub-arrays based on pivot point

• Perform binary search on the appropriate sub-array

• Repeat until element is found or sub-array size is 1

Find 5 missing numbers in an array of size 95 containing numbers in range 1 to 100.

• Create a boolean array of size 100 and mark the present numbers

• Iterate through the boolean array and find the missing numbers

• Alternatively, use a HashSet to store the present numbers and find the missing ones

Given a Sudoku board, find possible numbers for an empty cell.

• Iterate through empty cells and check possible numbers using row, column, and box constraints.

• Use a set to keep track of possible numbers for each empty cell.

• Return the set of possible numbers for the given empty cell.

Find integer average of 4 unsigned integers without typecasting

• Add all the integers and divide by 4

• Use bit shifting to divide by 4

• Handle overflow by using long long data type

• Use unsigned int data type for input

Code to identify 32 bit or 64 bit architecture of a processor

• Check if the operating system is 32 bit or 64 bit

• If OS is 32 bit, processor is 32 bit

• If OS is 64 bit, check if processor supports 64 bit architecture

• Use CPUID instruction to check if processor supports 64 bit architecture

Convert binary number to base 64 integer

• Divide the binary number into groups of 6 bits

• Convert each group of 6 bits to decimal

• Map the decimal value to the corresponding base 64 character

• Concatenate the base 64 characters to form the final integer

MVC life cycle, AJAX call and passing data from view to partial view.

• MVC life cycle includes request routing, controller instantiation, action execution, and rendering of the view.

• AJAX call is initiated by sending an HTTP request to the server and receiving a response in the form of JSON or XML data.

• To pass data from one view to a partial view, we can use ViewBag, ViewData, or TempData.

• ViewBag is a dynamic object that ...read more

Abstract class is a class that cannot be instantiated, while interface is a contract that defines methods.

• Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.

• Abstract class can have instance variables, while interface cannot.

• Abstract class is used for code reusability and polymorphism, while interface is used for achieving abstraction and loose coupling.

• In serv...read more

Implemented a machine learning model to predict customer churn using advanced algorithms

• Developed a predictive model using logistic regression, random forest, and gradient boosting

• Utilized feature engineering techniques to improve model performance

• Integrated the model into the company's CRM system for real-time predictions