What fields should be in the promo_codes table?
Middle
171
System Analyst
2753
0
How detailed were the tasks described to you?
Middle+
170
What is the data format transmitted in Kafka messages?
Middle
170
Have you used annotations to describe database modification requirements?
Middle
169
What did the collaboration on tasks look like — one analyst per task or jointly on larger ones?
Middle+
169
What is the difference between PUT and PATCH?
Middle
169
Describe your experience working as a systems analyst: what artifacts did you create, how did you work with requirements?
Middle
169
What are indexes and what are they used for? How do indexes appear in a database?
Middle+
169
How is delivery guaranteed in Kafka? Describe the entire chain from preparation to processing by the receiver.
Middle+
169
What will the library database output table look like?
Middle+
169
What is meant by passing parameters in the request body?
Middle+
168
Describe the data flow when buying a book — the client is authorized, on the book page, wants to buy it. Where does the API Gateway request go?
Middle
168
What exactly did you need to clarify — about helicopters or about teleportation?
Middle+
168
What needs to be added to the analytics to make it clear to the developer how to obtain the full dataset during pagination?
Middle
168
select * from a left join b on a.a=b.b
Middle
168
Describe your vision of the work of a business analyst: what should they do, what should be their output, and what is their main task?
Middle+
168
How did you interact with the testing team? Describe the testing process.
Middle
167
Describe the algorithm of the GET /tables/{id} method: how is the response filled, and where does the data for mapping come from?
Middle+
167
What does COUNT(l.loan_id) AS loan_count mean in an SQL query?
Middle+
167
How to optimize the performance of database queries without increasing the data volume?
Middle
167