SQL AI Developer Associate
Question 1
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 catalog table stores flexible product attributes such as dimensions and regional labels. The reporting team must query common attributes efficiently. Which design should you recommend?
- AStore frequently queried attributes in relational columns and reserve JSON for less-structured fields.
- BMove every attribute into a single nvarchar(max) field.
- CAvoid indexing because attributes might change later.
- DStore prices only in application memory.