write a code in R/SQL: Given a table with three column, (id, category, value) and each id has 3 or less category (price, size, color). Now, how can I find those id's for which the value of two or more category matches to one another? For eg: ID1 (price 10, size M, color Red), ID2 (price 10, Size L, Color Red) , ID3 (price 15, size L, color Red) Then the output should be two rows: ID1 ID2 and ID2 ID3
- What is over-fitting? How do you avoid it? - What types of regularization do we have? Which one is simpler to use? L1 or L2? - Explain decision trees? What are different metrics to classify dataset? - What is bagging? - We have two models, one with 85% accuracy, one 82%. Which one do you pick? - What is p-value and how can we use it?
Tell me about your self? What is Data Warehousing?
The interview was highly focused SQL questions such as finding the third high, finding the newest one.
1. Tell us about yourself 2. What is the Difference between analog and digital system. 3.Between analog and digital which one do we use to Start up the system. 4. What is kW and kVA 5.Explain the Building Management Systems operation. 6.What is PDU. 7.Why do you think UPS are very essential to our network because they are expensive and they can only last for 20 seconds. 8. Explain N+1, 2N and N-1. 9.Mention three components that are in the UPS, AHU,Chillers,Cooling Towers and VFDs. 10. Why do we need to synchronize/parallel the Generators. 11. Explain Variable Frequency Drive (VFD)operation. 12. Explain the process that the Chillers use to heat fro the building. you must know the operation of the chiller here. 13.Explain a Difficult situation that was out of your role where you had to make a decision , what was the outcome. 14. How do you deliver results?
Assumption of Linear Regression, etc.
Differences between RAID levels. Power redundancy practices, equipment racking stuff.
What would you do if an employee sends an email written with a different language ( non-English )
Mostly technical / coding questions with limited time to answer, talk about past projects (with techncial depth), almost no questions with respect to data science (statistics, ml, math, modeling ...)
Find out whether an array/string contains non-repeated characters.
Viewing 841 - 850 interview questions