Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
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
Normal Size Small Size show me how
CS0005 Database FA5
Database Systems and Administration FA 5
| Question | Answer |
|---|---|
| Alternative name for Data Warehouse System is EIS. What is the full form of this acronym? | **EXECUTIVE INFORMATION SYSTEMS |
| 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 |
| The middle tier consists of the _________. | OLAP SERVERS |
| What is the full form of the acronym BIS? | BUSINESS INTELLIGENCE SOLUTION |
| An EDW with data mart level is a two-tier architecture. | TRUE |
| The OLTP is used to manage dynamic data in real-time. | TRUE |
| The ‘T’ in the acronym OLTP, stands for: TRANSFORM. | FALSE (TRANSACTIONS) |
| The acronym OLAP stands for: Online Analysis Processing. | FALSE (ONLINE ANALYTICAL PROCESSING) |
| The Designing step of Data Mart implementation involves creating the physical database and the logical structures. | FALSE (CONSTRUCTING) |
| An EDW architecture with OLAP. | THREE-TIER |
| What is the full form of the acronym OLTP? | ONLINE TRANSACTIONS PROCESSING DATABASES |
| A _______ data mart allows sourcing organization’s data from a single data warehouse. | DEPENDENT |
| An EDW component that refers to the tools that give end users access to data. | REPORTING LAYER |
| Data Warehouse uses ________ systems organize and present information in specific formats to accommodate the diverse needs of various users. | OLAP |
| 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 fact table contains the ________ key column that allows joins with dimension tables. | FOREIGN |
| Galaxy schema is also know as ________. | FACT CONSTELLATION SCHEMA |
| A Data Warehouse system can have one or more fact tables. | TRUE |
| The fact table contains the foreign key column that allows joins with dimension tables. | TRUE |
| Data warehouse in Banking, Telecommunication, Financial Services are examples of __________. | APPLICATIONS OF DATA WAREHOUSE |
| Data mining tool is an example of: | END-USER ACCESS TOOL |
| Data Warehousing started in the late 1980s when Paul Murphy and ___________ developed the Business Data Warehouse. | BARRY DEVLIN |
| The ODS is a type of data warehouse that is refreshed in real time. | TRUE |
| 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 (3) |
| Data mart has a more implementation time compared to data warehouse systems. | FALSE |
| An EDW architecture with data mart level is a three-tier architecture. | FALSE (OLAP) |
| The tool that transform data in the staging area before EDW. | ETL |
| Type of data warehouse which is refreshed in real time. | ODS |
| An EDW with _________ level is a two-tier architecture. | DATA MART |
| The ______tool transform data in the staging area before EDW. | ETL |
| Data Mart implementation step that involves creating the physical database and the logical structures. | CONSTRUCTING |
| The ______ Schema is also know as STAR JOIN SCHEMA). | STAR |
| The ______ table contains the foreign key column that allows joins with dimension tables. | FACT |
| In Star Schema, Every dimension in a star schema is represented with the only one-dimension table. | TRUE |
| In Galaxy schema, it is possible to build this type of schema by splitting the one-star schema into more Star schemes | . **TRUE |
| He was considered as father of Data Warehouse. | INMON BILL |
| The acronym OLAP stands for: Online Analytical Processing. | TRUE |
| The acronym ODS stands for : __________________. | OPERATIONAL DATA STORE |
| A ______ data mart that can take data from data warehouses or operational systems. | HYBRID |
| An EDW with database directly connected with the analytical interfaces where the end user can make queries. | ONE-TIER |
| 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 fact table contains the primary key column that allows joins with dimension tables. | FALSE (FOREIGN KEY) |
| 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 warehouse component that transforms data in preparation for entering the data warehouse. | LOAD MANAGER |
| Data Warehousing started in the late 1980s when Paul _____ and Barry Devlin developed the Business Data Warehouse. | MURPHY |
| The Data Mart is a type of data warehouse that is refreshed in real time. | FALSE (ODS) |
| A _______ data mart is created without the use of a central data warehouse. | INDEPENDENT |
| In ______ schema the dimension tables are normalized which splits data into additional tables. | SNOWFLAKE |
| The fact table measures those that contain numeric facts. | TRUE |
| The _______ is also called the front component. | LOAD MANAGER |
| Data warehouse architecture with data marts. | **TWO-TIER ARCHITECTURE |
| 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 |
| The ETL tool transform data in the staging area before EDW. | TRUE |
| An EDW with data mart level is a three-tier architecture. | FALSE(WITH OLAP) |
| The Star schema can have one fact table and a number of associated dimension tables. | TRUE |
| The Fact table measures is also known as numeric data. | **TRUE |
| Data Warehousing started in the late 1980s when Paul Murphy and ___________ developed the Business Data Warehouse. | BARRY DEVLIN |
| Alternative name for Data Warehouse System is EIS. What is the full form of this acronym? | EXECUTIVE INFORMATION SYSTEM |
| The LOAD MANAGER is also called the ______ component. | FRONT |
| ODS support only ______ operations, so their view of historical data is very limited. | DAILY |
| An EDW architecture with data mart level | TWO-TIER |
| The ‘T’ in the acronym OLTP, stands for: ___________. | TRANSACTIONS |
| The ______ schema can have one fact table and a number of associated dimension tables. | STAR |
| The Star Schema is also know as _______. | STAR JOIN SCHEMA |
| The fact table measures those that contain ________ facts. | NUMERIC |
| The primary key column of the fact table has uniquely identifies each dimension record or row. | FALSE (DIMENSION TABLE) |
| The _______ is also called the front component. | LOAD MANAGER |
| The ‘T’ in the acronym OLTP, stands for: TRANSACTIONS. | TRUE |
| ODS uses _______ systems to manage dynamic data in real-time. | OLTP |
| An extension of star schema where the dimension tables are connected to one or more dimensions. | SNOWFLAKE SCHEMA |
| The Fact table measures is also known as fact data. | *TRUE |
| The Star Schema is also know as JOINT SCHEMA. | FALSE(STAR JOIN SCHEMA) |
Created by:
renren_