DMBK5: Data Warehousing and Business Intelligence Management, Big Data (chapters 11 and 14)
Quiz by Виктория Инзина
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
The goals of data warehousing and BI discussed in this training are?
To support and enable effective business analysis and decision-making by knowledge workers
To provide a standard way to access metadata
All of the above
To define, approve, communicate, and implement principles, policies, procedures, metrics, tools, and responsibilities for Data Management
120s - Q2
Two of the main purposes of a data warehouse is to save time in building reports as well as increasing the ability to report and analyze data in ways you could not before.
truefalseTrue or False60s - Q3
When discussing big data, ______________is the speed at which data is captured, generated, or shared.
Veracity
Velocity
Variability
Viscosity
120s - Q4
What are some meanings or definitions of Business Intelligence?
Decision Support Systems (DSS)
Query, analysis, and reporting processes and procedures
All of the above
Strategic and operational analytics and reporting on corporate operational data to support business decisions, risk management, and compliance
120s - Q5
What is NOT a classic characteristic of a data warehouse?
Time-Variant
Non-Volatile
Subject-Oriented
Established
120s - Q6
Records in fact tables correspond to events, transactions, or measurements.
truefalseTrue or False60s - Q7
Dimensional modeling is NOT influenced by the availability of data in source systems.
falsetrueTrue or False60s - Q8
What is typically true of data warehouse and business intelligence activities/needs?
Identify sources of data and use data profiling tools to evaluate the state of the source data
Scope the business area and identify and interview appropriate business people
Look at the value chain of the enterprise to understand the business context
All of the above
120s - Q9
In the Kimball Approach, there is no requirement for a normalized data warehouse (though it is not precluded).
truefalseTrue or False60s - Q10
A choropleth map is a thematic map in which areas are shaded or patterned in proportion to the measurement of the statistical variable being displayed on the map.
truefalseTrue or False60s - Q11
What type of BI tool typically works to support interactive multi-dimensional analysis?
Data mining tool
Scorecard
OLAP tool
Discovery tool
120s - Q12
Data warehouses contain data from source systems together with externally provided data that is combined and stored in a manner optimized for query-intensive use.
truefalseTrue or False120s - Q13
Which of the following uses for a Data Mining Tool is NOT optimal?
Identification of data quality issues with your SAP Financial system
Predictive analysis
Analyze supermarket scanner data to determine when people are most likely to shop and buy certain products
Fraud detection
120s - Q14
Which of the following is NOT a good example of BI?
Statutory reporting to a Regulatory Body
Supporting Risk Management Decision Reporting
Strategic Analytics for Business Decisions
Decision Support Systems
120s - Q15
According to Henry Morris of IDC, Analytic Applications provide business with a pre-built solution to optimize a functional area or industry vertical
truefalseTrue or False60s