Question 750
A payments team wants a completely non-durable memory table for transactions that must survive server restarts and full recovery. Which action best addresses the database requirement?
Explanation
Correct Answer
Critical records require durability; an in-memory object optimized for speed must still meet the data-loss objective.
Incorrect Answers
Benchmark an eligible memory-optimized table and verify platform support, durability choices and query patterns before migration: benchmark an eligible memory-optimized table and verify platform support, durability choices and query patterns before migration: in-memory optimization can help selected workloads but carries compatibility and durability considerations; Reject non-durable storage for financial records and select durable transactional persistence with verified recovery semantics.
Evaluate an eligible external table or supported virtualization option with explicit source credentials and format definitions: evaluate an eligible external table or supported virtualization option with explicit source credentials and format definitions: external tables expose remote data under a schema while leaving the authoritative storage outside the local table.
Evaluate graph node and edge tables with supported pattern queries for the relationship traversal use case: evaluate graph node and edge tables with supported pattern queries for the relationship traversal use case: graph structures represent relationships directly and can simplify traversals that otherwise require repeated joins.



Developing AI-Enabled Database Solutions (DP-800) Practice Tests