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

Questions 31–32

1. 31foundation · easy

   What is a distinguishing feature of a table-valued function compared to a scalar function?

   • AIt cannot accept input parameters.
   • BIt returns a table data type that can be used in a FROM clause.
   • CIt automatically executes when a table is modified.
   • DIt can only be used in a SELECT list, not in a FROM clause.
   Reveal Solution Discussion Select an answer first
2. 32application · medium

   A database administrator needs to provide a way for an application to insert a new customer record and then automatically create a welcome notification record. The application currently performs the insert directly, and you cannot change the application code. What should you create to ensure the notification is created automatically?

   • AA stored procedure that inserts the customer and creates the notification
   • BA scalar function that inserts the customer and creates the notification
   • CA view that inserts the customer and creates the notification
   • DAn AFTER INSERT trigger on the customer table
   Reveal Solution Discussion Select an answer first