SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Data Warehousing
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. A schema where dimensions are only connected to facts
Star schema
Data mart
Drilling down
OLAP
2. A computer system used to support the day-to-day operations of an organisation
ETL
Operational system
Define the grain
Load
3. Second stage of the data warehouse data architecture design process
Partioning
Define the grain
ETL
Star schema
4. First stage of building a data mart
Extract
Data mart
Design
Aggregate tables
5. A simplified form of a data warehouse supporting the work of a single line of business
Independent data marts
Parallel partitioning
Data mart
Choose the dimensions
6. The operational systems - data warehouse and data marts
Conformed dimensions
Back end
Snapshot
Transaction
7. Allows multiple CPUs to process multiple queries simultaneously - providing scalability.
Independent data marts
Drilling across
Parallel partitioning
Parallel processing and/or partitioning
8. A group of conformed dimensions
Hub and spoke Architecture
OLAP
Constellation
Conformed dimensions
9. An operational system that provides data for a business information system
Data mart
Dimensional modelling
Production report
Source system
10. Data about the data
Extract
Data mart bus architecture
Operational system
Metadata
11. Dimensions which are shared by two or more facts
Data mart design
Conformed dimensions
Load
Operational BI
12. Fourth stage of the data warehouse data architecture design process
Conformed dimensions
Choose the facts
OLAP
Metadata
13. A group of related fact tables
ELT
Business query tool
Drilling across
Family
14. simplest and least costly architecture developed to operate independently of each other - poor solution
Maintenance
Construction
Independent data marts
Star schema
15. Fifth stage of building a data mart
Dimension table
Enterprise Information Management
Maintenance
Drilling down
16. A schema where dimensions may be connected to facts or to other dimensions
Choose the facts
Choose the dimensions
Master Data Management
Snowflake schema
17. Make changes to data so that it is compatible with a new database
Data mart
Snowflake schema
Transform
ELT
18. Third stage of the data warehouse data architecture design process
Dependent data mart
Choose the dimensions
Production report
Extract
19. A report created by an IT department user
Drilling down
Conformed dimensions
Production report
Choose the dimensions
20. Splitting data tables into smaller tables for efficient access.
Drilling down
Choose the facts
Partioning
Define the users
21. Most famous data warehouse where a maintable infastructure includes a centralized data warehouse that serves for the needs of all organizational units (most favored 39 percent)
Drilling down
Production report
Hub and spoke Architecture
Family
22. Look-up tables referred to by fact tables
Dimension table
Define the grain
Front end
Snapshot
23. First stage of the data warehouse data architecture design process
Fact grain
Define the users
Accessing
Parallel processing and/or partitioning
24. Data accessible to the whole data warehouse
Master data
Design
Snowflake schema
Metadata
25. Used to support day-to-day operations
Operational BI
Family
Analytical applications
Business Intelligence
26. Online Analytical Processing
Parallel processing and/or partitioning
Dashboard
OLAP
Independent data mart
27. A system that allows people to access and analyse data for business management and performance improvement
Independent data mart
Current rolling snapshot
Business Intelligence
Back end
28. Import data into a new database
Source system
Load
Construction
Snapshot
29. A daily snapshot for each day of a set period
Current rolling snapshot
Aggregate tables
Business Intelligence
OLAP
30. Fourth stage of building a data mart
Extract
Accessing
Parallel partitioning
ETL
31. A database table that maps (e.g.) manufacturing product IDs to sales product IDs
Translation table
OLAP
Constellation
Choose the facts
32. Extract - Transform and Load
Fact table
Front end
Snowflake schema
ETL
33. A table containing foreign keys and values
Current rolling snapshot
Master Data Management
ELT
Fact table
34. A query created by a BI user
Conformed dimensions
Metadata
Business query tool
Ad hoc query
35. These extend BI into automating and optimising processes
Parallel partitioning
Analytical applications
Production report
Star schema
36. Requesting more information about a particular fact
Data mart
Drilling down
Choose the dimensions
Operational BI
37. A summary record for a specific reporting period
Business Intelligence
Snapshot
Parallel processing and/or partitioning
Data mart bus architecture
38. Extract - Load and Transform
Star schema
ELT
Dimension table
Construction
39. A synonym for Business Intelligence
Decision Support
Choose the facts
Enterprise Information Management
ELT
40. A tool that allows users to write queries without having to learn SQL
Accessing
Dimension table
Dependent data mart
Business query tool
41. Issues to consider when deciding EDW architecture: 1. Which database management system (DBMS) should be used? (ex: Crash Data" MS SQL) 2. Will ______________________ be used? 3. Will data migration tools be used to load the data warehouse?4. What too
Parallel processing and/or partitioning
Back end
Define the grain
Parallel partitioning
42. The business applications
Production report
Front end
Transform
Metadata
43. Draws data from operational or external systems
Parallel partitioning
Star schema
Independent data mart
Transaction
44. Second stage of building a data mart
Constellation
Family
Construction
Hub and spoke Architecture
45. Tables containing summary records calculated from the main fact tables
Source system
Extract
Aggregate tables
Family
46. An alternative term for a data warehouse
Enterprise Information Management
OLAP
Analytical applications
Dependent data mart
47. The level of detail required for a fact to be useful
Drilling across
Fact grain
Choose the facts
Data mart bus architecture
48. Take data from a source system
Independent data mart
Extract
Decision Support
Back end
49. Business applications - methods and tools that support the caputre and use of master data
Transform
Master Data Management
Accessing
Analytical applications
50. A visual display of the most important information needed by a particular user
Choose the dimensions
Family
Load
Dashboard