Normally for two or three fixed options I prefer to have a single selectButton, like the one below:
If there are around 10 items for selection, a single dropdown would be useful, like the example you put.
For more than 10 items I would suggest a search and select dropdown.
PS: I know this is not the channel for DB discussions, but in your table I would ...
Another option for easily finding all the categories could be to have a
search built in the category dropdown and in the subcategory dropdown as well (only if it makes sense there since it is already filtered by the category name and the options are reduced.) The first 2-3 rows can also be dedicated for suggestions in the dropdowns.