ExamVeda
Login
Home

Data Warehousing - Database MCQ Questions and answers- Technical Aptitude

Data Warehousing(Database) mcq questions and answers with easy and logical explanations for various competitive examination, interview and entrance test. Database Mcq question are important for technical exam and interview. Page-3 section-1

21
Joining is the process of partitioning data according to predefined criteria.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
22
The role of the ETL process is to identify erroneous data and to fix them.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
23
Data in the data warehouse are loaded and refreshed from operational systems.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
24
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
25
Periodic data are data that are physically altered once added to the store.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
26
Both status data and event data can be stored in a database.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
27
Static extract is used for ongoing warehouse maintenance.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
28
Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
29
Every key used to join the fact table with a dimensional table should be a surrogate key.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
30
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board