Implement Programmability Objects DP-800 Practice Questions (Page 6)

Questions 26–30

1. 26foundation · easy

   A developer needs to automatically update an audit table whenever a row is inserted into the Products table. Which SQL object should be created to accomplish this?

   • AA view
   • BA trigger
   • CA stored procedure
   • DA scalar function
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   An order management system must automatically update the inventory quantity whenever a new order line is inserted. The update must happen as part of the same transaction as the insert, and no application code changes are allowed. What should you create?

   • AAn AFTER INSERT trigger on the order line table
   • BA stored procedure that inserts the order line and updates inventory
   • CA scalar function that updates inventory when called
   • DA view that updates inventory when queried
   Reveal Solution Discussion Select an answer first
4. 28expert · hard

   A manufacturing company has a stored procedure that updates the Inventory table and then inserts a record into the InventoryLog table. The procedure is called by a legacy application that does not handle multiple result sets well. You need to modify the procedure to return the new inventory level as an output parameter instead of a result set. The change must not break the existing logging behavior. What should you do?

   • AModify the stored procedure to use an OUTPUT parameter for the new inventory level and keep the logging INSERT inside the procedure.
   • BCreate an AFTER UPDATE trigger on the Inventory table to perform the logging, and remove the logging from the stored procedure.
   • CUse a scalar function to update the inventory and return the new level.
   • DCreate a table-valued function that returns the new inventory level and call it from the application.
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   A database developer needs to encapsulate a multi-step business process that includes data validation, updates to multiple tables, and error handling. Which SQL object is best suited for this task?

   • AA trigger
   • BA stored procedure
   • CA view
   • DA scalar function
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   Which characteristic is true of a scalar user-defined function in SQL Server?

   • AIt automatically runs when data in a table is modified.
   • BIt returns a single value and can be used in a SELECT statement as a column expression.
   • CIt can only be executed with the EXEC statement.
   • DIt returns a result set that can be joined to other tables.
   Reveal Solution Discussion Select an answer first