dp-900 Practice Question 1824
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 troubleshooting a performance issue with a SQL Server database where the `Inventory` table is experiencing high read latency. The `Inventory` table is related to the `Suppliers` and `Products` tables through foreign keys. What action should you take to improve the read performance of the `Inventory` table?
Answer Options
A
Increase the size of the SQL Server buffer pool.
B
Add an appropriate index on the `Inventory` table to improve read performance.
C
Disable all non-clustered indexes on the `Inventory` table to reduce overhead.
D
Use a different storage engine for the `Inventory` table.
Correct Answer
B: Add an appropriate index on the `Inventory` table to improve read performance.
Explanation
The correct answer is B. To improve the read performance of the `Inventory` table, you should consider adding an appropriate index on the columns that are frequently used in WHERE clauses or JOIN conditions.