Global Query Filter is used for adding the data filtration criteria on a global level. So, you don't have to write the same code condition everywhere in the project.
Are you looking for a job in this domain? Here is a list of expected .NET interview questions and answers that will help you get through your next interview. Let's go for it:
The repository pattern is an abstraction layer between your database and business layer. The idea behind implementing the repository pattern is to hide the data persistence details.