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