DP-800 Practice Questions — Page 2

A procedure must accept optional filters for region, product category, and date range without introducing SQL injection risk.

Which implementation should you recommend?

A reporting query calls reusable business logic that returns a filtered rowset for each request.

Which object should you recommend?

A reporting solution needs to reuse a pricing rule across many queries. The rule must be composable inside SELECT statements and must not require repeated code in each report.

Which object should you create?

An ETL package depends on predictable return codes and output values from a stored procedure.

Which design should you recommend?

A JSON payload from an application contains nested order items that must be split into relational rows during ingestion.

Which feature should you use?

A hierarchy of managers and employees must be queried to return each employee's full reporting path. The depth of the hierarchy can vary over time.

Which technique should you use?

A payments workflow must prevent lost updates when multiple sessions edit the same rows concurrently.

Which action should you recommend?

A procedure joins a base table to a function that returns top related rows for each input row.

Which operator is most appropriate?

A query must combine two result sets while removing duplicate rows.

Which operator should you use?

A row-by-row cursor updates summary data for thousands of accounts and is becoming a bottleneck.

Which action should you recommend?