click below
click below
Normal Size Small Size show me how
Stack #4410634
| Question | Answer |
|---|---|
| A data warehouse architecture where metadata, summary data, and raw data are stored within the central repository of the warehouse.,SIMPLE | |
| A data warehouse architecture where operational data must be cleaned and processed before being put in the warehouse.,SIMPLE WITH STAGING AREA | |
| A data warehouse in Banking, Telecommunication, and Financial Services are examples of ________.,APPLICATIONS OF DATA WAREHOUSE | |
| A specific type of database that represents data from multiple dimensions.,OLAP CUBE | |
| The _____ table is a collection of reference information about a measurable in the fact table.,DIMENSION | |
| The HOLAP system is a blend of _____ and MOLAP.,ROLAP | |
| An OLAP system that is created to facilitate management of both spatial and non-spatial data in a Geographic Information System.,SOLAP | |
| The type of OLAP system that works on the information that resides in a relational database.,ROLAP | |
| An OLAP system that utilizes a multi-dimensional database for storing and analyzing information.,MOLAP | |
| The full form of DOLAP acronym is ______ OLAP.,DESKTOP | |
| OLAP is located in between Front-end tools and ___________.,DATA WAREHOUSE | |
| ETL (Extract, Transform, Load) is an acronym for: __, ___, __.,EXTRACT, TRANSFORM, LOAD | |
| The ETL tool transforms data in the staging area before EDW.,TRUE | |
| ETL loading type that applies ongoing changes as when needed periodically.,INCREMENTAL LOAD | |
| An ETL loading type that populates all the data warehouse tables.,INITIAL LOAD | |
| An ETL loading type that erases the contents of one or more tables and reloads with fresh data.,FULL REFRESH LOAD | |
| This strategy is also known as delta, where only the data being changed is extracted and updates data warehouses.,PARTIAL EXTRACTION (WITH UPDATE NOTIFICATION) | |
| An OLAP operation that performs the analysis by taking one level of information for display.,SLICE | |
| An OLAP operation that performs analysis in deeper dimensions of data.,DRILL-DOWN | |
| An OLAP operation that is also known as consolidation, used to summarize operational data along with the dimension.,DRILL-UP | |
| The ____ operation performs the analysis that can gain a new view of data by rotating the data axes of the cube.,PIVOT | |
| Data Mining & Machine Learning: The ______ is about processing data and identifying patterns and trends in that information so that you can decide or judge.,DATA MINING | |
| A DM algorithm that constructs a classifier in the form of a decision tree.,C4.5 | |
| A DM algorithm that does not require a predefined set of outputs but rather looks for patterns or trends without any label or target.,UNSUPERVISED LEARNING | |
| A DM algorithm that requires a label or target.,SUPERVISED LEARNING | |
| A DM algorithm that has an assumption: Every feature of the data being classified is independent of all other features given the class.,NAÏVE BAYES | |
| A data mining technique that is used to determine when something is noticeably different from the regular pattern.,ANOMALY DETECTION | |
| A data mining technique that is used to make predictions based on relationships within the dataset.,REGRESSION | |
| A type of data mining algorithm that is used to mine data and provide the latest information on past or recent events.,DESCRIPTIVE ANALYSIS | |
| Data mining is applied in _______ websites to offer cross-sells and up-sells through their websites.,E-COMMERCE | |
| KDD stands for:,KNOWLEDGE DISCOVERY IN DATABASES | |
| Machine Learning & Classification: Artificial Intelligence refers to the algorithms that can learn from data to make predictions.,FALSE (MACHINE LEARNING) | |
| Machine Learning refers to the algorithms that can learn from data to make predictions.,TRUE | |
| Classification technique is a supervised learning.,TRUE | |
| Classification technique is an unsupervised learning.,FALSE | |
| Classification technique is a(n) _______ learning.,SUPERVISED | |
| Decision Tree is an example of an association algorithm.,FALSE | |
| Decision Tree is an example of a classification algorithm.,TRUE | |
| Decision Tree is an example of a(n) _______ algorithm.,CLASSIFICATION | |
| Clustering technique is a supervised learning.,FALSE | |
| Clustering technique is an unsupervised learning.,TRUE | |
| Clustering technique is a(n) _______ learning.,UNSUPERVISED | |
| CRISP-DM (Cross-Industry Standard Process for Data Mining): What is the 4th step in CRISP-DM?,MODELING | |
| The CRISP-DM phase that sets the initial data collection and proceeds with activities in order to get familiar with the data.,DATA UNDERSTANDING | |
| The phase of CRISP-DM that consists of presenting the results in a useful and understandable manner, and by achieving this, the project should achieve its goals.,DEPLOYMENT | |
| The EVALUATION phase of CRISP-DM that consists of presenting the results in a useful and understandable manner, and by achieving this, the project should achieve its goals.,FALSE (DEPLOYMENT) | |
| The DEPLOYMENT phase of CRISP-DM that consists of presenting the results in a useful and understandable manner, and by achieving this, the project should achieve its goals.,TRUE | |
| Unsupervised learning is a predictive analysis.,FALSE (DESCRIPTIVE ANALYSIS) | |
| The predictive analysis provides answers to future queries that move across using historical data as the chief principle for decisions.,TRUE | |
| The descriptive analysis provides answers to future queries that move across using historical data as the chief principle for decisions.,FALSE (PREDICTIVE ANALYSIS) | |
| The _____ analysis provides answers to future queries that move across using historical data as the chief principle for decisions.,PREDICTIVE | |
| It refers to the numeric study of data relationships.,STATISTICS | |
| In the 9-step KDD process, choosing a data mining task is the same as choosing a data mining algorithm.,FALSE | |
| The Naïve Bayes algorithm is a _______ data mining.,CLASSIFICATION | |