CMS专题
单选题You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to
题目
MERGE
SELECT …CROSS JOIN
INSERT ALL …SELECT
CREATE VIEW …CONSTRAINT
参考答案和解析
相似问题和答案
第1题：
● Business intelligence (BI) is the integrated application of data warehouse, data mining and (73)．
（73）
A．OLAP
B．OLTP
C．MRPII
D．CMS．
试题（73）分析
商业智能BI是数据仓库，OLAP和数据挖掘等技术的综合应用。
OLAP联机分析处理是共享多维信息的、针对特定问题的联机数据访问和分析的快速软件技术。它通过对信息的多种可能的观察形式进行快速、稳定一致和交互性的存取，允许管理决策人员对数据进行深入观察。
On-Line Transaction Processing联机事务处理系统(OLTP)，也称为面向交易的处理系统，其基本特征是顾客的原始数据可以立即传送到计算中心进行处理，并在很短的时间内给出处理结果。
MRPII是制造资源计划Manufacturing Resource Planning的缩写；
CMS是Content Management System的缩写，意为"内容管理系统"，它具有许多基于模板的优秀设计，可以加快网站开发的速度和减少开发的成本。CMS的功能并不只限于文本处理，它也可以处理图片、Flash动画、声像流、图像甚至电子邮件档案。
因此选A
参考答案
（73）A
第2题：
A. Application Layer
B. Presentation Layer
C. Data Link Layer
D. Physical Layer
第3题：
Exhibit: You are developing a Web application. The Web application uses a GridView control to display data. You build your Web Forms for the Web application by dragging and dropping tables from the Data Connections tree in Server Explorer. You need to add a connection to your data by using the Add Connection dialog box as shown in the exhibit. During the process, you need to configure the .NET Data Provider that you use to create the data source objects. What should you do?（）
A. Right-click the connection, and click Properties. Modify the Provider property of the data connection.
B. Click the Change button, and change the data provider for the selected data source.
C. Click the Advanced button, and change the Data Source property to the target provider.
D. Click the Advanced button, and change the Application Name property to the target provider.
第4题：
You work as an application developer at Certkiller .com. You are currently in the process of creating a new application for Certkiller .com. You are required to read compressed data files that has been sent by Certkiller .com‘s sales offices.These data files are less than 4 GB in size, but was compressed without cyclic redundancy. You want to write a method that receives the compressed files and return the uncompressed data as a byte array.What should you do?（）
A.
B.
C.
D.
第5题：
You install a custom application on a computer that runs Microsoft Windows XP. The application stores each user’s data in the %programfiles%\app1\data folder on the computer. You install the custom application on a computer that runs Windows Vista.On the Windows Vista computer, you back up the %programfiles%\app1\data folder and notice that the backup contains no data.You need to back up the application’s user data on the Windows Vista computer.What should you do?（）
A.A
B.B
C.C
D.D
第6题：
Business intelligence （BI） is the integrated application of data warehouse, data mining and （73）．
A.OLAP
B.OLTP
C.MRPII
D.CMS
商业智能BI是数据仓库，OLAP和数据挖掘等技术的综合应用。OLAP联机分析处理是共享多维信息的、针对特定问题的联机数据访问和分析的快速软件技术。它通过对信息的多种可能的观察形式进行快速、稳定一致和交互性的存取，允许管理决策人员对数据进行深入观察。On-LineTransactionProcessing联机事务处理系统（OLTP），也称为面向交易的处理系统，其基本特征是顾客的原始数据可以立即传送到计算中心进行处理，并在很短的时间内给出处理结果。MRPII是制造资源计划ManufacturingResourcePlanning的缩写；CMS是ContentManagementSystem的缩写，意为"内容管理系统"，它具有许多基于模板的优秀设计，可以加快网站开发的速度和减少开发的成本。CMS的功能并不只限于文本处理，它也可以处理图片、Flash动画、声像流、图像甚至电子邮件档案。因此选A
第7题：
Business intelligence (BI) is the integrated application of data warehouse data mining and ______
A．OLAP
B．OLTP
C．MRPII
D．CMS
第8题：
A.database tier
B.application tier
C.client (desktop) tier
D.both database tier and application tier
第9题：
A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into ( ). Which store subsets of data from a warehouse.
A.OLTPs
B.transactions
C.data sarts
D.OLAPs
第10题：
A.
B.
C.
D.