Aptitude Reasoning English GK Computer Knowledge Programming Skill Banking Software Testing



Question - 1

Which of the following statement is true?

  • The data warehouse consists of data marts and operational data
  • The operational data are used as a source for the data warehouse
  • The data warehouse is used as a source for the operational data
  • All of the above
Solutions
Question - 2

Which of the following features usually applies to data in a data warehouse?

  • Data are often deleted
  • Most applications consist of transactions
  • Data are rarely deleted
  • Relatively few records are processed by applications
Solutions
Question - 3

The most common source of change data in refreshing a data warehouse is:

  • Queryable change data
  • Cooperative change data
  • Logged change data
  • Snapshot change data
Solutions
Question - 4

A data warehouse is which of the following?

  • Can be updated by end users
  • contains numerous naming conventions and formats
  • Organized around important subject areas
  • contains only current data
Solutions
Question - 5

Does the generic two-level data warehouse architecture include:

  • at least one data mart
  • data that can extracted from numerous internal and external sources
  • near real-time updates
  • All of the above
Solutions
Question - 6

Which of the following is transient data?

  • Data in which changes to existing records cause the previous version of the records to be eliminated
  • Data in which changes to existing records do not cause the previous version of the records to be eliminated
  • Dta that are never altered or deleted once they have been added
  • Data that are never deleted once they have been added
Solutions
Question - 7

A snowflake schema is which of the following types of tables?

  • Fact
  • Dimension
  • Helper
  • All of the above
Solutions
Question - 8

Which of the following is a fact table?

  • Completely denoralized
  • Partially denoralized
  • Completely normalized
  • Partially normalized
Solutions
Question - 9

A star schema has what type of relationship between a dimension and fact table?

  • Many-to-many
  • One-to-one
  • One-to-many
  • All of the above
Solutions
Question - 10

The role of the ETL process is:

  • to identify erroneous data and to fix them.
  • to process the data
  • to enhance the data
  • None of these
Solutions
Question - 11

A null value indicates:

  • A numeric value with value 0
  • The absence of a value
  • A very small value
  • An erroneous value
Solutions
Question - 12

In the relational database terminology, a table is synonymous with:

  • A column
  • A row
  • An attribute
  • A relation
Solutions
Question - 13

The term Data Warehouse was first coined by:

  • Roger Mougalas
  • Arthur Samuel
  • Bill Inmon
  • Herbert Simon
Solutions
Question - 14

In Which year, Data Warehouse was first coined?

  • 1987
  • 1988
  • 1989
  • 1990
Solutions
Question - 15

How many types of data warehouses are there?

  • 2
  • 3
  • 4
  • 5
Solutions
Question - 16

Which of the following involves finding and correcting the errors in data?

  • Data Extraction
  • Data Cleaning
  • Data Transformation
  • Data Loading
Solutions
Question - 17

To integrate heterogeneous databases, we have ___________ approaches.

  • 1
  • 2
  • 3
  • 4
Solutions
Question - 18

A data warehouse is a:

  • time-variant
  • integrated
  • subject oriented
  • All of the above
Solutions
Question - 19

Which one of the following refers to querying the unstructured textual data?

  • Information access
  • Information update
  • Information retrieval
  • Information manipulation
Solutions
Question - 20

A data warehouse is designed to-

  • enable and support business intelligence(BI) activities, especially analytics
  • support processing the data
  • Both A and B
  • None of these
Solutions
Tags:
Data warehouse MCQ (Multiple Choice Questions), Advanced Data warehouse MCQ, Data warehouse MCQ Online test,Data warehouse MCQ Questions and answers PDF, Data warehouse Interview Questions With Answers, Data warehouse Technical Questions with full explanation