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 FA5

QuestionAnswer
The ________ is also known as backend component. QUERY MANAGER
The _____ tier mainly consists of the Data Sources, ETL Tool, and Data Warehouse. BOTTOM
An electronic storage of a large amount of information by a business or organization. DATA WAREHOUS
Alternative name for Data Warehouse System is EIS. What is the full form of this acronym? Executive Information System
Data mining tool is an example of: END-USER ACCESS TOOL
ODS support only daily operations, so their view of historical data is very limited. True
An EDW with OLAP level is a two-tier architecture. False
The acronym OLAP stands for: Online Analysis Processing. False
An EDW with data mart level is a two-tier architecture. True
The acronym OLAP stands for: Online Analytical Processing. True
What is the full form of the acronym OLTP? Online Transactions Processing Databases
Data Warehouse uses ________ systems organize and present information in specific formats to accommodate the diverse needs of various users. OLAP
The ‘T’ in the acronym OLTP, stands for: ___________. TRANSACTIONS
The acronym ODS stands for : __________________. OPERATIONAL DATA STORE
An EDW architecture with data mart level Two-Tier
An extension of star schema where the dimension tables are connected to one or more dimensions. SNOWFLAKE SCHEMA
The _______ table is a collection of reference information about a measurable in the fact table. DIMENSION
The ______ Schema is also know as STAR JOIN SCHEMA). STAR
The Fact table measures is also known as numeric data. False
In Galaxy schema, it is possible to build this type of schema by splitting the one-star schema into more Star schemes. True
OLAP Server is in _______ tier. MIDDLE
The _______ is also called the front component. LOAD MANAGER
The QUERY MANAGER is also known as the _____ component. BACKEND
Enhanced Business Intelligence, query process and timely access to data are examples of ________. Advantages of data warehouse
The OLTP is used to manage dynamic data in real-time. True
The ‘T’ in the acronym OLTP, stands for: TRANSFORM. False Online Transaction Processing
An EDW component that refers to the tools that give end users access to data. REPORTING LAYER
An EDW with _________ level is a two-tier architecture. DATA MART
A _______ data mart allows sourcing organization’s data from a single data warehouse. DEPENDENT
The tool that transform data in the staging area before EDW. ETL
A schema where multiple fact tables share dimension tables. GALAXY SCHEMA
The fact table contains the ________ key column that allows joins with dimension tables. FOREIGN
In Star Schema, Every dimension in a star schema is represented with the only one-dimension table. True
Alternative name for Data Warehouse System is EIS. What is the full form of this acronym? EXECUTIVE INFORMATION SYSTEM
A data warehouse architecture where operational data must be cleaned and processed before being put in the warehouse. SIMPLE WITH STAGING AREA
Data warehouse in Banking, Telecommunication, Financial Services are examples of __________. Advantages of Data Warehouse
The Designing step of Data Mart implementation involves creating the physical database and the logical structures. False Constructing
The ‘T’ in the acronym OLTP, stands for: TRANSACTIONS. True
An EDW with data mart level is a three-tier architecture. True
ODS uses _______ systems to manage dynamic data in real-time. OLTP
Type of data warehouse which is refreshed in real time. ODS
The fact table contains the foreign key column that allows joins with ________ tables. DIMENSION
The fact table contains the foreign key column that allows joins with dimension tables. True
The disadvantage of the snowflake schema it uses large disk space. False
A data warehouse architecture where metadata, summary data, and raw data are stored within the central repository of the warehouse. SIMPLE
Data Warehousing started in the late 1980s when Paul Murphy and ___________ developed the Business Data Warehouse. BARRY DEVLIN
The LOAD MANAGER is also called the ______ component. FRONT
Data Warehousing started in the late 1980s when Paul Murphy and ___________ developed the Business Data Warehouse. Barry Devlin
An EDW architecture with data mart level is a three-tier architecture. Group of answer choices True False False
A _______ is a specific type of database that represents data from multiple dimensions. OLAP CUBE
An EDW architecture with OLAP Two-Tier
ODS support only ______ operations, so their view of historical data is very limited. DAY TO DAY
The Fact table is consist of the key column and measures or ______. FACT DATA
The fact table measures those that contain numeric facts. True
A data warehouse component that performs operations associated with the management of the data in the warehouse. WAREHOUSE MANAGER
Client-side front end tools is in ______ tier. TOP
What is the full form of the acronym BIS? Business Intelligence System
The ODS is a type of data warehouse that is refreshed in real time. True
Galaxy schema is also know as ________. FACT CONSTELLATION SCHEMA
The Galaxy schema can have one fact table and a number of associated dimension tables. False STAR SCHEMA
OLAP Server is in _______ tier. MIDDLE
The Data Mart is a type of data warehouse that is refreshed in real time. False
A ______ data mart that can take data from data warehouses or operational systems. HYBRID
The ______tool transform data in the staging area before EDW. ETL
The fact table measures those that contain ________ facts. NUMERIC
A ________ is a logical description that describes the entire database. DATABASE SCHEMA
The Star schema can have one fact table and a number of associated dimension tables. True
The fact table contains the primary key column that allows joins with dimension tables. False
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