Podcast
Questions and Answers
Which term emerged to describe the central database that brought together data from different systems used throughout a company?
Which term emerged to describe the central database that brought together data from different systems used throughout a company?
- Online Analytical Processing (OLAP)
- Executive Information System (EIS)
- Management Information System (MIS)
- Data Warehouse (DWH) (correct)
Which applications support decision-making without the additional input of more advanced methods or modeling?
Which applications support decision-making without the additional input of more advanced methods or modeling?
- Online Analytical Processing (OLAP)
- Text Mining
- Management Information System (MIS)
- Executive Information System (EIS) (correct)
What term is used to refer to all BI applications that are used directly or indirectly for decision-making?
What term is used to refer to all BI applications that are used directly or indirectly for decision-making?
- Business Intelligence (BI) (correct)
- Executive Information System (EIS)
- Online Analytical Processing (OLAP)
- Data Warehouse (DWH)
Which of the following can be used to control access to distributed BI knowledge in larger environments?
Which of the following can be used to control access to distributed BI knowledge in larger environments?
Which feature of BI portals allows users to access web-based analysis systems without installing additional software?
Which feature of BI portals allows users to access web-based analysis systems without installing additional software?
What is the purpose of myCampus?
What is the purpose of myCampus?
Which process is used to convert operational data into management-relevant information?
Which process is used to convert operational data into management-relevant information?
What is the purpose of the staging area in a data warehouse?
What is the purpose of the staging area in a data warehouse?
Which architecture variant involves creating independent data marts in individual departments?
Which architecture variant involves creating independent data marts in individual departments?
What is the purpose of the enrichment sub-process in the ETL process?
What is the purpose of the enrichment sub-process in the ETL process?
Which type of metadata focuses on the subsequent layers of transformation and authorization management?
Which type of metadata focuses on the subsequent layers of transformation and authorization management?
What does OLAP stand for?
What does OLAP stand for?
Which data model is more flexible for decision makers in a data warehouse application?
Which data model is more flexible for decision makers in a data warehouse application?
Which storage model combines the strengths of both relational and multidimensional concepts?
Which storage model combines the strengths of both relational and multidimensional concepts?
Which term refers to procedures and processes that facilitate the systematic analysis of electronic data?
Which term refers to procedures and processes that facilitate the systematic analysis of electronic data?
What are operational systems used for?
What are operational systems used for?
What is the purpose of a data warehouse?
What is the purpose of a data warehouse?
What are the characteristics of dispositive data?
What are the characteristics of dispositive data?
Which type of system primarily presents highly condensed, controlling-relevant internal data?
Which type of system primarily presents highly condensed, controlling-relevant internal data?
Which type of system often integrates external information that is often unstructured but relevant to the company?
Which type of system often integrates external information that is often unstructured but relevant to the company?
Which type of system is used for the software-supported determination of previously unknown correlations, patterns, and trends evident in large databases?
Which type of system is used for the software-supported determination of previously unknown correlations, patterns, and trends evident in large databases?
Which type of system provides analyses and data based on specific business concepts or procedures?
Which type of system provides analyses and data based on specific business concepts or procedures?
Which two database structures are commonly used in the physical implementation of a multidimensional data model?
Which two database structures are commonly used in the physical implementation of a multidimensional data model?
What is the main difference between star schema and snowflake schema?
What is the main difference between star schema and snowflake schema?
What is the purpose of SCD type 2 in a dimension historicization?
What is the purpose of SCD type 2 in a dimension historicization?
What are OLAP systems primarily used for?
What are OLAP systems primarily used for?
Flashcards are hidden until you start studying
