Chapter 6 - Analysis Information Modeling

24) What is an example of measure hierarchies?

A) Calculated sum of sales. Calculate sum of sales returns and allowances. Then calculate net sales by subtracting the sum of sales returns and allowances from the sum of sales.

36) Dark House Coffee sells coffee to customers across the country. You are given the following star schema showing sales transactions. Sales is a fact table and Product is a dimension table. What dimensions can exist in the information model?

A) ProductType can be a dimension in the Product table.

34) You are an internal auditor, and you are reviewing purchasing controls. You are given the following star schema showing purchase transactions. Purchases is a fact table and Approver is a dimension table.

A) There is a participates relationship from Purchases to Approver. The Approver is the internal agent.

The two goals for building an information model for star schema are

A) to create a rich set of measures for the fact table and to create a rich set of dimensions that can slice measures in many ways.

7) A data model that includes calculated columns and measures are called

An information model

What is an example of the information modeling pattern of "how many"

B) What is the count of credit card transactions that were rejected due to transaction dollar limits?

31) The information modeling pattern of integrated star schemas

B) analyzes how inflows and outflows affect resources.

A who table refers to a

B) dimension table that describes the agents involved in the transactions.

A what table refers to a

B) dimension table that describes the resources that were given up or acquired as part of a transaction.

A flows relationship

B) links resources that were given up to specific transactions.

21) What is a prerequisite for creating across-table calculations?

C) A relationship must exist to link the tables together.

Which is an example of the information modeling pattern of within-table numeric calculation

C) Calculate the royalty amount owed to authors by multiplying sales value and royalty percent.

1) Information modeling is the process of

C) generating additional knowledge from data that is relevant for analysis purposes

When can measure hierarchies be applied

D) Measure hierarchies can be used to solve complex problems by dividing the problem into smaller problems, then combining the different solutions.

29) The information modeling pattern of participates | transaction-who

D) can be implemented by creating measures for transactions and calculated columns for agents.

An integrated Star Schema

D) enables integrated analyses of resource inflows and outflows by combining multiple star schemas.

The information modeling pattern of how many can be used

D) to count the number of instances in fact tables and dimension tables.

48) What is a characteristic of the who-what-when schema pattern?

It supports a wide range of accounting analysis

37) Dark House Coffee sells coffee to customers across the country. You are given the following star schema showing sales transactions. Sales is a fact table and Product is a dimension table. What measure can exist in the information model?

TotalQuantitySold can be a measure in the sales table

16) Creating a new field from one or more numeric columns in the same table is called

a within table numeric calculation

A measure is

an information field that is created by algorithms and is used for analytical purposes

15) A relationship that links the calendar to specific transactions is called

an occurs relationship

30) The information modeling pattern of flows | transaction-what

analyzes what is involved in a transaction

17) The statistical technique of grouping numbers into a smaller number of groups, such as age groups, is referred to as

data binning

A calculated Column

is the result of an algorithm that was applied using other columns

A participates relationship

links agents to specific transactions

23) You are provided with a table showing transactions for the month. The expenses have been classified into capitalized costs and non-capitalized expenses. You want to determine the percentage of transaction values that are classified as capitalized costs. Your approach is to determine the total value of transactions that are capitalized costs, and then determine the total value of all transactions. Your next step is to divide the total value of capital costs by the total value of all transactions. This is an example of

measure hierarchies

What is an information modeling pattern especially useful for creating financial ratios

measure hierarchies

Algorithms are

sets of instructions that transform data into information

47) In a who-what-when star schema

the fact tables connects the who, what, and when tables

33) Dark House Coffee sells coffee to customers across the country. Purchases are made online, which exposes the company to cyber-attacks. Cyber-attacks have been logged and you need to create information models to analyze the data. The following star schema diagram shows cyber-attack attempts. Attacks is a fact table and Calendar is a dimension table.

there is an occurs relationship from attacks to calendar

32) Dark House Coffee sells coffee to customers across the country. They need to remit sales taxes that have been collected from sales transactions to state governments on a regular basis. The following star schema diagram shows tax remittance transactions. TaxRemittance is a fact table and Product is a dimension table. The state is considered the external agent.

this is a participates relationship

performing data analysis involves

using measures to determine the numbers to analyze and using dimensions to determine how to analyze them

A dimensions table that describes when a transaction occurs is called a

when table

38) Which question relies on a participates relationship?

which salesperson sold the greatest number of vehicles