One of the key differences between operational systems and data warehouses is:操作系统与数据仓库关键不同之处在于::()?
(A)Operational systems focus on data quality; data warehouses focus on data security操作系统聚焦在数据质量,数据仓库聚焦在数据安全
(B)Operational systems focus on current data; data warehouses contain historical data操作系统聚焦在当前的数据,数据仓库包含历史数据
(C)Operational systems focus on historical data; data warehouses contain current data操作系统聚焦在历史数据,数据仓库包含当前的数据
(D)Operational systems are available 24x7; data warehouses are available during business hours操作系统是7x24在线的,数据仓库只在工作时间运行
(E)Operational systems focus on business processes; data warehouses focus on business strategies操作系统聚焦在业务流程,数据仓库包含当前数据 答案解析: 该题的是OLTP和OLAP的区别应用系统(OLTP)聚焦是当前的数据,因为MYSQL也好,ORACLE也好,其实是不能放海量的数据的,OLTP完成的是事务型的工作,如订单事务分析系弘(OLAP),其实就是数仓,聚焦在所有历史数据的挖掘,分析,给出相关的报表,给出决策推断和建议
更多CDMP数据治理试题
- 1Initiatives focused on building a single view of customer’ mainly rely on which DMBOK knowledge area?侧重于构建“单一客户视图”的计划主要依赖于哪个DMBOK知识领域?:()?
- 2In the DAMA-DMBOK.data custodians, including architects, modelers and DBAs, are responsible for在DAMA-DMBOK中。数据保管人(包括架构师、建模师和DBA)负责:()?
- 3Which of the following BEST characterizes a planning-level data architecture?以下哪一项是规划级数据架构的最佳特征?:()?
- 4数据管理成熟度评估后识别行动并创建的路线图中,不应包括哪个内容?(单选题)
- 5请从下列选项中选择对实施数据仓库的过程中路线图的用途描述正确的选项?(单选题)
- 6A document management system is an application used to track and store electronic documents and electronic images of paper documents which provides the following capabilities:文档管理系统用来追踪和存储电子文件,以及从纸质文件扫描而成的图片资料,它提供以下的功能::()?