Data warehousing Architecture

Data warehousing Architecture

1) Which layer involves extracting the data from multiple sources, cleansing and transforming the data and loading it?
A) Operational database layer
B) Data access layer
C) Metadata layer
D) Informational access layer
View Answer / Hide Answer


2) Building a virtual warehouse requires excess capacity on operational database servers.
A) True
B) False
View Answer / Hide Answer


3) In which tier we have the OLAP Server that can be implemented in either of the following ways.
a) Relational OLAP
b) Multidimensional OLAP

A) Bottom Tier
B) Middle Tier
C) Top-Tier
D) None of the above
View Answer / Hide Answer


4) Which tier is the front-end client layer, a layer that holds the query tools, reporting tools, analysis tools and data mining tools?
A) Bottom Tier
B) Middle Tier
C) Top-Tier
D) Both A & B
View Answer / Hide Answer


5) Which warehouse model contains a subset of organization-wide data (a subset of data is valuable to specific groups of an organization)?
A) Virtual warehouse
B) Data mart
C) Enterprise warehouse
D) All the mentioned above
View Answer / Hide Answer


6) Which warehouse model collects all the information and the subjects spanning an entire organization?
A) Virtual warehouse
B) Data mart
C) Enterprise warehouse
D) None of the above
View Answer / Hide Answer


7) Which performs the following functions?
1) Extract the data from source system.
2) Fast Load the extracted data into temporary data store.
3) Perform simple transformations into structure similar to the one in the Data warehouse.

A) Query manager
B) Warehouse manager
C) Load manager
D) None of the above
View Answer / Hide Answer


8) Which consists of third-party system software, C programs and shell scripts?
A) Query manager
B) Warehouse manager
C) Load manager
D) None of the above
View Answer / Hide Answer


9) Which manager includes the following?
1) The controlling process
2) Stored procedures or C with SQL
3) Backup/Recovery tool
4) SQL Scripts

A) Query manager
B) Warehouse manager
C) Load manager
D) None of the above
View Answer / Hide Answer


10) These following operations are performed by
1) Creates indexes, business views, partition views against the base data.
2) Generates new aggregations and updates existing aggregations. Generates normalizations.
3) Transforms and merges the source data into the published data warehouse.

A) Query manager
B) Warehouse manager
C) Load manager
D) None of the above
View Answer / Hide Answer


11) Query manager is responsible for directing the queries to the suitable tables.
A) True
B) False
View Answer / Hide Answer


12) In which stage data warehouses are used to generate activity or transactions that are passed back into the operational systems for use in the daily activity of the organization.
A) Real time data warehouse
B) Offline operational databases
C) Offline data warehouse
D) Integrated data warehouse
View Answer / Hide Answer


13) Foreign keys of fact tables are primary keys of entity tables.
A) True
B) False
View Answer / Hide Answer


14) Which type of schema is used for organizing the tables such that we can retrieve the result from the database quickly in the warehouse environment?
A) BUS schema
B) Star schema
C) Snow flake schema
D) None of the above
View Answer / Hide Answer


15) To design an effective and efficient data warehouse, we need to understand and analyze the business needs and construct a business analysis framework.
A) Yes
B) No
View Answer / Hide Answer


16) The data is extracted from the operational databases or the external information providers. Gateways are the application programs that are used to extract data.
A) True
B) False
View Answer / Hide Answer


17) Abbreviate the term ODBC.
A) Operational Database Connection
B) Open Database Connection
C) Object Database Connection
D) Oriented Database Connection
View Answer / Hide Answer


18) Suppose we are loading the EPOS sales transaction, we need to perform which of these checks.
A) Strip out all the columns that are not required within the warehouse.
B) Convert all the values to required data types.
C) Both A & B
D) None of the above
View Answer / Hide Answer


19) Having a data warehouse offers which of these advantages:
A) Since a data warehouse can gather information quickly and efficiently, it can enhance business productivity.
B) A data warehouse provides us a consistent view of customers and items; hence, it helps us manage customer relationship.
C) A data warehouse also helps in bringing down the costs by tracking trends, patterns over a long period in a consistent and reliable manner.
D) All mentioned above
View Answer / Hide Answer


20) The business query view is the view of the data from the viewpoint of the end-user.
A) True
B) False
View Answer / Hide Answer