软件水平考试

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.sartsD.OLAPs

题目
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
如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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


正确答案：C

第2题：

Which two statements are true regarding the USING clause in table joins?（）

  • A、It can be used to join a maximum of three tables 
  • B、It can be used to restrict the number of columns used in a NATURAL join 
  • C、It can be used to access data from tables through equijoins as well as nonequijoins 
  • D、It can be used to join tables that have columns with the same name and compatible data types

正确答案:B,D

第3题：

You need to dump the data from the master server and import it into a new slave server.Which mysqldump option can be used when dumping data from the master server in order to include the master server‘s binary log information?（）

A.Include-master-info

B.Master-binlog

C.Include-log-file

D.Master-data


参考答案：D

第4题：

A developer chooses to avoid using SingleThreadModel but wants to ensure that data is updated in athread-safe manner. Which two can support this design goal？（）

  • A、Store the data in a local variable.
  • B、Store the data in an instance variable.
  • C、Store the data in the HttpSession object.
  • D、Store the data in the ServletContext object.
  • E、Store the data in the ServletRequest object.

正确答案:A,E

第5题：

Which of the following is the correct configuration for a RAID 5 array?（）

  • A、A two disk set with one data strip
  • B、A three disk set with two data strips and a parity strip
  • C、A two disk set with two data strips
  • D、A four disk set with two sets of data strips

正确答案:B

第6题：

An application architecture specifies the technologies to be used to implement one or more information systems. It serves as an outline for detailed design, construction, and implementation. Given the models and details, include （ ）, we can distribute data and processes to create a general design of application architecture. The design will normally be constrained by architecture standards, project objectives, and （ ）. The first physical DFD to be drawn is the （ ）. The next step is to distribute data stores to different processors. Data（ ）are two types of distributed data which most RDBMSs support. There are many distribution options used in data distribution. In the case of（请作答此空）, we should record each table as a data store on the physical DFD and connect each to the appropriate server.

A.storing all data on a single server
B.storing specific tables on different servers
C.storing subsets of specific tables on different servers
D.duplicating specific tables or subsets on different servers

答案：B
解析：
应用架构说明了实现一个或多个信息系统所使用的技术，它作为详细设计、构造和实现的一个大纲。给定了包括逻辑数据流图和实体联系图在内的模型和详细资料，我们可以分配数据和过程以创建应用架构的一个概要设计。概要设计通常会受到架构标准、项目目标和所使用技术的可行性的制约。需要绘制的第一个物理数据流图是网络架构数据流图。接下来是分配数据存储到不同的处理器。数据分区和复制是大多数关系型数据库支持的两种分布式数据形式。有许多分配方法用于数据分布。在不同服务器上存储特定表的情况下，我们应该将每个表记为物理数据流图中的一个数据存储，并将其连接到相应的服务器。

第7题：

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

正确答案:C

第8题：

How can data quality be quantified in the data warehouse?

如何来量化数据仓库中的数据质量？


正确答案：
答：在数据仓库项目中，通常通过不规则数据的检测工作（Anomaly Detection）来量化源系统的数据质量。除非成立专门的数据质量调查项目组，否则这个工作应该由ETL项目组完成。通常可以采用分组SQL来检查数据是否符合域的定义规则。
对于数据量小的表，可以直接使用类似下面的SQL完成。
select state, count(*) from order_detail group by state
对于数据量大的表，一般通过采样技术来减少数据量，然后进行不规则数据检测。类似SQL如下。
select a.* from employee a, (select rownum counter, a.* from employee a) B where a.emp_id = b.emp_id and mod(b.counter, trunc((select count(*) from employee)/1000,0)) = 0
如果可以采用专门的数据概况分析工具进行的话，可以减少很大的工作量。

第9题：

Which two statements about subqueries are true? （）

  • A、A single row subquery can retrieve data from only one table.
  • B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
  • C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
  • D、A single row subquery can retrieve data from more than one table.
  • E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
  • F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

正确答案:B,D

第10题：

A Company.com developer chooses to avoid using SingleThreadModel but wants to ensure that data is updated in a thread-safe manner.  Which two can support this design goal？（）

  • A、 Store the data in a local variable.
  • B、 Store the data in an instance variable.
  • C、 Store the data in the HttpSession object.
  • D、 Store the data in the ServletContext object.
  • E、 Store the data in the ServletRequest object.

正确答案:A,E

更多相关问题
相关内容