DP-300 Question #411: Real Exam Question with Answer & Explanation

Question

SIMULATION You need to increase the maximum storage size of the query store on db1 to 4,000 MB. You may need to use SQL Server Management Studio and the Azure portal. Answer: How to increase the maximum storage size of the query store for an azure database using Azure portal? How to increase the maximum storage size of the query store for an azure database using SQL Server Management Studio? To increase the size of Azure Query Store, you can use Transact-SQL within either SSMS (SQL Server Management Studio or the Azure portal. Specifically, you'll need to modify the MAX_STORAGE_SIZE_MB setting for the database. No GUI options exist for direct modification within the Azure portal. Step 1: Connect to your database: Use SSMS or the Azure portal to connect to the database where you want to increase the Query Store size. [Connect to db1] Step 2: . Execute the ALTER DATABASE statement: Run the following Transact-SQL query (replacing YourDB with your database name and 1024 with the desired storage size in MB): ALTER DATABASE [YourDB] SET QUERY_STORE (MAX_STORAGE_SIZE_MB = 1024); *-> Use the following query: ALTER DATABASE db1 SET QUERY_STORE (MAX_STORAGE_SIZE_MB = 4000); Step 3: Apply changes: The Query Store will automatically adjust to the new size. Reference: https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance- by-using-the-query-store

Options

• taskIncrease the maximum storage size of the query store on db1 to 4,000 MB.
• prerequisitesSQL Server Management Studio and Azure portal access.