dp-900 Practice Question 1822
Exam: dp-900
Domain: Describe how to work with relational data on Azure
Topic: Describe relational data workloads
Difficulty: medium
At Contoso Ltd, you are tasked with optimizing the performance of a SQL Server database that handles a large number of transactions per second. One of the tables, `Sales`, has a large number of rows and is frequently updated. What action should you take to improve the performance of this table?
Answer Options
A
Increase the size of the SQL Server buffer pool.
B
Add an appropriate index on the `Sales` table to improve query performance.
C
Disable all non-clustered indexes on the `Sales` table to reduce overhead.
D
Use a different storage engine for the `Sales` table.
Correct Answer
B: Add an appropriate index on the `Sales` table to improve query performance.
Explanation
The correct answer is B. To improve the performance of the `Sales` table, you should consider adding an appropriate index on the columns that are frequently used in WHERE clauses or JOIN conditions.