FEFreeExamDumps.in

SQL AI Developer Associate

Topic 1

Question 20

DP-800 is a newly released exam. These practice questions reflect our best current understanding — the exact wording and question formats may change in the live exam until the certification matures. Use them to learn the concepts, not to memorize.

DP-800 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.

Details →

A row-by-row cursor updates summary data for thousands of accounts and is becoming a bottleneck. Which action should you recommend?

  • ARewrite the operation as a set-based UPDATE or MERGE alternative.
  • BAdd more nested cursors.
  • CMove the logic to manual spreadsheet edits.
  • DDisable indexes on every table permanently.