Home
10th Grade
11th And 12th
11th Grade
12th Grade
3rd Grade
4th Grade
5th Grade
6th Grade
7th Grade
8th Grade
9th Grade
Advance Accountancy
Auditing
Computer Aptitude
Direct And Indirect Taxation
Exams
General Hindi
Indian Finance System
Information Technology And Application In Business
Macro Economics
Town Planning
Aerospace And Aeronautical
Analytical Instrumentation
Banking Awareness
Banking Exam
Biochemistry
Bioinformatics
Biology
Biotechnology
Business Statistics
C Program
C Programming
C++ Programming
Career Aptitude Test
Cell Biology
Central Superior Service (css)
Chemical Engineering
Chemistry
Civil Engineering
Commerce
Computer
Computer Fundamentals
Computer Science
Cost Accounting
Css
Database
Drug And Pharmaceutical Biotechnology
Ecat And Mcat Entry Test
Economics
Electrical Engineering
Electrical Engineering Questions
Electrical Measurement And Instrumentation
Engineering
English
English Literature
Environment Management
Environmental Biotechnology
Enzyme Technology
Financial Management And Financial Markets
Gate
General Knowledge
Graduate Assessment Test (gat)
Health And Physical
Heat Transfer
Html
Human Anatomy And Physiology
Human And Cultural Diversity
Human Resource Management
Ias
Indian Economy
Indian Economy
Indian General Awareness
Indian Geography
Indian Geography
Indian History
Indian History
Indian Polity
Instrumentation Transducers
International Relations
Java Program
Javascript
Judiciary And Law
Life Sciences
Management
Marketing And Marketing Management
Mass Transfer
Mechanical Engineering
Mechanics Of Materials
Medical Subjects
Microbiology
Networking
Php
Placement Tests
Professional Communication
Quantitative Aptitude
Reasoning Aptitude
Renewable Energy
Science
Sociology
Sql
Surveying
Total Quality Management
Uidai Aadhaar Supervisor Certification
Virology
Notificatin
Exam
Blog
Contact Us
Data Warehousing(Engineering > Computer Science And Engineering > Database System ) Questions and Answers
Home
Topic
Engineering
Computer Science And Engineering
Database System
Data Warehousing
Question 1.
Data scrubbing is which of the following?
A process to upgrade the quality of data after it is moved into a data warehouse
A process to upgrade the quality of data before it is moved into a data warehouse
A process to reject data from the data warehouse and to create the necessary indexes
A process to load the data in the data warehouse and to create the necessary indexes
Explanation:-
Answer: Option B. ->
A process to upgrade the quality of data before it is moved into a data warehouse
Question 2.
The @active data warehouse architecture includes which of the following?
At least one data mart
Data that can extracted from numerous internal and external sources
All of these
Near real-time updates
Explanation:-
Answer: Option C. ->
All of these
Question 3.
An operational system is which of the following?
A system that is used to run the business in real time and is based on current data.
A system that is used to run the business in real time and is based on historical data.
A system that is used to support decision making and is based on current data.
A system that is used to support decision making and is based on historical data.
Explanation:-
Answer: Option A. ->
A system that is used to run the business in real time and is based on current data.
Question 4.
A goal of data mining includes which of the following?
To analyze data for expected relationships
To confirm that data exists
To explain some observed event or condition
To create a new data warehouse
Explanation:-
Answer: Option C. ->
To explain some observed event or condition
Question 5.
A data warehouse is which of the following?
Can be updated by end users.
Organized around important subject areas.
Contains only current data.
Contains numerous naming conventions and formats.
Explanation:-
Answer: Option B. ->
Organized around important subject areas.
Question 6.
A snowflake schema is which of the following types of tables?
Helper
All of these
Fact
Dimension
Explanation:-
Answer: Option B. ->
All of these
Question 7.
Fact tables are which of the following?
Partially normalized
Partially denoralized
Completely denoralized
Completely normalized
Explanation:-
Answer: Option D. ->
Completely normalized
Question 8.
Data transformation includes which of the following?
Joining data from one source into various sources of data
A process to change data from a summary level to a detailed level
A process to change data from a detailed level to a summary level
Separating data from one source into various sources of data
Explanation:-
Answer: Option C. ->
A process to change data from a detailed level to a summary level
Question 9.
Reconciled data is which of the following?
Current data intended to be the single source for all decision support systems.
Data stored in one operational system in the organization.
Data stored in the various operational systems throughout the organization.
Data that has been selected and formatted for end-user support applications.
Explanation:-
Answer: Option A. ->
Current data intended to be the single source for all decision support systems.
Question 10.
The generic two-level data warehouse architecture includes which of the following?
Near real-time updates
Data that can extracted from numerous internal and external sources
At least one data mart
All of these
Explanation:-
Answer: Option B. ->
Data that can extracted from numerous internal and external sources
1
2
3
Next →
One click Login
Login With Google
Old way of Login
Login With Email