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