In analytical application development phase, we follow standards for:

• A) Standard for calculations
• B) All of the given options
• C) Standards for libraries
• D) Naming conventions

Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development?

• A) Not being an accommodating person
• B) Training the users with dummy data and considering it success
• C) Not interacting directly with end user
• D) Isolating IT support people from business users

In context of requirement definition phase in Kimball’s DWH development approach, activities like debriefing, documentation, and prioritization are considered to be the part of:

• A) Post collection
• B) Business requirements collection
• C) Requirement preplanning
• D) None of the given options

In ______ phase of a fundamental data warehouse life cycle model, a working model of data warehouse is deployed for a selective set of users

• A) Deployment
• B) Design
• C) Prototype
• D) Operation

One of the drawbacks of waterfall model is that:

• A) It does not work when the resources are limited
• B) All of the given options
• C) Customers can not review the product during development
• D) It does not define the project timeline/schedule

Classification consists of examining the properties of a newly presented observation and assigning it to a predefined ____________.

• A) Container
• B) Class
• C) Object
• D) Subject

A bottom up implementation approach is useful when

• A) All the requirements are well documented
• B) The business objectives are very much clear
• C) Technology is mature and well understood
• D) Organization can not implement latest technologies

In ___________ phase of kimballs approach, we identify the components needed now and in future.

• A) Architectural design
• B) Analytical application development
• C) Requirement definition
• D) Product development

Data mining is all about:

• A) Finding hidden patterns in data
• B) All of the given options
• C) Finding relationships in data
• D) Knowledge discovery in database

Implementation of a data warehouse requires ________ activities

• A) Tightly decoupled
• B) Loosely integrated
• C) None of the given
• D) Highly integrated

Which of the following is/are included in the list of Top-7 key steps for smooth DWH implementation?

• A) All of the given options
• B) Be a diplomat NOT a technologist
• C) Assign significant resources for ETL
• D) Consider handing-off project management

Which of the following is NOT one of the examples of dynamic attributes?

• A) Air pressure
• B) Daily Sale
• C) Date of Birth
• D) None of the given options

In contrast to statistics, data mining is ______ driven.

• A) Database
• B) Assumption
• C) Knowledge
• D) Human

Time Complexity of Key Creation process in basic Sorted Neighborhood (BSN) Method is ________.

• A) O(n)
• B) O(2n)
• C) O(log n)
• D) O(n log n)

Time Complexity of Basic Sorted Neighborhood (BSN) Method is __________________.

• A) O(n)
• B) O(log n)
• C) O(2n)
• D) O(n log n)

______________can result in costly errors, such as: False frequency distributions and incorrect aggregates due to double counting.

• A) Data duplication
• B) Data reduction
• C) Data anomaly
• D) Data transformation

Instance matching between different sources is then achieved by a standard _____________ on the identifying attribute(s), if you are very, very lucky.

• A) Outer join
• B) Inner join
• C) Fuller join
• D) Equi-join

______________ is much more than simply updating a record with good data.

• A) Data transformation
• B) Data cleansing
• C) Data reduction
• D) Data duplication

The data coming from outside the organization owning the DWH can have even ______________ quality data i.e. different representation for same entity, transcription or typographical errors.

• A) Medium
• B) Higher
• C) Lower
• D) Average

The degree of similarity between two records, often measured by a numerical value between ________, usually depends on application characteristics.

• A) 0 and 1
• B) 2 and 3
• C) 1 and 2
• D) None of the given