cis257

Which of the following is not included in the detailed dimensional design worksheet?

Code

How many approaches are there for tracking slowly changing dimension attributes?

8

When developing the ETL Specification Document, you should include the following information

All of the above

Step 1 in Develop the ETL Plan is ____ the High-Level Plan.

Draw

Step 2 in Develop the ETL Plan is to Choose a(n) ____ Tool.

ETL

Which of the following is NOT an activity of Step 3: Develop Default Strategies?

Extract from one major source system.

Which of the following elements is not included in a detailed dimensional design worksheet?

Fact

Dimension tables are not necessary when using fact tables.

False

Step 10 in designing an ETL system includes requirements analysis.

False

The terms fact and dimension (in the context of data warehousing) originated from

General Mills and Dartmouth University.

Which of the following is not one of the nine steps, of the Extract Subsystem, for any organization addressing data quality?

Hire a new programmer

In Step 5 of the ETL system design, you should Populate Dimension Tables with _____ Data.

Historic

Which of the following topic would you ask about in a requirements meeting with a business user?

How they make decisions

Which of the following is not a key decision made during the design of a dimensional model?

Identify the sofware

Which of the following is not an example of a business requirement?

The DW/BI system should slice and dice data.

Which of the following is NOT an activity of Step 3: Develop Default Strategies?

Interview business analysts

Any issues, definitions, and data quality challenges discovered during the design process should be captured in a

Issue tracking log

Dimensional models implemented in a multidimensional database environment are referred to as

OLAP cubes.

_____ is the first step in the dimensional modeling process flow.

Preparation

What is the first task in the Kimball Lifecycle approach?

Program/Project Planning

Which of the following is not a typical representative from the business side of a cross-functional team?

Project manager

Which of the following is not included in a detailed dimensional design worksheet?

Requirement

Subsystem 1, Data Profiling, is the technical analysis of data to describe its content. In some sense, any time you perform a ________ investigative query on a database field, you are doing data profiling.

SELECT DISTINCT

Which of the following is NOT a key goal of Subsystem 2, Change Data Capture System?

Transfer all of the data.

Dimension and fact tables are joined using primary and foreign keys.

True

If the business users haven't accepted the DW/BI system as a foundation for improved decision making, any efforts have been exercises in futility.

True

It can take several days to load historic data.

True

OLAP servers present dimensional data in an intuitive way, enabling a range of analytic users to slice and dice the data.

True

One of the biggest challenges with the incremental ETL process is identifying new, changed and deleted rows.

True

The Job Scheduler subsystem would likely include an ETL tool with scheduling capabilities.

True

The fact table in a dimensional model stores the performance measurements resulting from an organization's business process events.

True

The final design documentation typically includes: -brief description of the project -high-level data model diagram -detailed dimensional design worksheet for each fact and dimension table -Open issues

True

The largest fact tables are usually transactional.

True

Third normal form (3NF) database models seek to reduce data redundancies.

True

An enterprise data warehouse bus matrix is a grid of ____.

processes and conformed dimensions

The most common dimension(s) in a retail application are

product

An accumulating snapshot for the order fulfillment pipeline process helps you to understand ____.

product flowing through the pipeline

Which of the following is NOT a process to help navigate technical architecture design?

Write code to accommodate the subsystem

Each row in the invoice fact table represents _____.

a single line item on the invoice

In business accounting, the list of revenues and costs is referred to as a _____.

profit and loss statement

A business matrix for order management processes might have a row for ____.

quotes

All of the following facts are additive except

regular unit price

To properly maintain and grow the DW/BI system, you should invest in the following resources EXCEPT

requirements analysis

A typical POS system inputs

sales quantity

All of the following are common dimensions in a retail applications except ____.

sales quantity

A fact that is additive across some dimensions, but not all is called ____.

semi-additive

A company's value chain ____.

should be depicted as a set of processes

Dimensional modeling is a longstanding technique for making databases

simple.

Which of the following is a semi-additive fact?

account balance

A column in opportunity/stakeholder matrix might be ____.

all of the above

An audit dimension in an order management system might include ____.

all of the above

When designing blended transactions in procurement systems consider ____.

all of the above

A business matrix for order management processes might have columns for ____.

all of the above.

When extracting data from source systems, each source might be in

all of the above.

A bus matrix for procurement processes may include two additional columns for ____.

atomic granularity and metrics

Table and column names should be meaningful to the

business

Once the design team is confident about the dimensional model, the model should be reviewed by all of the following EXCEPT

customers

Role playing is illustrated best by the ____ dimension.

date

Unlike most other dimensions, you can build the ____ dimension in advance.

date

When establishing naming conventions, the data model's labels must be

descriptive

All of the following are steps in dimensional design except

do a focus group session

In the publishing metaphor for DW/BI managers, the responsibilities of the manager are similar to those of a

editor-in-chief

The Error Event Schema is a centralized dimensional schema whose purpose is to record every _____ event thrown by a quality screen anywhere in the ETL pipeline.

error

Junk dimension data sourced from transactions include ____.

flags and indicators

An inventory transaction would not record ____.

hiring inventory staff

All of the following are inventory models except ____.

inventory value report

A row in enterprise data warehouse bus matrix might be ____.

issue purchase orders

The date dimension is important because ____.

it will be part of all fact tables

Following an interview with a business user, each interviewee should be asked about their definition of success criteria for the DW/BI project. Each criterion should be

measurable

A full scale Backup System needs to provide the following high-level capabilities, except

metadata

Degenerate dimensions are typically reserved for ____.

operational transaction identifiers

All of the following are steps in dimensional design except

perform a market analysis

Dimensional models implemented in relational database management systems are referred to as _________ because of their resemblance to a star-like structure.

star schemas

A value chain is composed of all of the following except____.

strategic planning

The initial task in the design session is to create a high-level dimensional model diagram for the

target business process

The DW/BI project plan identifies all the necessary Lifecycle tasks. A detailed plan is available on the Kimball Group website (www.kimballgroup.com) in

the Tools & Utilities tab under The Data Warehouse Lifecycle Toolkit, Second Edition book title.

The technical architecture for a DW/BI environment's technical services and infrastructure is analgous to

the blueprint for a new home

The lowest atomic data in a POS system is

the purchase of an individual product

The most granular data in a POS system is

the purchase of an individual product

Conformed dimensions have ____.

the same attributes

Multiple transaction fact tables in procurement systems may arise because ____.

they have different sources such as a purchasing or a warehousing system

The Fact Table Builder subsystem focuses on the ETL architectural requirements to effectively build the three primary types of fact tables, which include all of the following except:

transaction snapshot

If a dimension attribute value never changes, the ____ approach should be used.

type 0

If a dimension attribute value's history of changes is of no concern, the ____ approach should be used.

type 1

The predominate technique for tracking slow changes to a dimension attribute value is the ____ approach.

type 2

If one wishes to associate a new dimension attribute value with its history or its latest value the ____ approach is recommended.

type 3

The following is a hybrid approach for tracking slowly changing dimension attribute values:

type 5

The Slowly Changing Dimension Manager subsystem must determine how to handle an attribute _____ that has changed from the value already stored in the data warehouse.

value

A bus matrix for procurement processes might have a row for ____.

vendor invoices