Question 920
A document system stores frequent thumbnails in a relational table and rare multi-gigabyte originals in object storage. The team is considering this step: Store governed object references in SQL and large files in approved secure storage. What evidence should they review before proceeding?
Explanation
Correct Answer
Analyze document sizes, latency, transactional consistency and required access control. Keeping large binary payloads outside hot rows can reduce transactional IO and backup pressure. Metadata reads remain efficient and access to originals is authorized and auditable.
Incorrect Answers
Hot metadata should remain narrow and large originals can use governed object storage with references.
Object-store access needs identity, expiry, lifecycle and audit policy independent of SQL reference access.
Cross-store operations need consistency handling, retry, reconciliation and lifecycle controls. The pertinent evidence includes: Analyze document sizes, latency, transactional consistency and required access control.