MIS Session IV Analytics

__________ is a subject-oriented, integrated, time-variant, non-volatile collection of data

• Data Mine

• Data Warehouse

• Data Sort

• Database

In a TPS, data is stored, retrieved and processed in___________

• OLAP

• OLTP

• FTP

• CTPL

__________describes the data contained in the data warehouse.

• Prodata
• SomeData
• MetaData
• Infodata

The star schema is composed of __________ fact table.

• 1
• 2
• 3
• 4

A Snowflake schema can have one or more Fact Tables

• true
• false

A Fact Constellation or Galaxy schema can have one or more Fact Tables

• true
• false

ETL referes to__________________

• Exit Transform Load
• Extract Transfer Load
• Extract Transform Load
• Extract Transform Lift

The type of relationship in star schema is __________________.

• One to One
• One to Many
• Many to Many
• None to None

SQL stands for_________________

• Standard Queue Lift
• Standard Question Language
• Standard Query Language
• Structured Query Language

The ________________ is the simplest data warehouse schema. <br />.

• star schema
• Snowflake schema
• Fact Constellation
• Galaxy