Principal Engineer Interview Questions | Glassdoor.co.uk

Principal Engineer Interview Questions

79

Principal engineer interview questions shared by candidates

Top Interview Questions

Sort: RelevancePopular Date

How can you improve the performance of a SQL statement\database

1 Answer

1) Indexes 2) Any field in the Where clause is game to be indexed 3) Limit number of rows\columns returned 4) Limit page scans 5) Use Temp table to loop data instead of Cursors 6) No user functions in the Where clause (if you need them - put on left hand side of equals)

How do you stop SQL Injection

1 Answer

How would you secure your Web API

1 Answer

What code repositories have you used

1 Answer

Name types of testing

1 Answer

Given a Jupyter notebook with code to load a classifier and images, there is a bug on inference. Find it and explain.

1 Answer

Given some ML-related source file, explain it. What does it do? How does it fit a project?

1 Answer

What CI tool have you used

1 Answer

You will be asked to code on paper 3 scenarios 1) Generate a TinyUrl application 2) Generate a method to determine if a word is Palindrome (i.e. Abba or Eye) 3) Generate two class models for two related classes (in memory not DB) , one will hold a Merchant (or some other user's) details and the other class will hole the Stores owned by the merchant. How would you store the data in a session (Application if Web or Cache if desktop) How would you find the Merchants of a particular Name How would you find the stores belonging to a particular Merchant How would you find the stores belonging to a particular Merchant and those stores are in a particular city 4) Given an array of ints, write a C# method to total all the values that are even numbers.

1 Answer

What is a Sealed Class and why would you use it

110 of 79 Interview Questions