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

Database FA 5

CS0005 (1,1,0) Those with no choices are fill in the blanks.

QuestionAnswer
The middle tier consists of the _______ servers. OLAP
A data warehouse component that performs operations associated with the management of the data in the warehouse. WAREHOUSE MANAGER
A data warehouse component that performs operations associated with the management of the data in the warehouse. WAREHOUSE MANAGER
Data warehouse in Banking, Telecommunication, Financial Services are examples of __________. Group of answer choices Advantages of Data Warehouse Applications of Data Warehouse Benefits of Data Warehouse Tools for Data Warehouse Applications of Data Warehouse
The middle tier consists of the _________. Group of answer choices QUERY MANAGER LOAD MANAGER OLAP SERVERS WAREHOUSE MANAGER OLAP SERVERS
The ODS is a type of data warehouse that is refreshed in real time. (T/F) True
The Data Mart is a type of data warehouse that is refreshed in real time. (T/F) False
An EDW architecture with data mart level is a three-tier architecture. (T/F) False
An EDW with OLAP level is a two-tier architecture. (T/F) False
The OLTP is used to manage dynamic data in real-time. (T/F) True
The acronym ODS stands for : __________________. Group of answer choices OPERATIONAL DATA STORE OPERATION DATA STORAGE OPERATIONAL DATA STORAGE OPERATION DATA STORE OPERATIONAL DATA STORE
Data Mart implementation step that involves putting the data to use: querying the data, creating reports, charts, and publishing them. Group of answer choices Designing Constructing Managing Accessing Accessing
An EDW with _________ level is a two-tier architecture. Group of answer choices OLAP SERVERS DATA MART ODS STAGING DATA MART
An EDW with database directly connected with the analytical interfaces where the end user can make queries. Group of answer choices No tier Three-tier Two-tier One-tier One-tier
ODS uses _______ systems to manage dynamic data in real-time. Group of answer choices OLTP OLAP OLTP
The Star Schema is also know as _______. STAR JOIN SCHEMA
The fact table contains the ________ key column that allows joins with dimension tables. FOREIGN
The ______ schema can have one fact table and a number of associated dimension tables. STAR
In Star Schema, Every dimension in a star schema is represented with the only one-dimension table. (T/F) True
The Fact table measures is also known as numeric data. (T/F) True /
The load manager is also known as _______ component. FRONT
What is the full form of the acronym BIS? Group of answer choices Business Intelligent System Business Intelligence System Business Intelligent Solution Business Intelligence Solution Business Intelligence Solution
The _______ is also called the front component. Group of answer choices LOAD MANAGER WAREHOUSE MANAGER EXTRACTION MANAGER TRANSACTION MANAGER LOAD MANAGER
Data Warehousing started in the late 1980s when Paul Murphy and ___________ developed the Business Data Warehouse. Group of answer choices Barry Murphy Barry Inmon Barry Devlin Inmon Bill Barry Devlin
An EDW with data mart level is a two-tier architecture. (T/F) True
ODS support only daily operations, so their view of historical data is very limited. (T/F) True
The ‘T’ in the acronym OLTP, stands for: TRANSFORM. (T/F) False
The acronym OLAP stands for: Online Analysis Processing. (T/F) False
ODS support only ______ operations, so their view of historical data is very limited. Group of answer choices DAILY DAY TO DAY All the options ROUTINE DAILY
The tool that transform data in the staging area before EDW. Group of answer choices ETL ELT ETL
Data Mart implementation step that involves creating the physical database and the logical structures. Group of answer choices Accessing Managing Constructing Designing Constructing
The _______ table is a collection of reference information about a measurable in the fact table. DIMENSION
The fact table measures those that contain ________ facts. NUMERIC
Galaxy schema is also know as ________. FACT CONSTELLATION SCHEMA
The Galaxy schema can have one fact table and a number of associated dimension tables. (T/F) False
The fact table contains the foreign key column that allows joins with dimension tables. (T/F) True
///
Data Warehousing started in the late 1980s when Paul Murphy and ___________ developed the Business Data Warehouse. BARRY DEVLIN
Data Warehousing started in the late 1980s when Paul _____ and Barry Devlin developed the Business Data Warehouse. Group of answer choices Devlin Inmon Bill Murphy Murphy
An electronic storage of a large amount of information by a business or organization. Group of answer choices DATA MARTS END-USER TOOLS DATA WAREHOUSE OLAP SERVERS DATA WAREHOUSE
Data warehouse architecture with data marts. Group of answer choices Hub and spoke Sandboxes DW with staging area ODS Hub and spoke
The acronym OLAP stands for: Online Analytical Processing. (T/F) True
An EDW with data mart level is a three-tier architecture. (T/F) False
The ETL tool transform data in the staging area before EDW. (T/F) True
An EDW architecture with OLAP Group of answer choices Not in Tier Three-Tier One-Tier Two-Tier Three-Tier
What is the full form of the acronym OLTP? Group of answer choices Online Loading Transactions Processing Databases Online Transactions Processing Databases Online Transactions Procedural Databases Online Transformation Processing Databases Online Transactions Processing Databases
Type of data warehouse which is refreshed in real time. Group of answer choices DATA MART Not in the options EDW ODS ODS
The ______tool transform data in the staging area before EDW. Group of answer choices ETL DATA WAREHOUSE End-user Data Mining ETL
The fact table contains the foreign key column that allows joins with ________ tables. DIMENSION
A schema where multiple fact tables share dimension tables. GALAXY SCHEMA
The Fact table is consist of the key column and measures or ______. FACT DATA
The primary key column of the fact table has uniquely identifies each dimension record or row. (T/F) False
The fact table measures those that contain numeric facts. (T/F) True
///
The _____ tier mainly consists of the Data Sources, ETL Tool, and Data Warehouse. BOTTOM
Data mining tool is an example of: Group of answer choices WAREHOUSE MANAGER QUERY MANAGER END-USER ACCESS TOOL LOAD MANAGER END-USER ACCESS TOOL
Data mart has a more implementation time compared to data warehouse systems. Group of answer choices True False False
The ‘T’ in the acronym OLTP, stands for: ___________. Group of answer choices TRANSACTIONS TOOL TRANSFER TRANFORM TRANSACTIONS
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
The Star schema can have one fact table and a number of associated dimension tables. Group of answer choices True False True
Galaxy schema is also know as STAR CONSTELLATION SCHEMA. Group of answer choices True False False
///
Created by: nemesis12414
 

 



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