dp-900 Practice Question 1820
Exam: dp-900
Domain: Describe how to work with relational data on Azure
Topic: Describe relational data workloads
Difficulty: medium
Contoso Ltd is experiencing performance issues with their SQL Server database. You suspect that the issue might be related to the normalization level of their tables. Which of the following actions would you take to diagnose and potentially resolve the performance issue? Assume that the current schema includes multiple tables with relationships, and some tables are not normalized properly.
Answer Options
A
Run a query to check the number of indexes on each table.
B
Run a query to check the normalization level of each table and then normalize the improperly normalized tables.
C
Increase the memory allocation for the SQL Server instance.
D
Check the execution plan for the most frequently used queries to identify potential bottlenecks.
Correct Answer
B: Run a query to check the normalization level of each table and then normalize the improperly normalized tables.
Explanation
The correct answer is B. To diagnose and potentially resolve the performance issue, you should first run a query to check the current normalization level of the tables using INFORMATION_SCHEMA.TABLES. Then, you can normalize those tables by ensuring each table has a primary key and that there are no redundant columns or repeating groups.