Developing Microsoft SQL Server Databases Free Practice Exam Questions

26 real Developing Microsoft SQL Server Databases exam questions with answers and AI explanations. Microsoft certification prep — page 1 of 3.

1. Question 1: You have a table named Table1 that stores customer data. Each customer has a credit limit that can only be discovered by querying multiple tables. You need to…
2. Question 2: You are creating a stored procedure named usp1. Usp1 will create a table that will be used during the execution of usp1. Only usp1 will be allowed to access th…
3. Question 4: You need to identify which long running transactions use an index. Which dynamic management view should you use?
4. Question 5: You have a text file that contains an XML Schema Definition (XSD). You have a table named Schema1.Table1. You have a stored procedure named Schema1.Proc1 that…
5. Question 6: You have a SQL Server instance named SQL\Instance1. Instance1 contains a database named Database1. You need to recommend an index defragmentation solution for…
6. Question 13: You need to modify the Orders table to store the XML data used by the retailers. Which statement should you execute?
7. Question 17: You have an index for a table in a SQL Azure database. The database is used for Online Transaction Processing (OLTP). You discover that many page splits occur…
8. Question 20: You need to encapsulate a T-SQL script into a reusable user-defined object. The object must meet the following requirements: ✑ Permit insertions into a table v…
9. Question 22: You have a Microsoft SQL Azure database named DBAzurel. DBAzurel contains a table named Orders that stores sales data. Each order has a sales total that can on…
10. Question 25: You need to modify usp_GetOrdersAndItems to ensure that an order is NOT retrieved by usp_GetOrdersAndItems while the order is being updated. What should you ad…