$1.$ Which of the following is an example of analytic information?

a$.$ Information about the amount of money in a checking account

b$.$ Information showing which airline routes tend to be most profitable

c$.$ Information about the cost of a product

d$.$ Information showing the destination and origin of a particular airline route in the United States

$2.\_\_\_\_\_\_\_\_$ contain summative measures related to the subject of anticipated analyses.

a$.$ Fact tables

b$.$ Dimension tables

c$.$ Both dimension and fact tables

d$.$ None of the above

$3.$ Typically, in a star schema all $\_\_\_\_\_\_\_\_$ are given a simple, non$-$composite system$-$generated key, also called a surrogate key.

a$.$ Fact tables

b$.$ Dimension tables

c$.$ Time columns

d$.$ Transaction identifiers

$4.\_\_\_\_\_\_\_\_$ is a set of processes used to data warehouse elements with relevant data retrieved from OLTP databases:

a$.$ BI

b$.$ ETL

c$.$ OLAP

d$.$ OLTP

$5.$ Operational queries typically process: $\_\_\_\_\_\_$

a$.$ Larger amounts of data than analytical queries

b$.$ Smaller amounts of data than analytical queries

c$.$ Equal amounts of data as analytical queries

d$.$ Infinite amounts of data, incomparable to analytical queries

$6.$ Creating ETL infrastructure includes creating necessary procedures and code for: $\_\_\_\_\_\_\_\_$

a$.$ Designing and creating applications for indirect use by the end users

b$.$ The seamless load of the transformed data into the operational data bases

c$.$ Automatic extraction of relevant data from the data warehouses

d$.$ Transformation of the extracted data, so that its quality is assured, and its structure conforms to the structure of the modeled and implemented data warehouse

$7.$ Which of the following is NOT true? $\_\_\_\_\_\_\_\_\_$

a$.$ Data marts typically have fewer data sources than data warehouses

b$.$ Data marts typically have broader focus than data warehouses

c$.$ Data marts are typically not as big as data warehouses

d$.$ Data marts typically have shorter implementation time than data warehouses

$8.$ The $\_\_\_\_\_\_\_\_$ approach to slowly changing dimensions involves creating a new additional dimension record using a new value for the surrogate key every time a value in a dimension record changes.

a$.$ Type $1$

b$.$ Type $2$

c$.$ Type $3$

d$.$ Type $0$

$9.$ The $\_\_\_\_\_\_\_\_$ approach to slowly changing dimensions changes the old value in the dimension's record with the new value.

a$.$ Type $1$

b$.$ Type $2$

c$.$ Type $3$

d$.$ Type $0$

$10.$ A dimensional model might take which of the following forms? $\_\_\_\_\_\_\_\_\_$

a$.$ Fact table

b$.$ Dimension table

c$.$ Star schema