Welcome to Interviewbit, help us create the best experience for you!

Currently, You are a:

Few details about your education

College/University *
Enter the name of your college
Branch *
Year of completion *

Few details about your education

College/University *
Enter the name of your college
Branch *
Year of completion *

Few details about your career...

Current Company *
Enter company name
Experience *

You're all set!

Begin your success journey!

Sign Up using
Full name *
Email *
Password *

By creating an account, I acknowledge that I have read and agree to InterviewBit’s Terms and Privacy Policy .

Welcome back!

Log In using
Email *
Password *

Data Warehousing MCQs

Bill Inmon Alin first coined data Warehouse in 1990. According to him, a data warehouse Is a subject-oriented, integrated, time-variant, and non-volatile collection of data. Data warehouse is kept separate from organization operational database and it can be said that a data warehouse is a more extensive form of DBMS data.

Key Points

  • There is no requirement for frequent updating of data on the warehouse.
  • These data help analysts to make informed decisions in an organization.
  • Data warehouses provide generalized and combined data in a multidimensional view
  • Data warehouse also provides us with online analytical processing(OLAP) tools Which help in interactive and effective analysis.

Characteristics of Data warehouse

  • Subject-oriented
  • Non-volatile
  • Integrated
  • Time variant

KDD process

  • KDD stands for Knowledge discovery from data.
  • KDD refers to the overall process of discovering useful knowledge from data.

Data Cleaning

Data cleaning is defined as the removal of noisy and irrelevant data from the collection.

  • Cleaning missing values
  • Cleaning noisy data

Data integration

Data integration is defined as the heterogeneous data from multiple sources combined into a common source.

Data Selection

Data selection is defined as the process where data relevant to the analysis is decided and retrieved from the data warehouse.

Data Transformation

Transformation is defined as the process of transforming data into the appropriate required form required by the mining procedure.

Data objects and attributes types

  • Data sets are made up of data objects.
  • A data object represents an entity.

Data objects are described by attributes in the database.

Attributes: A data field, represents a characteristic or feature of a data object.

Types of attributes

  • Nominal attributes: 
    • Relating to names
    • Each value represents some kind of category, code, or state.
    • Also referred to as categorical attributes.
  • Binary attributes:
    • Nominal attributes with only two categories of state(0 and 1).

Data Warehousing MCQ

1. 

Identify the correct option which defines Datamart.

2. 

State whether True or False: Data warehouse is generally updated in real-time.

3. 

Identify the options below that a data warehouse can include.

4. 

Identify among the following for which system of data warehousing is mostly used.

5. 

Where is data warehousing used?

6. 

Small logical units where data warehouses hold large amounts of data is known as _____

7. 

Choose the incorrect property of the data warehouse.

8. 

Identify the operation which can be performed in the data warehouse.

9. 

On what is data warehouse based?

10. 

Identify the term used to define the multidimensional model of the data warehouse.

11. 

DSS in data warehouse stands for _____________.

12. 

What is the time horizon in the data warehouse?

13. 

Where can the data be updated?

14. 

What is the source of all data warehouse data known as?

15. 

Identify the most common source of change data in refreshing a data warehouse.

16. 

Who is responsible for running queries and reports against data warehouse tables?

17. 

How many approaches are there in data warehousing to integrate heterogeneous databases?

18. 

From where are classification rules extracted?

20. 

Identify whether True or False: Data in operational systems are typically fragmented and inconsistent.

21. 

Among the following which is the specialized data warehouse database?

22. 

Choose the option on which database architecture is based.

23. 

What is the percent of data redundancy between environments?

24. 

Which of the following is not a clustering method.

25. 

ETL stands for ____________

26. 

Which of the following is included in  in@active. data warehouse architecture?

27. 

Identify the type of relationship between fact and dimension table in a star schema.

28. 

What does a null value indicate?

29. 

What is the use of data cleaning?

30. 

Which of the following technology is not well suited for data mining?

31. 

What does OLTP stand for?

32. 

______ is an object-oriented, integrated, time-variant, and nonvolatile collection of data in support of management decisions.

33. 

The data is stored, retrieved and updated in ____________.

34. 

What is known as the heart of the warehouse?

35. 

Under which of the following does the pattern evaluation issue fall?

36. 

Which of the following maps the core warehouse metadata to business concepts, familiar and useful to end-users.

37. 

What is a query tool made for?

38. 

What does DMQL stand for?

39. 

What does data mining system classification consist of?

40. 

From where are classification rules extracted?

41. 

Which of the following is a method of incremental conceptual clustering?

42. 

What is a multidimensional database also known as?

43. 

From where does the source data from the warehouses come?

44. 

What is the technology area associated with CRM known as?

45. 

MDDB stands for ________________

46. 

Identify the correct definition of Reconciled data.

Get Placed at Top Product Companies with Scaler Know More 
Get Placed at Top Product Companies with Scaler Know More 
Get Placed at Top Product Companies with Scaler
Sat transparent 640a34d454880bf68e3bfdf33f2389f2214043f59ad18b4c7f7b114e834fb257.svg

Point markers b3add1cc88e4996b2df6e0aedb9f0d1b65fa73c51b7ada8fbee3895a2aa11802.svg Personalised feedback report with solutions
Point markers b3add1cc88e4996b2df6e0aedb9f0d1b65fa73c51b7ada8fbee3895a2aa11802.svg Real life Interview Questions
Point markers b3add1cc88e4996b2df6e0aedb9f0d1b65fa73c51b7ada8fbee3895a2aa11802.svg Identify exact topics to improve

Your feedback is important to help us improve.
Free Mock Assessment
Help us know you better for the best experience
Current Employer *
Enter company name
College you graduated from *
Enter university name
Phone Number *
OTP will be sent to this number for verification
+1
+1
Change Number
Edit
Resend OTP
By Continuing I agree to be contacted by Scaler in the future.
Already have an account? Log in