Mis 430 final

In a dimensionally modeled data warehouse what is added after what

Fact tables after conformed Dimensions

If applicable, the archived data from operational sources is loaded in the data warehouse during the

First load

Coarser granularity aggregated fact tables

Have records that represent summarizations of multiple facts

Which of the following is not a part of the data warehouse requirements step

Logical modeling

Typically operational data is what while analyst is data is what

Non redundant, sometimes redundant Used by all types of employees, used by a narrow set of users (A and C)

The data quality control and improvement are included in the what process

Transformation

When are the requirements and schema defined for data stored in a data lake?

When the data is queried

When would you use a data lake versus a data warehouse

When you want a cheaper and flexible approach for data storage

Why are independent data marts considered inferior?

Inability for straightforward analysis across the enterprise

Which of the following is a pro to using inmons approach to data warehousing

Low maintenance

Which statement below regarding surrogate keys is true?

Surrogate keys are only used within the data warehouse

The normalized data warehouse model is

The inmon model and a top down approach

What is the alpha release of the data warehouse deployment

The internal deployment of a system to the members of the development team for initial testing of its functionalities

Which slowly changing dimensions type creates a new additional dimension record using a new value or the surrogate key?

Type 2 method

Big data characteristic typically is

Unstructured or semi structured

Which of the following is NOT a characteristic of big data

Volatility

Five Vs of Big Data

Volume, velocity, variety, value, and veracity

Visualization

Interactive visual representations of data to amplify cognition To create insight

Which of the following does not describe data marts

It often narrowed than organization wide

During the ETL process, an example of transforming the structure of extracted data is/are

Joining data from multiple sources Deriving a new calculated value (profit= revenue -budget)

A batch process that inserts the data into the data warehouse tables in an automatic fashion without user involvement is part of which ETL process

Load

Which of the following is not a pro (benefit) for the Inmon approach for data warehouse modeling?

Low initial cost

What is the internal deployment of a system to the members of the development team for initial testing of its functionalities

Alpha release

Drill up:

Changing the level of granularity of a particular dimension Dimension reduction (A and B)

Aggregated fact tables have what kind of granularity? Are they quicker or more complex to query than detailed fact tables

Coarser. Quicker.

The bus matrix is used to identify what kind of dimension?

Conformed dimension

Which of these facts describe a dimension table

Contains static data

What does not happen during transformation process in ETL

Data loading into the data warehouse

Which statement is true about normalized data warehouse

Data warehouse as an integrated analytical database

Data granularity

Defines the level of detail in a dataset

Which of the following is true regarding independent data marts

Does not have its own sources systems

Which of the following aspects of the data warehouse development process often takes the most time and resources

ETL process

Why detailed face tables have fine level of granularity?

Each record represents a single fact

Which OLAP/BI tool feature reorganized the values displayed in the original query result by moving values of a dimension column from one axis to another

Pivot

What is one of the five second test guidelines of a dashboard?

Provide interactivity

Which of the following is not a benefit associated to a star schema

Query efficiency

Type 2 method can be combined with the use of

Row indicators and time stamps

Which statement is incorrect about basic OLAP BI tools feature

Slice and dice operation only adds specified dimension attributes from the already displayed result

Which of the following is not a characteristic of analytical data

Application oriented

Which of the following is not true for analytical data

Application oriented