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

F5 CS0005

QuestionAnswer
A data warehouse architecture where metadata, summary data, and raw data are stored within the central repository of the warehouse. SIMPLE
He was considered as father of Data Warehouse. INMON BILL
Raising ownership, dimensional technique and extra reporting are some ______ of data warehouse. Group of answer choices ADVANTAGES DISADVANTAGES DISADVANTAGES
Data Warehousing started in the late 1980s when Paul _____ and Barry Devlin developed the Business Data Warehouse. MURPHY
An EDW architecture with data mart level is a three-tier architecture. False
The acronym OLAP stands for: Online Analysis Processing. False (Online Analytical Processing Server)
The Data Mart is a type of data warehouse that is refreshed in real time. False (Data warehouse)
The Designing step of Data Mart implementation involves creating the physical database and the logical structures. False (Constructing)
Type of data warehouse which is refreshed in real time. ODS
A ______ data mart that can take data from data warehouses or operational systems. HYBRID
A _______ data mart allows sourcing organization’s data from a single data warehouse. DEPENDENT
ODS uses _______ systems to manage dynamic data in real-time. OLTP
An EDW with database directly connected with the analytical interfaces where the end user can make queries. One-tier
A ________ is a logical description that describes the entire database. SCHEMA
The Star Schema is also know as _______. STAR JOIN SCHEMA
The ______ Schema is also know as STAR JOIN SCHEMA). STAR
The fact table contains the primary key column that allows joins with dimension tables. True
The fact table measures those that contain numeric facts. True
Data warehouse architecture with data marts. HUB AND SPOKE?
The load manager is also known as _______ component. FRONT
Data Warehousing started in the late 1980s when Paul Murphy and ___________ developed the Business Data Warehouse. Barry Devlin
The acronym OLAP stands for: Online Analytical Processing. True
The ‘T’ in the acronym OLTP, stands for: TRANSFORM. False
The ETL tool transform data in the staging area before EDW. True
An EDW with data mart level is a three-tier architecture. False (Two-tier)
An EDW architecture with OLAP Three-Tier
An EDW with database directly connected with the analytical interfaces where the end user can make queries. One-tier
The ______tool transform data in the staging area before EDW. ETL
A _______ data mart is created without the use of a central data warehouse. INDEPENDENT
Data Warehouse uses ________ systems organize and present information in specific formats to accommodate the diverse needs of various users. OLAP???
In ______ schema the dimension tables are normalized which splits data into additional tables. SNOWFLAKE
An extension of star schema where the dimension tables are connected to one or more dimensions. SNOWFLAKE SCHEMA
These tables hold fields that represent the direct facts, as well as the foreign fields that are used to connect the fact table with other dimension tables in the Data Warehouse system. FACT TABLE
Galaxy schema is also know as FACT CONSTELLATION SCHEMA. True
The Star schema can have one fact table and a number of associated dimension tables. True
Client-side front end tools is in ______ tier. TOP
Alternative name for Data Warehouse System is EIS. What is the full form of this acronym? Executive Information System
Data warehouse in Banking, Telecommunication, Financial Services are examples of __________. Applications of Data Warehouse
The ‘T’ in the acronym OLTP, stands for: TRANSACTIONS. True
An EDW with data mart level is a two-tier architecture. True
ODS support only daily operations, so their view of historical data is very limited. True
What is the full form of the acronym OLTP? Online Transactions Processing Databases
The ‘T’ in the acronym OLTP, stands for: ___________. TRANSACTIONS
Data Mart implementation step that involves putting the data to use: querying the data, creating reports, charts, and publishing them. Accessing
The ______ table contains the foreign key column that allows joins with dimension tables. FACT
The Galaxy schema can have one fact table and a number of associated dimension tables. False (STAR SCHEMA)
The Star Schema is also know as JOINT SCHEMA. False (STAR JOIN SHEMA)
The _______ is also called the front component. LOAD MANAGER
The middle tier consists of the _______ servers. OLAP
Data mining tool is an example of: END-USER ACCESS TOOL
Enhanced Business Intelligence, query process and timely access to data are examples of ________. Advantages of data warehouse
An electronic storage of a large amount of information by a business or organization. DATA WAREHOUSE
A _______ is 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
In Star Schema, Every dimension in a star schema is represented with the only one-dimension table. True
A type of Data Management System that is solely intended to perform queries and analysis from large amount of historical data to support BI activities. DATA WAREHOUSE
The _____ tier mainly consists of the Data Sources, ETL Tool, and Data Warehouse. BOTTOM
OLAP Server is in _______ tier. MIDDLE
Data mart has a more implementation time compared to data warehouse systems. False
An EDW with OLAP level is a two-tier architecture. False
ODS support only ______ operations, so their view of historical data is very limited. DAILY
An EDW architecture with data mart level Two-Tier
The Fact table is consist of the key column and measures or ______. FACT DATA
Created by: BroTaku
 

 



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