Describe Relational Concepts DP-900 Practice Questions (Page 9)

Questions 41–43

1. 41foundation · easy

   What is a view in a relational database?

   • AA saved SQL query that presents data as if it were a table
   • BA physical copy of a table stored separately
   • CA backup of the database
   • DA type of index used to speed up queries
   Reveal Solution Discussion Select an answer first
2. 42expert · hard

   A database has a table called Inventory with columns ProductID, Quantity. The business rule states that when a sale is recorded in the Sales table, the Inventory quantity must be decremented automatically. However, the sales application sometimes inserts sales records in bulk, and the inventory updates are slow. The DBA is considering using a trigger. What is the main trade-off of using a trigger for this requirement?

   • ATriggers run automatically but can add overhead to every insert, potentially slowing bulk operations.
   • BTriggers only fire on UPDATE, not INSERT, so they would not work here.
   • CTriggers cannot access the inserted rows, so they cannot decrement inventory correctly.
   • DTriggers require manual execution by the application, which is error-prone.
   Reveal Solution Discussion Select an answer first
3. 43foundation · easy

   When does a trigger execute?

   • AWhen a backup is performed
   • BWhen the database server starts up
   • CWhen a specified database event occurs, such as an INSERT or UPDATE
   • DWhen a user manually runs it
   Reveal Solution Discussion Select an answer first