Database Final exam multiple choice

OLAP/BI tools can be used for: A) Ad-hoc direct analysis and creation of front-end (BI) applications B) Creation of front-end (BI) applications only C) Neither ad-hoc direct analysis nor creation of front-end (BI) applications D) Ad-hoc direct analysis only

A) Ad-hoc direct analysis and creation of front-end (BI) applications

In cases where multiple subjects of analysis share dimensions, the following occurs: A) A star schema is composed strictly of fact tables B) A dimensional model contains more than one fact table C) Some dimensions are eliminated D)All dimensions are reduced

B) A dimensional model contains more than one fact table

The process of deciding what to extract during the extraction process begins after the requirements and modeling stages are completed. A) True B) False

B) False

"If applicable, the archived data from operational sources is loaded in the data warehouse during the:" A) Archived data can never be loaded in the data warehouse B) Final load C) First load D) Refresh load

C) First load

Which of the following designs allows reusing (instead of duplication) of dimensions? A) Time column B) Snowflaking C) Galaxy of stars D) Degenerate dimension

C) Galaxy of Stars

Querying and presenting data from data warehouses and/or data marts for analytical purposes is known as: A) OLTP B) Micro batches C) OLAP D) ETL

C) OLAP

The set of processes that is used to populate the data warehouse tables with the appropriate relevant data retrieved from the operational databases is known as: A) OLTP B) BI C) OLAP D) ETL

D) ETL

OLAP tools are: A) Write-only tools B) Read and write tools C) Read, write, and delete tools" D) Read-only tools

D) Read-only tools

The ________ slowly changing dimension approach 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

A) Type 1

"In the case of so-called active data warehouses, the loads occur in ________ that happen continuously, ensuring that the data in the data warehouse is updated close to real time (enabling analysis of the latest data)." A) Dimensional modeling actions B) OLAP actions C) Micro batches D) OLTP actions

C) Micro batches

The dimensional schema is often referred to as the: A) Fact tables B) Dimension tables C) Star schema D) Transaction schema

C) star schema

In a typical, properly designed star schema, the number of records (rows) in any of the dimension tables is: A) Larger than in the fact table B) Same as in the fact table C) Smaller than in the fact table D) No typical rule - on average, there is an even number of dimension tables with larger, smaller and same number of records as in the fact table

C) Smaller than in the fact table

The ________ slowly changing dimension approach creates a new additional dimension record using a new value for the surrogate key every time a value in a dimension record changes. A) Type 0 B) Type 1 C) Type 2 D) Type 3

C) Type 2

The ________ slowly changing dimension approach involves creating a previous and current column in the dimension table for each column where changes are anticipated. A) Type 1 B) Type 2 C) Type 3 D) Type 0

C) Type 3

"Updating, querying, and presenting data from databases for operational purposes is known as:" A) OLTP B) ETL C) OLAP D) Micro batches

A) OLTP

Data cleansing is a part of: A) Transformation B) Load C) Extraction D) OLAP

A) Transformation

Which of the following processes is typically the most time- and resource-consuming? A) Creating the data warehouse model B) Creating the ETL infrastructure C) Creating the OLAP query D) Creating the data warehouse tables using the DBMS functionalities

B) Creating the ETL infrastructure

________ contain descriptions of some aspect of the business, organization, or enterprise useful to analysis. A) Fact Tables B) Dimension Tables C) Both Dimension and Fact tables D) None of the above

B) Dimension Tables

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

B) Dimension tables

________ contain sum measures related to the subject of analysis. A) Fact Tables B) Dimension Table C) Both Dimension and Fact Table D) none of the above

A) Fact Tables