module 3
two inputs and two outputs of a data warehouse?
Two inputs to a data warehouse include databases and transaction files Two outputs of a data warehouse include OLAP analysis and data mining analysis
Define a database
A database is a collection of related data that is stored in a central location or in multiple locations
Tableau and Power BI are used for all of the following purposes except: Exploring and finding patterns in data Creating multiple charts to get meaningful insight into data Allowing analyzing data with different formats All of these options
All of these options
business analytics and list the three popular types of business analytics
Business analytics (BA) uses data and statistical methods to gain insight into the data and provide decision makers Three popular ones are descriptive, predictive, and prescriptive analytics.
five components of a DBMS?
Database engine Data definition Data manipulation Application generation Data administration
Which of the following is not a type of mobile analytics? Advertising and marketing analytics In-app analytics Performance analytics Installation analytics
Installation analytics
Which of the following is not among the 5 Vs of big data? Variance Value Variety Veracity
Variance
5 Vs of big data?
Volume, variety, velocity, veracity, and value.
two advantages and two disadvantages of a data mart compared to a data warehouse?
advantage: 1. Access to data is often faster because of their smaller size. 2. Response time for users is improved disadvantages: 1.Usually have more limited scope than data warehouses 2. Consolidating information from different departments or functional areas (such as sales and production) is more difficult
three recent trends in database design and implementation?
data-driven Web sites, distributed databases, and object-oriented databases.
In a data warehouse environment, ETL refers to extraction, transformations, and language. True or False?
false(extract, transform, load)
differences between physical and logical views of information?
physical view involves how data is stored on and retrieved from storage media, such as hard disks or magnetic tapes. logical view involves how information appears to users and how it can be organized and retrieved
A data lake gathers and stores data in its original format in a central location. The collected data can be structured as well as unstructured. True or False?
true
One of the main applications of databases and database systems is database marketing. True or False?
true
Strategic information systems (SISs) focus on big-picture, long-term goals and objectives and assist an organization or a decision maker to achieve them. True or False?
true