Quiz: Query Store Basics Quiz: Query Store Basics ๐ฌ "Can I get a query for $1?" 1) Which Editions of SQL Server support Query Store?*For this question, consider "Editions" as Enterprise, Standard, Web, Express, and Azure SQL Database (I'm stretching the limits of the term, I know)Select oneAll editionsEverything except Express EditionEverything except Azure SQL DatabaseEnterprise Edition only2) Which versions of SQL Server support Query Store?*I counted Azure SQL Database as an "edition" (huge faux pas), so for versions I'm just talking about the "boxed product" / "the kind you install yourself" / "not database as a service" here. Words are hard.Select oneSQL Server 2008R2+SQL Server 2012+SQL Server 2014+SQL Server 2016+3) You enable/disable and configure Query Store at the _____ level.*Select oneInstanceDatabaseTableQuery4) Can you use Query Store to record or control the behavior of queries running against a readable secondary in an Always On Availability Group?*Select oneYes, it can record activity and you can control queriesSort of, you cannot record activity but you can control queriesSort of, you can record activity but you can't control queriesNo, you cannot record activity or control queries5) In which of the following databases can you NOT enable Query Store?*Select onemsdbmodeltempdbany user database Share this:Click to share on Facebook (Opens in new window)Click to share on Twitter (Opens in new window)Click to email this to a friend (Opens in new window)Click to share on Reddit (Opens in new window)