
Data Warehouse and Database Concepts Quiz
Authored by Artemis Kiwi
English
University
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks.
Physical, transactional
Logical, operational
Physical, operational
Logical, transactional
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Classification is a type of unsupervised learning technique.
True
False
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are the primary differences between a data warehouse and a data mart?
Data warehouses have a physical focus; data marts have logical focus.
Data warehouses have a more organization wide focus; data marts have functional focus.
Data warehouse tackle ethical issues; data marts tackle hypothetical issues.
Data warehouses make quick decisions; data marts make slow decisions.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A primary key in a table is:
all of these
borrowed by other tables as foreign keys
required to be unique.
used to identify each row uniquely
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the field of database rows and records are synonymous.
True
False
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Redundancy is when the same piece of data is stored in multiple places.
True
False
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
ETL stands for Execution, Transformation and Loading.
True
False
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?