DBW301 (No True False)_1

.........systems focus on individual events. A. Data warehouse B. OLTP C. Business system D. OLAP

B

Degenerated dimensions ............ A. contain only one attribute B. contain many attributes C. contain no attribute D. contain a primary key and a fact value

B

Dimensional Modeling is suitable for............ A. OLTP systems B. Data warehouse systems C. OLTP and Data warehouse systems D. OLAP

B

In the dimensional model, the attributes of the data warehouse are divided into ..........and dimension tables A. center B. fact C. summary D. aggregate

B

MOLAP refers to ............OLAP. A. Multiple B. Multidimensional C. Many-to-Many D. Mix

B

What if the DBMS does not create an index on the primary key? A. Create a Bitmap index on the full primary key. B. Create a B-tree index on the full primary key C. Create a Bitmap index on the individual part of primary key. D. Create a B-tree index on the individual part of primary key.

B

What kinds of data mining algorithm try to simulate the human brain? A. Decision Tree B. Neuron Network. C. Support Vector Machine D. All of others

B

Which is the challenge of ETL? A. Source systems are usually in one platform. B. Source systems are very diverse and disparate. C. Specify all the source systems. D. None of the others

B

Which is the traditional data warehouse project life cycle? A. 1)Requirements definition 2)Project plan 3)Design 4)Construction 5)Deployment 6)Growth and maintenance B. 1)Project plan 2)Requirements definition 3)Design 4)Construction 5)Deployment 6)Growth and maintenance C. 1)Project plan 2)Requirements definition 3)Design 4)Construction 5)Deployment D. None of the others

B

Which method used for discovering interesting relations between variables in large databases? A. Clustering B. Association Rules C. Classification D. None of others

B

In data quality, which is (are) the Sources of Data Pollution? (choose one answer only) A. System Conversions B. Poor Database Design C. Heterogeneous System Integration D. All the others

D

Source data in data warehouse may come from: A. Production Data B. Internal Data C. Archived Data D. External Data E. All of others

E

Which is NOT a key issue while planning for your data warehouse? A. setting proper expectations B. assessing risks C. deciding between top-down or bottom-up approaches D. choosing from vendor solutions. E. requirement changes

E

............systems focus on individual events. A. Data warehouse B. OLTP C. Business system D. OLAP

B

........ focus is on how managers view the business. A. Data warehouse B. OLTP C. Business system D. OLAP

A

......... reveals business trends. A. Data warehouse B. OLTP C. Business system D. OLAP

A

........... acts as the glue that connects all parts of the data warehouse. A. Metadata B. ETL C. Operational Metadata Extraction and Transformation Metadata

A

............ systems capture details of events or transactions. A. OLTP B. Data warehouse C. OLAP D. Business Intelligence

A

............. indicator of high-quality data ensures the value stored in the system for a data element is the right value for that occurrence of the data element. A. Accuracy B. Domain Integrity C. Data Type D. Consistency

A

................. means populating all the data warehouse tables for the very first time. A. Initial load B. Incremental load C. Load all D. Load

A

...............represents the level of detail in the fact table. A. Data granularity B. Aggregation C. Data level D. Data size

A

...........means applying ongoing changes as necessary in a periodic manner. A. Incremental load B. Updating load C. Full refresh D. Immediate load

A

A fact is a measure taken at the .............of all the dimensions. A. intersection B. union C. combination D. cross

A

Bayesian classifiers is : A. A class of learning algorithm that tries to find an optimum classification of a set of examples using the probabilistic theory. B. Any mechanism employed by a learning system to constrain the search space of a hypothesis C. An approach to the design of learning algorithms that is inspired by the fact that when people encounter new situations, they often explain them by reference to familiar experiences, adapting the explanations to fit the new situation. D. None of thes

A

Data on salary may be represented as monthly salary, weekly salary, and bimonthly salary in different source payroll systems. What do you call the above problem in ETL? A. Inconsistency B. Consistency C. Diverse D. Multiple-form

A

Data on salary may be represented as monthly salary, weekly salary, and bimonthly salary in different source payroll systems. What do you call the above problem in ETL? A. Inconsistency B. Consistency C. Diverse D. Multiple-form

A

Dimension tables contain the ...... of analysis. A. criterions B. measurements C. facts D. values

A

ETL stands for ............... A. data extraction, transformation, and loading. B. data extraction, transaction, and loading. C. data extraction, transfer, and loading. D. data extraction, transformation, and launching.

A

Entity-Relationship Modeling is suitable for............ A. OLTP systems B. Data warehouse systems C. OLTP and Data warehouse systems D. OLAP

A

In ETL, .............tables are loaded first. A. Dimension B. Fact C. Dimension and Fact D. None of the others

A

OLAP systems provide ............. and roll-up capabilities. A. drill-down B. drop-down C. top-down D. up-down

A

ROLAP refers to ............OLAP. A. Relational B. Rapid C. Running D. Roll

A

Regarding to Star schema, which statement is NOT true? A. In star schema some dimension tables are normalized. B. In star schema each dimension is represented with only one dimension table. C. There is a fact table at the centre. This fact table contains the keys to each of dimension. D. None of the others.

A

The ............diagrams crystallize the information requirements for the data warehouse. A. information package B. star C. dimension D. ERD

A

The presence of ...........diagrams in the requirements definition document is the major and significant difference between operational systems and data warehouse systems. A. information package B. organization C. top leader D. data sources

A

The term metadata refers to............... A. "data about data" B. "structure of data" C. "quality of data" D. "how big data is"

A

What are the three major areas in the data warehouse? A. Data Acquisition, Data storage, Information delivery B. Data Collection, Data storage, Information delivery C. Data Acquisition, Database, Reporting System D. Data Acquisition, Data storage, Business Intelligence

A

Which algorithms discover patterns where one set of items follows another specific set? A. Sequential Pattern Discovery. B. Frequential Pattern Discovery C. Gradual Pattern Discovery D. All of others

A

Which algorithms used for cluster detection? A. K-Mean clustering B. Support Vector Machine C. Decision Tree D. None of others

A

Which dimension does a data warehouse usually have? A. Time B. Category C. User D. Invoice

A

Which is NOT Business Metadata? A. Data models of source systems B. Connectivity procedures C. Security and access privileges D. Data transformation business rules

A

Which is NOT Technical Metadata? A. Data transformation business rules B. Data aggregation rules C. Data cleansing rules D. Data models of source systems

A

Which is NOT metadata? A. Rows in tables B. Keys of tables C. Attributes in tables D. Tables in data warehouse

A

Which is the challenge of ETL? A. Historical data on changes in values are not preserved in source operational systems. B. Difficulties in finding the historical data. C. Historical data mixed with current data. D. None of the others

A

Which metadata focuses on providing support for the end-user at the workstation? A. Business metadata B. Technical Metadata C. Operational Metadata D. General Metadata

A

Which metadata is used for the IT staff responsible for the development and administration of the data warehouse? A. Technical Metadata B. Business metadata C. Operational Metadata D. General Metadata

A

Which operation allows an analyst to rotate the cube in space to see its various faces? A. Pivot B. Dice C. Roll-up D. Slice

A

Which operation allows the user to navigate among levels of data ranging from the most summarized to the most detailed? A. Drill Down B. Dice C. Roll-up D. Slice

A

Which statement is correct about global plan? A. Very simple schema (1 page) identifying the sources and the targets. B. Describe the transformation and loading procedures for each table. C. Source systems are hosted in very low performance systems. D. Series of diagrams which are very details.

A

Which statement is correct regarding to dimensional model? A. Every fact table has at least one Foreign Key. B. A fact value CANNOT be calculated from other attributes. C. Usually, the primary key of the fact table is an auto generated key. D. Dimension tables occupy of the storage capacity.

A

..... table contains the values we want to analyze. A. Fact B. Dimension C. Aggregate D. Center

B

............. indicator of high-quality data ensures the data value of an attribute falls in the range of allowable, defined values. A. Accuracy B. Domain Integrity C. Data Type D. Consistency

B

Which statement is correct? A. OLAP cube help us reduce the cost (time, CPU usage) of updating the data warehouse database. B. With OLAP cube, we are able to create data mining structure on this data which can be helpful in forecasting, prediction. C. OLAP is an optimized way to design the data warehouse system. D. None of the others.

B

Which statement(s) is (are) correct? 1) Maintaining metadata in a modern data warehouse is just for documentation. 2) Metadata is needed by IT for data warehouse administration. A. Only statement 1 B. Only statement 2 C. Both statement 1 and 2 D. None of the others

B

............. indicator of high-quality data ensures value for a data attribute is actually stored as the data type defined for that attribute. A. Accuracy B. Domain Integrity C. Data Type D. Consistency

C

Indexing in data warehouse database reduces performance of ........ A. Information delivery B. ETL C. Loading data into data warehouse D. OLAP

C

What type of service in SQL Server Business Intelligent used for developing the report? A.SSIS B.SSAS C.SSRS D.None of others

C

Which statement(s) is (are) correct? 1) Metadata provides information on predefined queries. 2) A metadata repository is like a general purpose directory tool. A. Only statement 1 B. Only statement 2 C. Both statement 1 and 2 D. None of the others

C

............ may answer questions on overall process. A. OLTP B. OLAP C. Business Intelligence D. Data warehouse

D

............. indicator of high-quality data ensures that there are no missing values for a given attribute in the system. A. Accuracy B. Domain Integrity C. Data Type D. Completeness

D

............. indicator of high-quality data ensures the form and content of a data field is the same across multiple source systems. A. Accuracy B. Domain Integrity C. Data Type D. Consistency

D

In a fact table, there are 3 kinds of attributes: (choose one answer only) A. Dimension foreign keys B. Degenerated dimensions C. Facts D. All the others

D

Regarding to data warehouse. Which statement is true? A. All indexes are always specified at the design time. B. All indexes are NOT always specified at the design time. C. All indexes are always specified at the maintenance time. D. Some indexes are specified at the design time, and some others are added at maintenance time.

D

What are the major factors of the relationship between Data warehouse and Data Mining? A. Data warehouse contains large volume of data. B. Data mining flourishes on integrated and cleansed data. C. Data warehouse's infrastructure for data warehouse is robust, with parallel processing and powerful relational database systems. D. All of others

D

What exactly do we mean by strategic information? A. Strategic information is important for the continued health and survival of the corporation. B. Strategic information is for the day-to-day operations of the business. C. It is intended to produce an invoice, make a shipment, settle a claim, or post a withdrawal from a bank account. D. The types of information needed to make decisions in the formulation and execution of business strategies and objectives are broad based and encompass the entire organization.

D

Which are the optimization strategies in data warehouse system? A. Use Index B. Aggregate Table C. Query Optimization D. All the other choices

D

Which are the optimization strategies in data warehouse system? (choose ONE answer only) A. Use Index B. Aggregate Table C. Query Optimization D. All the other choices

D

Which is NOT popular data warehouse architecture? A. Real B. Virtual C. Remote D. Distributed

D

Which is(are) the common transformation type(s)? (choose one answer only) A. Decoding of fields B. Conversion of units of measurements C. Character set conversion D. All the others

D

Which is(are) the common transformation type(s)? (choose one answer only) A. Decoding of fields B. Conversion of units of measurements C. Character set conversion D. All the others

D

Which statement(s) is (are) related to Dimensional Modeling? A. Captures critical measures B. Views along dimensions C. Intuitive to business users D. All the others

D

Which statement(s) is (are) related to Entity-Relationship Modeling? (choose one answer only) A. Removes data redundancy B. Ensures data consistency C. Expresses microscopic relationships D. All the others

D