Practice
Resources
Contests
Online IDE
New
Free Mock
Scaler Events New
Practice
Improve your coding skills with our resources
Contests
Compete in popular contests with top coders
Scaler
Explore Offerings by SCALER
Events
Checkout Scaler Academy Events
New

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

Read More About: Characteristics of Data warehouse

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

 

Important Resources

 

Data Warehousing MCQ

Events | Powered By
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
Fill up the details for personalised experience.
All fields are mandatory
Current Employer *
Enter company name *
Graduation Year *
Select an option *
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
Phone Number *
OTP will be sent to this number for verification
+1 *
+1
Change Number
Phone Number *
OTP will be sent to this number for verification
+1 *
+1
Change Number
Graduation Year *
Graduation Year *
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
*Enter the expected year of graduation if you're student
Current Employer *
Company Name *
Please verify your phone number
Edit
Resend OTP
By clicking on Start Test, I agree to be contacted by Scaler in the future.
Already have an account? Log in
Free Mock Assessment
Instructions from Interviewbit
Start Test