The ____________ dimension represents data correctness.

• A) Correctness
• B) Consistency
• C) Completeness
• D) Free-of-error

Which is not a/an Data Quality Validation Technique?

• A) Referential Integrity
• B) Attribute domain
• C) Consistency Integrity
• D) Using Data Quality Rules

A ______ index, if fits in the memory, costs only one disk I/O access to locate a record given a key.

• A) B-Tree
• B) Sparse
• C) Dense
• D) Hash

“More resources means proportionally less time for given amount of data”. The statement refers to:

• A) Speed-Up
• B) Scale-Up
• C) Over-utilized system
• D) Size-up

The _________ operator is conservative in that it assigns to the dimension an aggregate value no higher than the value of its weakest data quality indicator.

• A) Min and Max
• B) Min
• C) Max
• D) None of given

In context of joining tables, the join condition is specified in ____ clause

• A) SELECT
• B) GROUP BY
• C) FROM
• D) WHERE

In context of nested-loop join, actual number of matching rows returned as a result of the join would be ______ of the order of tables

• A) Superset
• B) Independent
• C) Dependent
• D) Subset

In ______ index, the ith bit is set to "1" if the ith row of the base table has the value for the indexed column.

• A) Cluster index
• B) Join index
• C) Bitmap index
• D) Inverted index

______ index stores first value in each block in the sequential file and a pointer to the block.

• A) B-Tree
• B) Hash
• C) Dense
• D) Sparse

The optimizer uses a hash join to join two tables if they are joined using an equijoin and

• A) Inner table has less number of rows
• B) Large amount of data needs to be joined
• C) Cardinality of tables is equal
• D) Outer table has less number of rows

The degree to which values are present in the attributes that require them is known as ____________.

• A) Uniqueness
• B) Consistency
• C) Accessibility
• D) Completeness

Which of the following tasks can NOT be parallelized?

• A) Partitioned index scans
• B) None of the given options
• C) Creation of large indexes
• D) Large table scans and joins

The extent to which data is in appropriate languages, symbols, and units, and the definitions are clear is known as _______________.

• A) Accessibility
• B) Consistency
• C) Interpretability
• D) Uniqueness

Which of the following is not a Data Quality Validation Technique?

• A) Using Data Quality Rules
• B) Indexes
• C) Referential Integrity
• D) Data Histograming

__________ is a system of activities that assures conformance of product to pre-established requirements.

• A) Quality improvement
• B) Quality Establishment
• C) Quality Maintenance
• D) Quality assurance

Improper documentation results the problem(s) like:

• A) All of the given options
• B) New developers unable to configure already existing code
• C) Maintenance issue
• D) Lot of time required for enhancing the code

In contrast to data mining, statistics is ______ driven.

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

In lifecycle data track, we begin with translating the requirements into dimensional model, which then transforms into ______

• A) Conceptual structure
• B) System structure
• C) Physical structure
• D) Logical structure

The phase-3 i.e. “Rollout and Maintenance” phase in “12-steps data warehouse implementation approach” of Shaku Atre comprises of _______ activity.

• A) None of the given options
• B) Deployment & System Management
• C) On Line Analytical Processing
• D) Construct Metadata Repository

In context of analytical applications track, the application development activity can begin after:

• A) A subset of historical data has been loaded
• B) Database design is complete
• C) All of the given options
• D) The data access tools and metadata are installed