MIS 600 QUESTIONS WITH ACCURATE
ANSWERS
Benefits of a client server environment correct answer Scalability
Flexibility
Lower long term costs
Better match for systems in business
Competitive advantage
Reduced risk
Benefits of Distributed Database correct answer Scalability
High Availability
Improved Performance
Challenges of Distributed Database correct answer Complexity
Consistency
Security
Maintenance
Data warehousing correct answer A subject oriented, integrated
time variant, nonupdateable collection of data used in support of
management decision making process
Decentralized Databases correct answer A collection of
independent databases on non-networked computers
Dependent Data mart correct answer Derived directly from the
data warehouse. It is more consistent and more easy to integrate.
However it may take longer to implement and may have less
autonomy.
Difference between data warehouse / data mart correct answer A
data mart is a warehouse that is limited in scope obtained by
selecting and summarizing data from a data warehouse. End
users face more complexity, created for short term business
objectives
Difference between design techniques and distributed database
architectures correct answer Decisions made in physical design
, impact the efficiency of distributed databases while the
requirements of distributed architecture influence the choice of
physical design strategies.
Distributed Databases correct answer A single logical database
that is spread physically across computers in multiple locations
that are connected by a data communications link
Do all relations have indexes? correct answer No but they
improve performance
Does a data warehouse centralize data correct answer Yes
Does dependent or independent data mart need more relaible
meta data correct answer Dependent data mart
ETL correct answer Extract, Transform, Load
The goal is to provide a single, authoritative source for data that
supports decision making
Example of data transformation correct answer Converting date
columns into a standardized date format
Creating a new column to represent month and year
Example of data warehousing correct answer You need a place to
store data from a separate database in UNIX and SAP and
combine them for one single corporate view of the information.
Example of ETL correct answer Use select to extract the data,
transform using an into...select statement and then the data will
be transformed
Factors/Benefits of data warehousing correct answer Due to the
need for more efficient and larger scale data management,
business intelligence and analytics and enhanced performance.
Fat client correct answer A client PC that is responsible for
processing presentation logic, extensive application and business
rules logic, and many DBMS functions.
ANSWERS
Benefits of a client server environment correct answer Scalability
Flexibility
Lower long term costs
Better match for systems in business
Competitive advantage
Reduced risk
Benefits of Distributed Database correct answer Scalability
High Availability
Improved Performance
Challenges of Distributed Database correct answer Complexity
Consistency
Security
Maintenance
Data warehousing correct answer A subject oriented, integrated
time variant, nonupdateable collection of data used in support of
management decision making process
Decentralized Databases correct answer A collection of
independent databases on non-networked computers
Dependent Data mart correct answer Derived directly from the
data warehouse. It is more consistent and more easy to integrate.
However it may take longer to implement and may have less
autonomy.
Difference between data warehouse / data mart correct answer A
data mart is a warehouse that is limited in scope obtained by
selecting and summarizing data from a data warehouse. End
users face more complexity, created for short term business
objectives
Difference between design techniques and distributed database
architectures correct answer Decisions made in physical design
, impact the efficiency of distributed databases while the
requirements of distributed architecture influence the choice of
physical design strategies.
Distributed Databases correct answer A single logical database
that is spread physically across computers in multiple locations
that are connected by a data communications link
Do all relations have indexes? correct answer No but they
improve performance
Does a data warehouse centralize data correct answer Yes
Does dependent or independent data mart need more relaible
meta data correct answer Dependent data mart
ETL correct answer Extract, Transform, Load
The goal is to provide a single, authoritative source for data that
supports decision making
Example of data transformation correct answer Converting date
columns into a standardized date format
Creating a new column to represent month and year
Example of data warehousing correct answer You need a place to
store data from a separate database in UNIX and SAP and
combine them for one single corporate view of the information.
Example of ETL correct answer Use select to extract the data,
transform using an into...select statement and then the data will
be transformed
Factors/Benefits of data warehousing correct answer Due to the
need for more efficient and larger scale data management,
business intelligence and analytics and enhanced performance.
Fat client correct answer A client PC that is responsible for
processing presentation logic, extensive application and business
rules logic, and many DBMS functions.
