Practice
Resources
Contests
Online IDE
New
Free Mock
Events New Scaler
Practice
Improve your coding skills with our resources
Contests
Compete in popular contests with top coders
logo
Events
Attend free live masterclass hosted by top tech professionals
New
Scaler
Explore Offerings by SCALER
/ Interview Guides / Data Warehousing MCQs

Data Warehousing MCQs

Last Updated: Jan 08, 2024
Certificate included
About the Speaker
What will you Learn?
Register Now

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

1. 

Identify the correct option which defines Datamart.

Create a free personalised study plan Create a FREE custom study plan
Get into your dream companies with expert guidance
Get into your dream companies with expert..
Real-Life Problems
Prep for Target Roles
Custom Plan Duration
Flexible Plans
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?

Explore InterviewBit’s Exclusive Live Events
Explore Exclusive Events
By
No More Events to show!
No More Events to show!
No More Events to show!
No More Events to show!
Certificate included
About the Speaker
What will you Learn?
Register Now
6. 

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

7. 

Choose the incorrect property of the data warehouse.

Start Your Coding Journey With Tracks Start Your Coding Journey With Tracks
Master Data Structures and Algorithms with our Learning Tracks
Master Data Structures and Algorithms
Topic Buckets
Mock Assessments
Reading Material
Earn a Certificate
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?

Discover your path to a   Discover your path to a   Successful Tech Career for FREE! Successful Tech Career!
Answer 4 simple questions & get a career plan tailored for you
Answer 4 simple questions & get a career plan tailored for you
Interview Process
CTC & Designation
Projects on the Job
Referral System
Try It Out
2 Lakh+ Roadmaps Created
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.

Excel at your interview with Masterclasses Know More
Certificate included
What will you Learn?
Free Mock Assessment
Fill up the details for personalised experience.
Phone Number *
OTP will be sent to this number for verification
+1 *
+1
Change Number
Graduation Year *
Graduation Year *
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
2028
2029
*Enter the expected year of graduation if you're student
Current Employer
Company Name
College you graduated from
College/University Name
Job Title
Job Title
Engineering Leadership
Software Development Engineer (Backend)
Software Development Engineer (Frontend)
Software Development Engineer (Full Stack)
Data Scientist
Android Engineer
iOS Engineer
Devops Engineer
Support Engineer
Research Engineer
Engineering Intern
QA Engineer
Co-founder
SDET
Product Manager
Product Designer
Backend Architect
Program Manager
Release Engineer
Security Leadership
Database Administrator
Data Analyst
Data Engineer
Non Coder
Other
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