Save
Upgrade to remove ads
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

DBSA FA6

QuestionAnswer
The ________ type of ETL Loading process populates all the data warehouse tables. INITIAL LOAD
The type of OLAP system that works on the information that resides in a relational database. Note: Write only the acronym. ROLAP
The full form of DOLAP acronym is ________ OLAP. DESKTOP
OLAP is located in between Front-end tools and _____________. DATA WAREHOUSE
A ______ is a data structure that allows fast analysis of data according to the multiple dimensions that define a business problem. OLAP CUBE
Which type of ETL Loading process populates all the data warehouse tables? INITIAL LOAD
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
An OLAP operation that performs analysis in deeper among the dimensions of data. DRILL-DOWN
The full form of DOLAP acronym is ________ OLAP. DESKTOP
The predictive analysis provides answers of the future queries that move across using historical data as the chief principle for decisions. False
Classification technique is a supervised learning. True
Classification technique is an unsupervised learning. False
The descriptive analysis provides answers of the future queries that move across using historical data as the chief principle for decisions. False (PREDICTIVE)
Clustering is an unsupervised learning. True
A DM algorithm that has an assumption: Every feature of the data being classified is independent of all other features given the class. NAIVE BAYES
Data mining is applied in _________ websites to offer cross-sells and up-sells through their websites. E-COMMERCE
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 do not require a predefined set of outputs but rather look for patterns or trends without any label or target. UNSUPERVISED LEARNING
A DM algorithm that constructs a classifier in the form of a decision tree. C4.5
An OLAP system that is created to facilitate management of both spatial and non-spatial data in a Geographic Information system. Note: Write only the acronym. SOLAP
The ______ operation perform the analysis that can gain a new view of data by rotating the data axes of the cube. PIVOT
An OLAP operation that performs the analysis by taking one level of information for display. SLICE
ETL loading type that applies ongoing changes as when needed periodically. INCREMENTAL LOAD
This strategy is also known delta, where only the data being changed is extracted and update data warehouses. Partial Extraction (with update notification)
An ETL loading type that applies ongoing changes as when needed periodically. INCREMENTAL LOAD
The type of OLAP system that works on the information that resides in a relational database. ROLAP
Decision Tree is an example of a classification algorithm. True
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)
Decision Tree is an example of an association algorithm. False CLASSIFICATION
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
The Naïve Bayes algorithm is a _________ data mining. CLASSIFICATION
It refers to the numeric study of data relationships. STATISTICS
Clustering technique is a(n) _________ learning. UNSUPERVISED
ETL is an acronym for : ______, _________,________. Note: Separate each word by a space. EXTRACT TRANSFORM LOAD
The HOLAP system is a blend of _______ and MOLAP. Note: Write only the acronym. ROLAP
What is the full form of the acronym OLAP? ONLINE ANALYTICAL PROCESSING
An ETL loading type that populates all the data warehouse tables. INITIAL LOAD
An OLAP operation that is also known as consolidation, use to summarize operation data along with the dimension. DRILL-UP
Unsupervised learning is a predictive analysis. False (Descriptive Analysis)
Clustering technique is an unsupervised learning. True
A type of data mining algorithm that is used to mine data and provide the latest information on past or recent events. DESCRIPTIVE ANALYSIS
A data mining algorithm that requires a label or target. SUPERVISED LEARNING
Created by: jxxnixx
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards