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. Draws data from a data warehouse
Snowflake schema
Data mart design
Dimensional modelling
Dependent data mart
2. Tables containing summary records calculated from the main fact tables
Aggregate tables
ETL
Business Intelligence
Snowflake schema
3. Used to support day-to-day operations
Define the users
Independent data marts
Operational BI
Independent data mart
4. A system that allows people to access and analyse data for business management and performance improvement
Business Intelligence
Define the grain
Back end
Snapshot
5. An operational system that provides data for a business information system
Source system
Drilling across
Snapshot
Snowflake schema
6. Third stage of building a data mart
Population
Dashboard
Conformed dimensions
Business Intelligence
7. Draws data from operational or external systems
Maintenance
Independent data mart
Ad hoc query
Current rolling snapshot
8. The level of detail required for a fact to be useful
Enterprise Information Management
Fact grain
Front end
Snowflake schema
9. A table containing foreign keys and values
Operational system
Star schema
Fact table
Hub and spoke Architecture
10. A query created by a BI user
Operational system
Drilling down
Constellation
Ad hoc query
11. Online Analytical Processing
Family
Source system
Translation table
OLAP
12. A schema where dimensions are only connected to facts
Master Data Management
Decision Support
Star schema
ETL
13. A synonym for Business Intelligence
Production report
Back end
Decision Support
Parallel partitioning
14. The business applications
Data mart bus architecture
Snapshot
Front end
Enterprise Information Management
15. A report created by an IT department user
Production report
Aggregate tables
Hub and spoke Architecture
Ad hoc query
16. Fifth stage of building a data mart
Independent data mart
Maintenance
Snowflake schema
Data mart design
17. A computer system used to support the day-to-day operations of an organisation
Data mart bus architecture
Master Data Management
Operational system
Dimensional modelling
18. The operational systems - data warehouse and data marts
Analytical applications
Hub and spoke Architecture
Translation table
Back end
19. 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)
Hub and spoke Architecture
Metadata
Choose the facts
Drilling down
20. Second stage of building a data mart
Extract
Accessing
Back end
Construction
21. Data accessible to the whole data warehouse
Population
Source system
OLAP
Master data
22. Requesting information about related facts
Extract
Accessing
Production report
Drilling across
23. Splitting data tables into smaller tables for efficient access.
Business Intelligence
Partioning
Back end
Parallel partitioning
24. Extract - Transform and Load
Define the users
Design
ETL
Front end
25. Extract - Load and Transform
Dimension table
Independent data mart
ELT
Current rolling snapshot
26. Data about the data
Metadata
Ad hoc query
Star schema
Business Intelligence
27. Fourth stage of building a data mart
Accessing
Choose the dimensions
Population
Dimensional modelling
28. simplest and least costly architecture developed to operate independently of each other - poor solution
Independent data marts
Business Intelligence
Conformed dimensions
Partioning
29. First stage of building a data mart
Parallel partitioning
Design
Master data
Data mart bus architecture
30. A visual display of the most important information needed by a particular user
Back end
Dashboard
Design
Snapshot
31. A summary record for a specific reporting period
Snapshot
Extract
Define the users
Partioning
32. An alternative term for a data warehouse
Data mart design
Enterprise Information Management
ETL
Family
33. A group of conformed dimensions
Source system
Constellation
Choose the dimensions
Design
34. Fourth stage of the data warehouse data architecture design process
Choose the facts
Drilling across
Master Data Management
Operational BI
35. Import data into a new database
Population
Decision Support
Load
Aggregate tables
36. A tool that allows users to write queries without having to learn SQL
Analytical applications
Back end
Business query tool
Maintenance
37. Business applications - methods and tools that support the caputre and use of master data
Parallel partitioning
Master Data Management
Extract
Population
38. 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
Current rolling snapshot
Operational system
ELT
39. A logical design technique that presents data in a way that is optimised for high-performance access
Dimensional modelling
Production report
Partioning
Enterprise Information Management
40. Allows multiple CPUs to process multiple queries simultaneously - providing scalability.
Hub and spoke Architecture
Define the grain
Translation table
Parallel partitioning
41. A single low-level fact representing a single business operation
Transaction
Star schema
Parallel processing and/or partitioning
Extract
42. Make changes to data so that it is compatible with a new database
Front end
Star schema
Define the users
Transform
43. Look-up tables referred to by fact tables
Dashboard
Dimension table
Translation table
Dimensional modelling
44. Second stage of the data warehouse data architecture design process
Hub and spoke Architecture
Define the grain
Operational system
Extract
45. A schema where dimensions may be connected to facts or to other dimensions
Snowflake schema
Snapshot
Dependent data mart
Conformed dimensions
46. Unlike independent data marts the marts are linked via middleware
Operational system
Design
Maintenance
Data mart bus architecture
47. A group of related fact tables
Data mart design
Parallel processing and/or partitioning
Family
Define the grain
48. Dimensions which are shared by two or more facts
Transform
Conformed dimensions
Data mart bus architecture
Master data
49. A database table that maps (e.g.) manufacturing product IDs to sales product IDs
Fact table
Hub and spoke Architecture
Define the users
Translation table
50. These extend BI into automating and optimising processes
OLAP
Choose the dimensions
Analytical applications
Conformed dimensions