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