CertPrepNow
MicrosoftDP-80096 cards3 domains

DP-800 Flashcards

Active recall study cards for the Microsoft Certified: SQL AI Developer Associate exam. Flip each card to reveal the answer, filter by domain, or shuffle for spaced repetition.

0 / 96 cards reviewed0% done
x
Card 1 of 96
design-develop-database-solutions

What are the five specialized table types in SQL Server that the DP-800 exam tests?

Click to reveal answer

Answer

In-memory (MEMORY_OPTIMIZED), temporal (system-versioned with auto-managed history table), external (references data outside the database), ledger (tamper-evident with cryptographic hashing), and graph (node and edge tables).

Click to flip back

Tip: Use Space to flip, / to navigate

Ready for the real thing?

Take a timed DP-800mock exam to test what you've learned.