The cafe wants a single source of truth. The team proposes copying POS, CRM, and inventory exports into one spreadsheet every night. Which assessment is strongest?

Question

BlackTom AI · Accepted Answer

A single source of truth (SSoT) requires consistent definitions, authoritative data ownership, automated/transactional pipelines, clear lineage, and timely updates — not just a centralized file.

Relevant knowledge points: SSoT is about governance (who owns fields and definitions), automation (reduces human error and latency), data lineage and consistency (transactions and timestamps must align), version control and access control, and operational integration (real-time or near-real-time updates if operations depend on it).

Step-by-step reasoning:
1. Define SSoT criteria: consistent definitions, single owner, automated ingestion, reliable timestamps, and maintainable updates.
2. Evaluate nightly spreadsheet copy against each criterion:
   - Definitions: POS, CRM, and inventory often use different keys and semantic definitions (e.g., “sale” vs “transaction”); copying does not resolve semantic mismatches.
   - Ownership: Exports retain original ownership; the spreadsheet becomes an unmanaged aggregation without clear field stewards.
   - Automation and timing: Nightly batch introduces latency and can miss intra-day corrections; no transactional guarantees.
   - Lineage and version control: Manual export/copy risks overwrites, missing metadata, and reconciliation burdens.
   - Operational updates: If operations change (schema changes, timezone, business rules), nightly copying doesn’t enforce coordinated updates.
3. Acknowledge short-term benefit: Centralizing exports into one spreadsheet does improve ad-hoc or short-term reporting and is quick to implement.

Why the correct answer is correct: It captures both the short-term utility and the fundamental shortcomings of this approach — fragmented definitions, timing mismatches, unclear ownership, and brittle operational maintenance — therefore it is not a durable SSoT.

Why other options are weaker:
- Option 1 (temporary data mart) is too optimistic and omits the fragmentation/Governance issues.
- Option 2 (immediate cloud ERP replacement) is prescriptive and may be unnecessary/expensive; it ignores valid short-term needs.
- Option 3 (reasonable crawl step if documented) underestimates the persistence of timing/ownership fragmentation even with documentation.

Conclusion: The strongest assessment is the provided answer: it may help short-term reporting, but is not a durable single source of truth for the reasons above.

The cafe wants a single source of truth. The team proposes copying POS, CRM, and inventory exports into one spreadsheet every night. Which assessment is strongest?单项选择题

类似问题

As AI drafts reports, which human PM responsibility grows most?

Question at position 9 True or False: Data governance ensures delivery of correct information to authorized stakeholders at the right time.TrueFalse

Question at position 10 True or False: Data governance ensures delivery of correct information to authorized stakeholders at the right time.TrueFalse

Question at position 11 True or False: Data governance ensures delivery of correct information to authorized stakeholders at the right time.TrueFalse

Question at position 2 Which of the following is NOT a listed objective of a data management strategy?Ensuring data availability and accuracySafeguarding data securityIncreasing user entertainmentMitigating compliance risksClear my selection

An analyst downloads sensitive health data without approved access controls. Which area is failing most directly?

Which database role is primarily responsible for enterprise-wide decisions about how data is acquired, shared, and protected across the entire organization?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单