added end-to-end test per specifications for GitLab technical assessment

What does this MR do?

Adds end-to-end test per GitLab technical assignment.

Does this MR meet the acceptance criteria?

Conformity

• Changelog entry
• Documentation created/updated or follow-up review issue created
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides
• Separation of EE specific content