Exam 70-762 topic 1 question 75 discussion

Actual exam question from Microsoft's 70-762

Question #: 75
Topic #: 1

DRAG DROP -
You have a Microsoft Azure SQL Database named MyDb that uses server version V12.
You plan to use Query Performance Insight to troubleshoot performance problems. The database query store is not enabled.
You need to enable the database query store to meet the following requirements for the database:
✑ Statistics must be aggregated every 15 minutes.
✑ Query stores must use no more than 1,024 megabytes (MB) of storage.
✑ Query information must be retained for at least 15 days.
✑ Queries must be captured based on resource consumption.
You connect to the database by using SQL Server Managements Studio.
How should you complete the Transact-SQL statements? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: More than one combination of answer choices is correct. You will receive credit for any of the correct combinations you select. Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

Both answers are correct.
References:
https://msdn.microsoft.com/en-us/library/mt604821.aspx

by Froze at April 4, 2020, 5:11 p.m.

Comments

Submit Cancel

Froze

Highly Voted 5 years, 2 months ago

There is one proper answer (last one) with CLEANUP_POLICY = ( STALE_QUERY_THRESHOLD_DAYS = 15 ). You cannot put INTERVAL_LENGTH_MINUTES into CLEANUP_POLICY().

upvoted 8 times

Anette

4 years, 11 months ago

Agree, 3 and 4 must change places

upvoted 1 times

Anette

4 years, 11 months ago

I mean, I am about only the second answer - not the first one

upvoted 1 times

...

blues198

Most Recent 4 years, 7 months ago

The last one is the right answer, e.g: ALTER DATABASE [QueryStoreDB] SET QUERY_STORE = ON ( OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = ( STALE_QUERY_THRESHOLD_DAYS = 90 ), DATA_FLUSH_INTERVAL_SECONDS = 900, QUERY_CAPTURE_MODE = AUTO, MAX_STORAGE_SIZE_MB = 1000, INTERVAL_LENGTH_MINUTES = 60, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON ); https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store?redirectedfrom=MSDN&view=sql-server-ver15

upvoted 3 times

...

smartrammy

4 years, 8 months ago

https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store?view=sql-server-ver15

upvoted 2 times

...

strikersree

4 years, 11 months ago

Last answer is correct.

upvoted 2 times

...