Question 5
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 →You are designing an Azure SQL Database solution for a retail company. The database must store orders, order lines, customers, and product catalogs. Finance reports depend on accurate historical totals, and the development team wants to minimize data anomalies when orders are updated. Which table design should you recommend?
- AStore customer address details in the Orders table so each order record is fully self-contained.
- BNormalize orders, customers, and products into separate tables and enforce relationships by using primary keys and foreign keys.
- CStore all order information as JSON documents in a single table to simplify application code.
- DDuplicate product price and tax rules in every order row and update them by using scheduled batch jobs.