MODULE 4 - MBA 703 SADHYA EXAM ACTUAL

MODULE 4 - MBA 703 (SADHYA) EXAM ACTUAL /

QUESTION AND VERIFIED ANSWER GRADE A+ .

The term scale here refers to a database getting larger and larger, being distributed on a larger number of computers connected via a network

Metadata - ----Answers---data that describes other data (data about data).Held in the data dictionary.

Examples:

• number of records • data type of field • size of field • description of field • default value of field • rules of use.Query-by- Example (QBE) - ----Answers---a graphical query tool, to retrieve data though visualized commands. QBE generates SQL for you, and is easy to use

In comparison with SQL, has limited functionalities and is unable to work without the DBMS environment.

• / 4

Hierarchal database model - ----Answers---connected data together in a hierarchy, allowing for a parent/child relationship between data.

Document-centric database model - ----Answers---allows for a more unstructured data storage by placing data into "documents" that could then be manipulated.

NoSQL databases (not only SQL) - ----Answers---arose from the need to solve the problem of large-scale databases spread over several servers or even across the world. can work with data in a looser way, allowing for a more unstructured environment, communicating changes to the data over time to all the servers that are part of the database - i.e. App Engine Datastore, Amazon DynamoDB

Databases that can manipulate structured as well as unstructured data and inconsistent or missing data; are useful when working with Big Data.

NoSQL databases vs. SQL databases - ----Answers---An argument regarding which database technology is superior.Also called SQL vs. NoSQL.

Record Locking - ----Answers---A technique of preventing simultaneous access to data in a database, to prevent inconsistent results. The classic example is demonstrated by 2 / 4

two bank clerks attempting to update the same bank account for two different transactions.

Important in relational databases.

Scale and the relational database model - ----Answers---the relational database model DOES NOT SCALE WELL.

Why Operational Data Can't Always Be Queried is a challenge for companies - ----Answers---most transactional databases aren't set up to be simultaneously accessed for reporting and analysis.

In order to run analytics the data must first be ported to a data warehouse or data mart.

data warehouse - ----Answers---a set of databases designed to support decision making in an organization. It is structured for fast online queries and exploration. Data warehouses may aggregate enormous amounts of data from many different operational systems.

data mart - ----Answers---database focused on addressing the concerns of a specific problem or business unit

contains a subset of data warehouse information

• / 4

Questions to ask when designing IS from a data perspective - ----Answers---1. Data relevance.

• Data sourcing.
• Data quantity.
• Data quality.
• Data hosting.
• Data governance.

E-discovery - ----Answers---identifying and retrieving relevant electronic information to support litigation efforts.Something a firm should account for in its archiving and data storage plans.

Business Intelligence Toolkit - ----Answers---1. Query and Reporting Tools

• canned reports
• ad hoc reports
• dashboards/scorecards
• Online analytical processing (OLAP)
• Data Mining

Query and Reporting Tools - ----Answers---present users with a subset of requested data, selected, sorted, ordered, calculated, and compared, as needed. Managers use these tools to see and explore what's happening inside their organizations

• / 4