PipelinePresenter#expose_security_dashboard executes one query per file type
As a follow up of !34648 (merged)
PipelinePresenter#expose_security_dashboard?
executes batch_lookup_report_artifact_for_file_type
per file type, making at least 6 SQL queries so far (plus the ones needed for authorization).
Doing 6 queries to get a boolean response it's a bit over-engineering and can lead to ~performance problems. It'd be better to get all the information in a single query