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

Questions 1–5

1. 1foundation · easy

   Which statement accurately describes a key benefit of using a view in a SQL database?

   • AA view permanently stores a copy of the data from the underlying tables.
   • BA view can hide the complexity of joins and provide a security layer by exposing only selected columns.
   • CA view can be used to modify the schema of the underlying tables automatically.
   • DA view automatically improves query performance by caching the result set in memory.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A reporting application needs to retrieve all orders for a given customer, including order details, and the result must be used as a data source in a FROM clause of a larger query. The query logic is complex and will be reused in several reports. You want to encapsulate the logic while allowing the caller to filter further. What should you create?

   • AA scalar function that returns the order count for a customer
   • BAn inline table-valued function that takes a customer ID and returns orders
   • CA view that returns all orders for all customers
   • DA stored procedure that returns the orders
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A support team frequently runs a complex query that joins five tables and applies multiple filters to produce a daily report. They have no permission to modify the underlying tables, but they need a reusable object that always returns the latest data and hides the join complexity. You need to provide this capability with minimal maintenance overhead. What should you create?

   • AA stored procedure that returns the result set
   • BA view that encapsulates the joins and filters
   • CA scalar function that returns the report data
   • DA table-valued function that returns the report data
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A finance department needs to run a month-end process that validates data, updates multiple tables, and generates a summary report. The process must be repeatable and must run with a single command. You need to encapsulate the entire logic and ensure that it can be executed by users who do not have direct permissions on the underlying tables. What should you create?

   • AA trigger that runs the process automatically
   • BA scalar function that performs the updates and returns a status
   • CA view that performs the updates and returns the report
   • DA stored procedure that performs the validation, updates, and report generation
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A database must prevent deletion of a customer record if the customer has open orders. The check must be enforced regardless of which application or user attempts the deletion. You need to implement this rule at the database level. What should you create?

   • AAn INSTEAD OF DELETE trigger on the customer table
   • BA view that hides the customer table
   • CA stored procedure that checks and deletes
   • DA scalar function that checks for open orders
   Reveal Solution Discussion Select an answer first