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

Questions 6–10

1. 6expert · hard

   A database has a table Orders and a table OrderDetails. When an order is deleted, all related order details must also be deleted. The application currently deletes orders using a stored procedure, but some users have direct DELETE permissions. You need to ensure that deleting an order always removes its details, regardless of the method. However, you also need to minimize the impact on the stored procedure's performance. What should you do?

   • ACreate an AFTER DELETE trigger on Orders that deletes the related OrderDetails rows.
   • BCreate a view that joins Orders and OrderDetails and rely on cascading deletes.
   • CCreate a scalar function that deletes the order details and call it from the stored procedure.
   • DModify the stored procedure to delete OrderDetails before deleting the order.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A team of analysts needs to query a set of columns from several joined tables, but they should not see sensitive columns such as salary. You need to provide a simple way for them to access the allowed data without granting direct table permissions. The solution must allow them to use the object in their own queries. What should you create?

   • AA stored procedure that returns the allowed columns and grant EXECUTE
   • BA scalar function that returns the allowed columns
   • CA view that selects only the allowed columns and grant SELECT on the view
   • DA trigger that copies allowed columns to a separate table
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   A developer wants to create a reusable SQL function that takes a product ID and returns the product's price as a single decimal value. Which type of function should the developer create?

   • AA stored procedure
   • BA table-valued function
   • CA scalar function
   • DA trigger
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A database developer needs to provide a simplified, reusable interface to a complex join of several tables while also restricting which columns and rows users can see. Which SQL object should the developer create?

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

   Which event can cause a trigger to fire in SQL Server?

   • AAn INSERT statement that adds a row to the table
   • BA stored procedure that is executed with EXEC
   • CA SELECT statement that reads data from the table
   • DA CREATE TABLE statement that creates a new table
   Reveal Solution Discussion Select an answer first