dp-900 Practice Question 1823
Exam: dp-900
Domain: Describe how to work with relational data on Azure
Topic: Describe relational data workloads
Difficulty: medium
Contoso Ltd is planning to migrate their SQL Server database from on-premises to Azure SQL Database. During the migration process, you notice that the `Employees` table has a large number of rows and is frequently queried. What action should you take to optimize the performance of this table in the Azure environment?
Answer Options
A
Increase the size of the Azure SQL Database buffer pool.
B
Partition the `Employees` table to improve query performance and manageability.
C
Disable all non-clustered indexes on the `Employees` table to reduce overhead.
D
Use a different storage engine for the `Employees` table.
Correct Answer
B: Partition the `Employees` table to improve query performance and manageability.
Explanation
The correct answer is B. In the Azure environment, you should consider partitioning the `Employees` table to improve query performance and manageability.