Query store is a new powerful feature introduced in SQL 2016 which stores the query plan, statistics and query execution…