You have an Azure SQL database named db1 on a server named server1.
The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention.
You need to resolve the performance issues.
What should you do?
A . Implement memory-optimized tables.
B. Run the dbcc flushprocindB command.
C. Replace the sequential index keys with nonsequential keys.
D. Run the dbcc dbreindex command.
Answer: A
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance#tempdb-contention
Latest DP-300 Dumps Valid Version with 176 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund