CIS 3050 STUDY GUIDE

routines that an application uses to direct the performance of procedures by the computer's operating system

Application Program Interface (API)

_______ InfoObjects have master data(attributes, etc.)

Characteristics

_____________ constraint assigns a value to an attribute when a new row is added to table.

DEFAULT

Which of the following is an objective of derived data?

Ease of use for decision support systems, Faster response time for user queries, Support data mining applications (ALL THE ABOVE)

ETL - Extract, transform, load

Extract: select Transform: Format Load: load data into datawarehouse

HTML

For presentation

The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the:

Grain

_____________ groups infoObjects types in SAP BI

InfoCatalog

The analysis of summarized data to support decision making is called:

Informational processing

______________ InfoObjects are part of the fact table in SAP BI

Key Figure

XSLT

Language

XML

Language you use to transfer data on the web.

software that allows an application to interoperate with other software without requiring user to understand and code low-level operations

Middleware

Common database APIs (MIDDLEWARE)

ODBC[OPEN DATABASE CONNECTIVITY], ADO .NET (MS APPS) , JDBC[JAVA DATABASE CONNECTIVITY] Java.sql(JDBC)

Data Mart

Small scope

All of the following are ways to handle changing dimensions EXCEPT:

create a snowflake schema.

When we consider data in the data warehouse to be time-variant, we mean:

data in the warehouse contain a time dimension so that they may be used to study trends and changes.

A logical data mart is a(n):

data mart created by a relational view of a slightly denormalized data warehouse.

A star schema contains both fact and ________ tables.

dimension

Going from a summary view to progressively lower levels of detail is called data:

drill-down

Snowflake schema

extended star schema

Star schema

has fact table, dimension

An operational data store (ODS) is a(n):

integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users.

The use of a set of graphical tools that provides users with multidimensional views of their data is called:

on-line analytical processing (OLAP).

Data that are never physically altered once they are added to the store are called ________ data.

periodic

Rotating the view of a multidimensional database for a particular data point is called data:

pivoting.

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.

reconciled

OLAP tools that use the database as a traditional relational database are called:

slice and dice

An expanded version of a star schema in which all of the tables are fully normalized is called a(n):

snowflake schema

The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:

subject-oriented

Every key used to join the fact table with a dimension table should be a ________ key.

surrogate