DBW301

Which are NOT the desired characteristics of strategic information? a. INTEGRATED b. DATA INTEGRITY c. ACCESSIBLE d. CREDIBLE e. TIMELY f. None

f

Data warehouse architecture is just an overall guideline. It is not a blueprint for the data warehouse. a. True b. False

b

Entity-Relationship Modeling is suitable for............ a. OLTP systems b. Data warehouse systems c. OLTP and Data warehouse systems d. OLAP

a

In Bottom-Up Approach of designing a data warehouse, data marts are created first to provide analytical and reporting capabilities for specific business subjects based on the dimensional data model. a. True b. False

a

In ETL, .............tables are loaded first. a. Dimension b. Fact c. Dimension and Fact d. None of the others

a

In a data warehouse, the metadata component is unique, with no truly matching component in operational systems. a. True b. False

a

In an operational system, data is usually kept at the lowest level of detail. a. True b. False

a

In any analytical system, time is a critical dimension. a. True b. False

a

In data warehouse, Data Extraction function has to deal with numerous data sources. You have to employ the appropriate technique for each data source. a. True b. False

a

In designing a data warehouse, Top-Down Approach will create a data warehouse as a centralized repository for the entire enterprise. a. True b. False

a

In the data warehouse architecture, ................ sits on top of all the other components. It coordinates the services and activities within the data warehouse. a. Management and Control Component b. Metadata Component c. Data source Component d. Data Storage Component

a

Let business requirements drive your data warehouse, not technology a. True b. False

a

Metadata in a data warehouse is similar to the .............or the data catalog in a database management system. a. data dictionary b. data structure c. data tables d. data constraints

a

OLAP stands for a. Online Analytical Processing b. Offline Analytical Processing c. Online Analytical Production d. Object Analytical Processing

a

OLAP systems provide ............. and roll-up capabilities. a. drill-down b. drop-down c. top-down d. up-down

a

OLTP is stand for Online Transaction Processing. a. True b. False

a

Operational systems are the systems that are used to run the day-to-day core business of the company. a. TRUE b. FALSE

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 is the challenge of ETL? a. Source system structures keep changing over time because of new b. Source system structures are very different. c. Source systems are hosted in very low performance systems. d. None of the others

a

............systems focus on individual events. a. Data warehouse b. OLTP c. Business system d. OLAP

b

ACCESSIBLE characteristic of strategic information means: a. Every business factor must have one and only one value. b. Easily accessible with intuitive access paths, and responsive for analysis. c. Information must be accurate and must conform to business rules. d. Must have a single, enterprise-wide view.

b

Source data in data warehouse may come from: (choose one answer only) a. Production Data b. Internal Data c. Archived Data d. External Data e. All the others

e

What do we need when design table for slowly dimension change? a. Adding artificial key column b. Maintain business key c. Adding effective date column d. Adding expired date column e. All of others

e

The operational system is an information system that: a. Provides an integrated and total view of the enterprise. b. Makes the enterprise's current and historical information easily available for strategic decision making. c. Makes decision-support transactions possible without hindering operational systems. d. Renders the organization's information consistent. e. Presents a flexible and interactive source of strategic information. f. Support the basic business processes of the company.

f

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

An OLAP cube is an array of data understood in terms of...... dimensions. a. 3 b. 2 c. 1 d. 0 or more

d

INTEGRATED characteristic of strategic information means: a. Every business factor must have one and only one value. b. Easily accessible with intuitive access paths, and responsive for analysis. c. Information must be accurate and must conform to business rules. d. Must have a single, enterprise-wide view.

d

In data quality, which is (are) the Sources of Data Pollution? (choose one answer only) a. Input Errors b. Incomplete Information at Data Entry c. Internationalization/Localization d. All the others

d

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

Indexing in data warehouse database reduces performance of ........ a. Information delivery b. ETL c. Loading data into data warehouse d. OLAP

d

MOLAP refers to ............OLAP. a. Mix b. Multiple c. Many-to-Many d. Multidimensional

d

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 e. choosing from vendor solutions. f. requirement changes

f

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

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

Operational systems are online transaction processing (OLTP) systems. a. TRUE b. FALSE

a

ROLAP refers to ............OLAP. a. Relational b. Rapid c. Running d. Roll

a

Which statement is TRUE? a. A clustered index is a physical concept - it's an index that affects the order in which records are stored on disk. b. We can create some clustered indexes on a table. c. In SQL server, all foreign keys are clustered indexes. d. None of the others.

a

Which statement is correct? a. We have to choose OLAP Cube when performance is a key factor, the key decision makers of the company can ask for statistics from the data anytime from your huge database. b. We have to choose OLAP Cube when storage is a key factor, the key decision makers of the company can ask for statistics from the data anytime from your small database. c. We have to choose OLAP Cube when we do not want to implement ETL. d. None of the others

a

........... acts as the glue that connects all parts of the data warehouse. a. ETL b. Metadata c. Operational Metadata d. Extraction and Transformation Metadata

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

............ may answer questions on overall process. a. OLTP b. OLAP c. Business Intelligence d. Data warehouse

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

Which is/are the actions that should be done when developing a data warehouse? a. Take all the data from the operational systems. b. Where necessary, include relevant data from outside, such as industry benchmark indicators. c. Integrate all the data from the various sources. d. Remove inconsistencies and transform the data. e. Store the data in formats suitable for easy access for decision making. f. All the others

f

............... signifies that the data warehouse stores the information around a particular subject such as product, customer, sales etc. a. Subject oriented b. Integrated c. Time-Variant d. Nonvolatile

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

Accurate requirements definition in a data warehouse project is many times more important than in other types of projects. a. True b. False

a

BIDS (Business Intelligence Development Studio) provides environment for developing your OLAP Cube and Deploy on SQL Server. a. True b. False

a

Benefits from a data warehouse accrue only after the users put it to full use. a. True b. False

a

Business metadata comes from sources more varied than those for technical metadata. a. True b. False

a

CREDIBLE characteristic of strategic information means: a. Every business factor must have one and only one value. b. Easily accessible with intuitive access paths, and responsive for analysis. c. Information must be accurate and must conform to business rules. d. Must have a single, enterprise-wide view.

a

Data granularity in a data warehouse refers to the level of detail. a. True b. False

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

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

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 .............model contains the structures and relationships represented in the database schema coded with the data definition language (DDL) of the DBMS. a. Physical b. Logical c. Final d. Star

a

The ............diagrams crystallize the information requirements for the data warehouse. a. information package b. star c. dimension d. ERD

a

The data warehouse is an informational environment that: a. Makes the enterprise's current and historical information easily available for strategic decision making. b. Makes the enterprise's current information easily available for strategic decision making. c. Makes the enterprise's historical information easily available for strategic decision making. d. None of the others

a

The data warehouse is an informational environment that: a. Provides an integrated and total view of the enterprise. b. Store all the business data c. Data is often updated and inserted d. All company's staff access it everyday.

a

The detailed plan results in the definition of the transformation/conversion rules. a. True b. False

a

The initial load (in Data Loading) moves large volumes of data using up substantial amounts of time. a. True b. False

a

The online transaction processing applications support the day-to-day operations of an enterprise. a. True b. False

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

Using parallel processing technologies (e.g. multithreading), the performance of ETL can be improved. Is it true? a. Yes b. No

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

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.

a

What should we do before executing ETL? a. Remove indexes in data warehouse database b. Create some non-clustered indexes in data warehouse database c. Do nothing d. None of the others

a

Which is the traditional data warehouse project life cycle? a. 1)Project plan 2)Requirements definition 3)Design 4)Construction 5)Deployment 6)Growth and maintenance b. 1)Requirements definition 2)Project plan 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

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 operation involves summarizing the data along a dimension? a. Roll-up b. Dice c. Slice d. Drill Down

a

Which operation produces a subcube by allowing the analyst to pick specific values of multiple dimensions? a. Dice b. Slice c. Roll-up d. Drill Down/Up

a

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

a

Which statement is the most correct definition of data warehouse system? a. Data warehouse is Subject Oriented, Integrated, Time-Variant and Nonvolatile collection of data that support management's decision making process. b. Data warehouse is Subject Oriented, Integrated, Time-Variant and Nonvolatile collection of data that support daily management process. c. Data warehouse is Subject Oriented, Integrated, Time-Variant and Nonvolatile collection of data that support auditing process. d. None of the others.

a

Who are the users that need information from the data warehouse? a. Decision makers b. Customers c. Staff d. Database Administrators

a

Data Mining means we want to mining the data? a. YES b. NO

b

Dimensional Modeling is suitable for............ a. OLTP systems b. Data warehouse systems c. OLTP and Data warehouse systems d. OLAP

b

In a table, there is only one ............. index. a. Bitmap b. Clustered c. non-clustered d. Tree

b

Is that true, if one says that OLAP report on the past while Data Mining predicts the future? a. YES b. NO

b

Justification the benefits of a data warehouse through stiff ROI (Return on investment) calculations is always easy. a. True b. False

b

Maintaining metadata in a modern data warehouse is just for documentation. a. True b. False

b

The importance of metadata is the same in a data warehouse as it is in an operational system. a. True b. False

b

The traditional methods of collecting requirements that work well for operational systems can be directly applied to data warehouses. a. True b. False

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 is Business intelligence? a. The tools for decision makers to get the strategic information. b. The systems and technologies for gathering, cleansing, consolidating, and storing corporate data. The tools, techniques, and applications for analyzing the stored data. c. The tools for data warehouse developer to manipulate and monitor the data warehouse database. d. The most common Operation System for a data warehouse.

b

What kinds of columns should be selected for indexing? a. The columns that sometime involved to constraint the query. b. The columns that frequently involved to constraint the query. c. Semantic-Meaningful columns d. All of others

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

When a user queries the data warehouse for analysis, he or she usually starts by looking at very details of data. a. True b. False

b

Which is the act of picking a rectangular subset of a cube by choosing a single value for one of its dimensions, creating a new cube with one fewer dimension? a. Dice b. Slice c. Roll-up d. Drill Down/Up

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 method used for discovering interesting relations between variables in large databases? a. Clustering b. Association Rules c. Classification d. None of others

b

Which one is NOT type of slowly changing dimensions? a. Type 1 relates to corrections b. Type 2 relates to measurement of interest c. Type 3 to soft revisions d. Type 4 to preservation of history

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

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

b

Who needs strategic information in an enterprise? (choose the most correct) a. Staff b. Decision Markers c. Managers d. Accountants e. Directors

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

A table may contain some ............. indexes. Select one answer only. a. Bitmap b. Clustered c. non-clustered, bitmap d. non-clustered

c

DATA INTEGRITY characteristic of strategic information means: a. Every business factor must have one and only one value. b. Easily accessible with intuitive access paths, and responsive for analysis. c. Information must be accurate and must conform to business rules. d. Must have a single, enterprise-wide view.

c

In which case, indexes can improve the performance? a. Insert data b. Update data c. Read data d. None of the others

c

Indexing in data warehouse database reduces performance of ........ a. Information delivery b. ETL c. Loading data into data warehouse d. OLAP

c

Select the most correct definition of the data warehouse concept. a. Take all the data you already have in the organization, store it, and then provide useful strategic information. b. Take all the data you already have in the organization and also in the related business domains, clean and transform it, and then provide useful strategic information. c. Take all the data you already have in the organization, clean and transform it, and then provide useful strategic information. d. None of the others

c

What kind of data mining techniques used for representing wide range of results? a. Data Preprocessing b. Data Analysis c. Data Visualization d. All of others

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 is NOT a data warehouse building block? a. source data b. data staging c. data schema d. information delivery e. metadata f. management and control.

c

Regarding to Online Analytical Processing (OLAP), which statement is INCORRECT? a. Designed to hold historical data for analyses and forecast business needs b. Data stored in denormalized format c. Used by users who are associated with the decision making process, e.g., Managers, CEO. d. Holds daily Latest Transactional Data related to your application

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 some aspects of Data Mining? a. Association Rules b. Outlier Analysis c. Predictive Analytics d. All of them

d

What kind of datamining techniques help to find the natural group of objects? a. Classification b. Regression c. Association Rules d. Clustering

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 (are) related to the time-variant nature of the data in a data warehouse? (choose one answer only) a. Allows for analysis of the past b. Relates information to the present c. Enables forecasts for the future d. All the others

d

Which is NOT a characteristic of a data warehouse? a. Integrated b. Time stamped c. Subject oriented d. Volatile

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 statement is TRUE? a. Clustered index uses a huge amount of storage to store indexing data. b. Clustered index can increase both read and write operations. c. None of the others. d. In SQL Server, primary key is clustered index as default. This makes it a very fast index when accessing data, though it may slow down writes if your primary key is not a sequential number.

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