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