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、OLTPsB、transactionsC、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.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-infoB.Master-binlogC.Include-log-fileD.Master-data

2.How can data quality be quantified in the data warehouse?如何来量化数据仓库中的数据质量？

3.For which of the following is a data warehouse optimized?()A.Backup and recoveryB.TransactionsC.SecurityD.Queries

4.In data communication, data link is those parts of two data terminal equipments that are controlled by a protocol along with the(71) data circuit, which together enable data(72). So-called protocol means, in short, a set of rules that determines the behavior. of functional units in achieving communication.Data circuit, however, consists of a pair of(73) transmission channels that provides a means of two-way data transmission. Between data switching exchanges, the data circuit may or may not include data circuit-terminating equipment (DCE), depending on the type of(74) used at the data switching exchange. Between a data station and a data switching exchange or data concentrator, the data circuit includes the DCE at the data station end, and may include equipment(75) to a DCE at the data switching exchange or dam concentrator location.A．handshakingB．interconnectingC．linkageD．joining

更多“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、OLTPsB、transactionsC、data sartsD、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题：

    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
    解析：
    数据仓库是一个面向主题的用于报告和分析的数据集。数据仓库可以细分为数据集市，即从一个仓库中存储数据的子集。A．联机事务处理 B．交易 C．数据集市 D．联机分析处理

  • 第3题：

    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

  • 第4题：

    Which Coherence caching pattern matches the sequence of events ？（）  1. Data is requested from cache  2. The requested data does not exist in the cache （cache miss）  3. The Coherence cache store is used to red data from the back-end persistent data source， and placed in ther cache  4. Data requested from the cache is returned to the caller

    • A、 read through
    • B、 write through
    • C、 refresh ahead
    • D、 write behind

    正确答案:A

  • 第5题：

    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

  • 第6题：

    The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）

    • A、The data file cannot be recovered.
    • B、The date file can be restored from theSYSTEMauto backup.
    • C、Take thetablespaceoffline，drop，kand re-create it.
    • D、Recovery Manager （RMAN） is used to recover the data file.
    • E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

    正确答案:A

  • 第7题：

    Which two statements are true regarding Oracle Data Pump（）

    • A、EXPDP and IMPDP are the client components of Oracle Data Pump.
    • B、DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
    • C、Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
    • D、Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
    • E、EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

    正确答案:A,B

  • 第8题：

    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

  • 第9题：

    Which property of the ListView class is used to get/set the name of the data field whose value exclusively identifes every data row of a ListView when the ClientIDMode property is set to Predictable？（）

    • A、LoadViewStateByID
    • B、UniqueID
    • C、ClientIDMode
    • D、ClientIDRowSuffix

    正确答案:D

  • 第10题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? （） 

    • A、You should create a cached data collection 
    • B、You should create an on-demand non-cached data collection 
    • C、You should create a scheduled non-cached data collection. 
    • D、You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.

    正确答案:C

  • 第11题：

    多选题
    Which three statements are true regarding the data types in Oracle Database 10g/11g?（）
    A

    Only one LONG column can be used per table

    B

    A TIMESTAMP data type column stores only time values with fractional seconds

    C

    The BLOB data type column is used to store binary data in an operating system file

    D

    The minimum column width that can be specified for a VARCHAR2 data type column is one

    E

    The value for a CHAR data type column is blank-padded to the maximum defined column width


    正确答案： C,E
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 数据仓库是一个面向主题的用于报告和分析的数据集。数据仓库可以细分为数据集市，即从一个仓库中存储数据的子集。 A：联机事务处理 B：交易 C://数据集市 D://联机分析处理

  • 第13题：

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

  • 第14题：

    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

  • 第15题：

    For which of the following is a data warehouse optimized?（）

    • A、Backup and recovery
    • B、Transactions
    • C、Security
    • D、Queries

    正确答案:D

  • 第16题：

    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

  • 第17题：

    Which three are true?（）

    • A、A MERGE statement is used to merge the data of one table with data from another.
    • B、A MERGE statement replaces the data of one table with that of another.
    • C、A MERGE statement can be used to insert new rows into a table.
    • D、A MERGE statement can be used to update existing rows in a table.

    正确答案:A,C,D

  • 第18题：

    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

  • 第19题：

    Which three statements are true about Oracle Data Pump export and import operations?（）

    • A、You can detach from a data pump export job and reattach later.
    • B、Data pump uses parallel execution server processes to implement parallel import.
    • C、Data pump import requires the import file to be in a directory owned by the oracle owner.
    • D、The master table is the last object to be exported by the data pump.
    • E、You can detach from a data pump import job and reattach later.

    正确答案:A,B,D

  • 第20题：

    Which three statements are true regarding the data types in Oracle Database 10g/11g?（）

    • A、Only one LONG column can be used per table 
    • B、A TIMESTAMP data type column stores only time values with fractional seconds 
    • C、The BLOB data type column is used to store binary data in an operating system file 
    • D、The minimum column width that can be specified for a VARCHAR2 data type column is one 
    • E、The value for a CHAR data type column is blank-padded to the maximum defined column width

    正确答案:A,D,E

  • 第21题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.  What process should you implement？（） 

    • A、You should create a cached data collection
    • B、You should create an on-demand non-cached data collection 
    • C、You should create a scheduled non-cached data collection 
    • D、You should create two different SQL Agent jobs that are scheduled stimultaneously

    正确答案:A

  • 第22题：

    多选题
    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


    正确答案： A,C
    解析： 暂无解析

  • 第23题：

    多选题
    Which three are true? （）
    A

    A MERGE statement is used to merge the data of one table with data from another.

    B

    A MERGE statement replaces the data of one table with that of another.

    C

    A MERGE statement can be used to insert new rows into a table.

    D

    A MERGE statement can be used to update existing rows in a table.


    正确答案： D,B
    解析： 暂无解析

相关内容