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