Systems Analyst Interview Questions in United States
"Systems analysts work to build, maintain, and improve speed and efficiency of computer systems. Employers are looking for analytical thinkers with the ability to identify and solve complex problems. During the interview process, expect to be quizzed on your knowledge of IT systems such as networking processes and infrastructure. A bachelor's degree in computer science or a related field is generally expected."
How do you handle irate clients that are having technical trobules and need to work immediately.
4 Answers↳
You tell them, you understand the frustration and you will immediately send someone to fix the issue. You do basic troubleshooting and if it doesn’t work, send tech support. Less
↳
Approach the situation with 'we' working on the issue. Know that your are there to help solve this and act towards that, being calm and accurate towards solution. Even if the solution is that you will have to find out more and have to return to solve this issue. Less
↳
Ask for the ip address, then ask if it is an on or near-air emergency. Ask for the symptoms and if others are experiencing the same problem. If no one else is then have them jump on another pc if possible/feasible. Remote into the pc or tx the ip to the relevant trouble-shooter. Less
What is the difference between RAID 0 & RAID 5?
3 Answers↳
To expand on the previous answer, RAID 0 improves HDD performance dramaticaly, but since there is no mirroring if one drive dies data is lost. RAID 0 should never be used on a system with critical data. In RAID 5, performance is slower, but it allows for the failure of a HDD with no loss of data. Consider instead, RAID 10. It requires a minimum of four HDD's, but provides an increase in performance with redundancy. Less
↳
Through questions like this, interviewers are mostly trying to test your skillset (and its relevance to the role) as robustly as possible, so be prepared for multiple offshoots and followups. It could be a useful exercise to do mocks with friends or colleagues in Avanade to get a real sense of what the interview is actually like. Alternatively Prepfully has a ton of Avanade Systems Engineer experts who provide mock interviews for a pretty reasonable amount. prepfully.com/practice-interviews Less
↳
It should a simple question if you have worked with computers & HDDs. RAID 0 - Block striping (req. 2 HDDs) and no mirroring or parity RAID 5 - Block striping with 1 dedicated parity drive (req. 3 HDDs) Less
A UNIX fie system has been reported at 100% full. You log in and clear what appears to be the offending file. However, the file system still reports to be 100% full. What could cause this?>
3 Answers↳
Use the lsof utilty (List Open Files) to identfy the process
↳
Kill or restart the process which has been still looking for deleted file
↳
In this case the answer accepted was. "The file that you cleared was still open by the calling application. The file handle was still in use and the file system was not recognizing that the space had been released. Less
can you host multiple https sites with different domain names but same IP on the same server? how
2 Answers↳
The way question posed, the answer is YES, since you could cover all those https sites with a single certificate. But now this should even work for individual certificates http://en.wikipedia.org/wiki/Server_Name_Indication Less
↳
NO, server cant tell which site is which because traffic is encrypted.
How do you represent a real-world quantity in a digital system?
1 Answers↳
What he really wanted me to do was draw the schematic of an ADC input circuit. I don't know why he didn't just ask that in the first place. Since it was a broad question, I spent over 5 minutes explaining binary representation, word size (8/16/32bit), endian-ness, and finally when I mentioned ADCs, he latched onto that and tried to get me to dig deeper. So I drew a block diagram of an ADC, focusing mostly on the interface to the microcontroller, and the channel select multiplexer. He grew increasingly frustrated and tried to get me to draw more detailed sub-circuits for each of the blocks in my diagram. Finally, I got to the actual ADC front end, and I drew a classic textbook R2R ladder circuit, and he seemed satisfied with that. By that point we had spent over 10 minutes in an interview where he was already complaining that he had a lot of ground to cover in limited time. I was so frazzled by the question that I did not even think of mentioning a successive approximation ADC as an alternative to the R2R, even though it's a much more common implementation in my experience. Less
If the customer was on the phone angry and pressuring to get the system back online but you didn't know what the issue was how would you deal with the situation
1 Answers↳
Try to keep the customer informed while solving the problem. Makey them feel their problem is the only issue your focused on. Show the customer sucess no matter how little to gain their confidence. Less
What would you do if you were told to just reproduce an existing report for requirements?
1 Answers↳
ie as a system analyst you need to evaluate the report, determine if there is an existing report that would meet needs, determine what within existing report is used and how to determine what true requirements are Less
How would you perform an application upgrade?
1 Answers↳
1. Review documentation/ release notes. 2. List/ Review the steps in the upgrade. 3. Get the other parties involved to set aside time. 4. Then I would look at the media, and take any backups if needed. 5. I would set up a time which i would communicate to the users asking them to stay out of the system. 6. Complete the upgrade 7. Communicate with the users that it is ok to log back in to the system. Less
How would you respond to a customer who encountered a problem with a product or service.
1 Answers↳
First, try and reproduce the problem and if the problem could be reproduced acknowledge there was an issue, give thanks for bringing this to the company's attention, and apologize for the customer's encounter with the issue. Offer possible solutions or workarounds while the team worked to correct the issue. Less