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