If the business asks to implement a new feature in a tight deadline, and the development says it's impossible with the current architecture — how would you act from a systems analyst role?
Middle
286
System Analyst
2738
0
What is the problem with highly normalized tables?
Middle
263
What SQL query should be written to list all users who did not place an order throughout the year?
Middle
244
How can tables be denormalized?
Middle
222
Tell about your nearly two years of experience working as a systems analyst: what product you worked with, how processes were built, what achievements and mistakes you had, and why you left the company?
Middle
221
How does a B-tree index work?
Middle
213
What business models and diagrams have you encountered in your work experience?
Middle
196
What do you pay attention to when looking for a job, what is important to you?
Middle
186
How else can database queries be accelerated?
Middle
186
Tell me about the system you worked with (POS, KDS, kiosks)
Middle
179
What was the trigger for leaving the company?
Middle
174
What databases have you worked with?
Middle
173
What is a loop, how does it differ from recursion, how does a function differ from a procedure, and why should you not perform many INSERTs?
Middle
164
What data type can be used for denormalization — to embed an entire table into a single field?
Middle
164
What is the difference between PUT and POST when designing a method for creating an order? What structures and errors can you encounter?
Middle
163
Additional criteria for choosing a job (organizational)?
Middle
156
If you have two tables with a many-to-many relationship, how is this implemented?
Middle
156
List the artifacts of a system analyst that you have created in your work.
Middle
155
Why is it not recommended to store everything in a JSON field?
Middle
154
Why are relational databases called relational?
Middle
147