ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 7 question 20 discussion

Actual exam question from Microsoft's DP-300
Question #: 20
Topic #: 7
[All DP-300 Questions]

HOTSPOT -
You have a database on a SQL Server on Azure Virtual Machines instance.
The current state of Query Store for the database is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
by Fer079 at Dec. 22, 2022, 7:32 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Fer079
Highly Voted 2 years, 3 months ago
The right answer is: none of the Max Size (MB) The first answer is "none of the" because the Operation Mode (actual) is "Read only" so it is not retaining any query for evaluation due to the Query Store Available is 0.0 MB. When the actual state is read-only, use the readonly_reason column to determine the root cause. Typically, you find that Query Store transitioned to read-only mode because the size quota was exceeded. In that case, the readonly_reason is set to 65536 Consider the following steps to switch Query Store to read-write mode and activate data collection: * Increase the maximum storage size by using the MAX_STORAGE_SIZE_MB option of ALTER DATABASE or * Clean up Query Store data https://learn.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store?view=sql-server-ver16#Verify
upvoted 20 times
U_C
2 years ago
The right answer should be: all Max Size (MB) If SQL Server Query Store is in read-only mode, it retains all the queries for evaluation. The purpose of the read-only mode is to prevent any modification to the data in the Query Store. However, it still allows all the read operations, including the ability to retrieve and analyze the stored queries. The Query Store is a feature introduced in SQL Server 2016, which captures a history of queries and their execution statistics. It provides the ability to monitor and evaluate query performance, identify query regressions, and optimize queries. When the Query Store is set to read-only mode, it does not accept any modifications, but it still retains all the queries that were executed on the server.
upvoted 4 times
...
licna
2 years, 3 months ago
The Query Store still contains 1MB of data captured. Can't it be used for an evaluation? "Read only" mode means that QS won't store any more data until there is a free space (Purge / Increase Max size / Size Based Cleanup Mode = Auto).
upvoted 2 times
Fer079
2 years, 3 months ago
It depends on the interpretation of "will retain" * If "will retain" means to keep the existing queries then the answer would be different * If "will retain" means to keep the new (most recent) queries then the answer is "none of the". In my opinion, it refers to capture new queries, and yours?
upvoted 2 times
...
...
...
bingomutant
Most Recent 6 months ago
Chat - From the screenshot, here are the answers to the provided questions: Query Store will retain: "A selective set of" queries for evaluation because the capture mode is set to "Auto." In Auto mode, SQL Server retains a selective set of queries rather than all queries. To change Operation Mode (Actual) to Read write without losing any data, you must modify the: "Operation Mode (Requested)" setting. To change the actual operation mode to Read-Write, the requested operation mode must first be set to Read-Write. These answers align with the provided screenshot and the Query Store settings.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago