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