Deck 3: Databases and Data Warehouses: Supporting the Analytics-Driven Organization

Question 1

A _____ is a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks.

A)data mine
B)data warehouse
C)data dictionary
D)data entry

Answer 1

B
Explanation: A data warehouse is,in fact,a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks.

Question 2

A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application?

A)Online analytical processing (OLAP)
B)Geographic information systems (GIS)
C)Enterprise resource planning (ERP)
D)Decision support systems (DSS)

Answer 2

A
Explanation: Online analytical processing (OLAP)is the manipulation of information to support decision making.

Question 3

Your student ID is an example of a(n)____.

A)relation
B)attribute
C)category
D)table

Answer 3

B
Explanation: Within each file,you can see specific pieces of information called attributes.For example,the Order file contains Order Number,Order Date,Customer Number,Delivery Address,Concrete Type,Amount (this is given in cubic yards),Truck Number,and Driver ID.

Question 4

A(n)_____ is a field or group of fields that uniquely describes each record.

A)identifying key
B)relational key
C)primary key
D)main key

Question 5

Which type of database model organizes and accesses information according to its logical structure rather than its physical structure?

A)Hierarchical
B)File-based
C)Relational
D)Conventional

Question 6

What is the most popular model for creating databases?

A)Hierarchical database model
B)Object-oriented database model
C)Ecological database model
D)Relational database model

Question 7

_____ is the science of fact-based decision making.

A)Statistics
B)Synthesis
C)Analytics
D)Deduction

Question 8

If your phone number was used in a clothing store to uniquely identify you as a customer,the phone number would be considered a(n)____.

A)identifying field
B)relational field
C)primary key
D)principle key

Question 9

Which type of constraint ensures the quality of information in a relational database?

A)Environmental constraint
B)Business constraint
C)Integrity constraint
D)Production constraint

Question 10

Which term refers to a specific piece of information that is stored in a database file?

A)Relation
B)Category
C)Class
D)Attribute

Question 11

Which type of application requires that you know the physical location of information before you are able to access it?

A)CRM
B)ERP
C)Spreadsheets
D)Word processor

Question 12

A _____ is a collection of information that you organize and access according to the logical structure of that information.

A)database
B)data dictionary
C)data mart
D)data mine

Question 13

_____ is the gathering of input information,processing that information,and updating existing information to reflect the gathered and processed information.

A)Online analytical processing (OLAP)
B)Business intelligence (BI)
C)File management systems (FMS)
D)Online transaction processing (OLTP)

Question 14

_____ are the technology tools that directly support OLTP.

A)OLAP and Hypercubes
B)Databases and DBMSs
C)EIS and DSS
D)CRM and ERP

Question 15

Which part of a relational database contains the logical structure for the information?

A)Data dictionary
B)Relation
C)Query
D)SQL

Question 16

A(n)_____ key is a primary key of one file that appears in another file.

A)foreign
B)secondary
C)identifying
D)duplicate

Question 17

A(n)_____ helps you specify the logical organization for a database and access and use the information within a database.

A)DBMS
B)ERP
C)CRM
D)EIS

Question 18

_____ refers to collective information that gives you the ability to make effective,important,and often strategic business decisions.

A)Query-by-example
B)Business intelligence
C)Information analysis
D)SQL

Question 19

Databases that support OLTP are most often referred to as ____.

A)OLAP
B)data warehouses
C)relational databases
D)operational databases

Question 20

Which application supports the manipulation of information to support decision making?

A)OLTP
B)CRM
C)ERP
D)OLAP

Question 21

What must you define before adding any information to a relational database?

A)The intended audience
B)The physical hardware structure
C)The administrative rights of users
D)The logical structure of the database

Question 22

Which data manipulation tool allows you to graphically design the answer to your business questions?

A)Report generators
B)Application reports
C)Query-by-example tools
D)Data administration tools

Question 23

Which data manipulation tool allows you to see the contents of a database file and make whatever changes you want?

A)Report Generator
B)View
C)Query-by-example tools
D)SQL

Question 24

A database management system contains five important software components.Which of the following components accepts and processes requests from the other four database components?

A)DBMS engine
B)Data definition subsystem
C)Data manipulation subsystem
D)Data administration subsystem

Question 25

_____ is the process of reinstalling the backup information in the event the information was lost.

A)Recovery
B)Recycling
C)Retrieval
D)Reproduction

Question 26

A _____ is simply a copy of the information stored on a computer.

A)photocopy
B)replica
C)duplicate
D)backup

Question 27

Which data administration facility allows you to control who has access to what information and what type of access those people have?

A)Security management facilities
B)Query optimization facilities
C)Reorganization facilities
D)Concurrency control facilities

Question 28

SQL is:

A)a standardized fourth generation language found in most DBMSs.
B)a storage tool that holds the data and definitions for a database.
C)an administrative tool that allows you to set access rights for database users.
D)a programming language that can be used instead of a DBMS.

Question 29

A database management system contains five important software components.Which of the following components allows you to create and maintain the data dictionary?

A)Application generation subsystem
B)Data manipulation subsystem
C)Data definition subsystem
D)Data administration subsystem

Question 30

Which database management subsystem is responsible for backup and recovery,security management,query optimization,concurrency control,and change management?

A)Application management
B)Data administration
C)Data management
D)Data optimization

Question 31

Which of the following data administration facilities continually maintain statistics concerning how the DBMS engine physically accesses information?

A)Security management facilities
B)Query optimization facilities
C)Reorganization facilities
D)Concurrency control facilities

Question 32

If you were a programmer and needed to view information as it was stored by the database,what type of database view would you see?

A)Logical view
B)Physical view
C)Stored view
D)Objective view

Question 33

If you were able to quickly pull information from student records with course records to build students' schedules,you would be using a _____ tool.

A)data administration
B)query-by-example
C)data definition
D)data manipulation

Question 34

Which of the following DBMS components allows you to quickly develop computer routines or tasks that will process your business transactions?

A)Data definition subsystem
B)Application generation subsystem
C)Data administration subsystem
D)Data manipulation subsystem

Question 35

Application generation facilities are most often used by what group of employees?

A)Knowledge workers
B)IT specialists
C)Sales representatives
D)Operational managers

Question 36

If you were looking at information in a database and you are able to see only the information you needed in the format you wanted,what type of database view is it?

A)Logical view
B)High-level view
C)Subjective view
D)Physical view

Question 37

Which of the following DBMS components allows you to add,change,and delete information in a relational database?

A)Data definition subsystem
B)Data manipulation subsystem
C)Data administration subsystem
D)Application generation subsystem

Question 38

_____ facilities find the "shortest route" to the information you want so you don't have to.

A)Backup and recovery facilities
B)Query optimization facilities
C)Change management facilities
D)Concurrency control facilities

Question 39

_____ ensure the validity of database updates when multiple users attempt to access and change the same information.

A)Backup and recovery facilities
B)Query optimization facilities
C)Change management facilities
D)Concurrency control facilities

Question 40

Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?

A)Query reporting tools
B)SQL reports
C)Report generators
D)Application reports

Question 41

Data warehouses exist to support:

A)MRP.
B)OLAP.
C)OLTP.
D)SQL.

Question 42

_____ is responsible for the development and use of firewalls,intranets,extranets,and anti-virus software.

A)CIO
B)CPO
C)CSO
D)CTO

Question 43

What is the difference between multidimensional analysis and statistical analysis?

A)Multidimensional analysis is a higher level of mathematical analysis than normal statistical analysis.
B)Multidimensional analysis uses a form of fuzzy logic whereas statistical analysis is objective.
C)Statistical analysis requires a step-by-step approach to data analysis whereas multidimensional analysis does not.
D)Statistical analysis is a mathematical approach to understanding information whereas multidimensional analysis is a way of viewing information from different perspectives.

Question 44

If you were to perform a regression analysis,what type of data warehouse tool would it be?

A)Statistical
B)Multidimensional analysis
C)Production analysis
D)Hypercube

Question 45

If you were working for a large pharmaceutical company and building a sales report on the current prescription writing habits of doctors,what type of information repository would you be most likely working with?

A)Data mine
B)Data dictionary
C)Data shop
D)Data mart

Question 46

In a data warehouse,which data-mining tool would you use to quickly build reports without having to write programming code?

A)Application report generator
B)Artificial intelligence
C)Multidimensional analysis tools
D)Query-and-reporting tools

Question 47

A data warehouse is:

A)a large hardware environment that supports multiple platforms.
B)a logical collection of information used to create business intelligence.
C)an operational database system used to manage and analyze transactional data.
D)an accumulation of all operational data stored by large organizations.

Question 48

_____ is responsible for overseeing every aspect of an organization's information resource.

A)CTO
B)CPO
C)CIO
D)CSO

Question 49

A hypercube is:

A)a hyper text link stored in a database.
B)a data definition that is linked to other related,but external,attributes or fields.
C)a database that is built on Internet technology.
D)a multidimensional representation of information.

Question 50

Who,among the following,is responsible for ensuring that information is used in an ethical way?

A)CIO
B)CPO
C)CTO
D)CSO

Question 51

Which of the following functions plans for,oversees the development of,and monitors the information resource of an organization?

A)Data administration
B)Strategic management
C)Data manipulation
D)Operational planning

Question 52

_____ are the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity.

A)KPIs
B)DPIs
C)QBEs
D)SQLs

Question 53

If you were viewing information from different perspectives in a multidimensional analysis,you would be ____.

A)turning the cube
B)creating neural networks
C)creating hyperlinks
D)applying fuzzy logic

Question 54

What type of software tool is used to query information stored in a data warehouse?

A)OLTP
B)Data dictionary
C)Data-mining
D)Decision support

Question 55

If you were comparing information from various divisions of an organization such as sales,marketing,and production,what type of information repository would you be most likely working with?

A)Data cuboid
B)Data warehouse
C)Hypercube database
D)Data mining

Question 56

_____ is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

A)Data mart
B)Data mine
C)Data dictionary
D)Database

Question 57

A(n)_____ displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker.

A)hypercube
B)digital dashboard
C)intelligent agent
D)neural network

Question 58

What does it mean for a data warehouse to be multidimensional?

A)The database stores data,facts,and definitions for all stored information.
B)Data can be linked to other sources of internal and external information.
C)The files stored in a warehouse contain several layers of columns and rows.
D)Customer information can be related to sales,departmental,and organizational information.

Question 59

Who,among the following,is responsible for overseeing the underlying IT infrastructure within an organization?

A)CTO
B)CSO
C)CIO
D)CPO

Question 60

_____ include(s)tools such as neural networks and fuzzy logic to form the basis of "information discovery."

A)Digital dashboards
B)Multidimensional analysis tools
C)Artificial intelligence
D)Query-and-reporting tools

Question 61

If the file containing your student information appears in two different places with two different birth dates,your data would not be considered ____.

A)legitimate
B)valid
C)clean
D)acceptable

Question 62

Databases and DBMSs are the technology tools that directly support OLAP.

Question 63

The DBMS engine can process virtually any logical information view or request into its physical equivalent.

Question 64

When you build a data warehouse and use data-mining tools to manipulate the data warehouse's information,you are actively engaging in analytics.

Question 65

When you create a database,you first create its data dictionary.

Question 66

QBEs rely heavily on the physical relationships within a database to find information.

Question 67

Which organizational function is responsible for the more technical and operational aspects of managing information repositories?

A)Strategic management
B)Database administration
C)Information resource planning
D)Operational planning

Question 68

Business intelligence is a component of the overall framework or field of analytics.

Question 69

A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

Question 70

A relational database model uses a series of physically related two-dimensional tables or files to store information in the form of a database.

Question 71

Which of the following is true of data administration and database administration?

A)Data administration focuses on the development of the data dictionary whereas database administration focuses on the raw data.
B)Data administration focuses on OLTP whereas database administration focuses on OLAP.
C)Data administration and database administration are terms that can be used interchangeably.
D)Data administration focuses on strategic management whereas database administration focuses on operational issues.

Question 72

The most popular database model is the hierarchical database model.

Question 73

What term is used to describe the use and distribution of information regardless of title or department?

A)Open source information
B)Info mining
C)Information sharing
D)Info distribution

Question 74

There is only one logical view of information but there may be numerous knowledge workers who have different physical views of the information in a database.

Question 75

A report generator allows you to see the contents of a database file,make whatever changes you want,perform simple sorting,and query to find the location of specific information.

Question 76

The physical view of information focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs.

Question 77

You can create logical ties among various files only in the absence of foreign keys.

Question 78

When you create a database,you must first use the data definition subsystem to create the data dictionary and define the structure of the files.

Question 79

A foreign key is also a primary key.

Question 80

If a salesperson attempts to order merchandise for a customer who should but does not exist in the customer database,the database will typically generate an error message.This message indicates that an integrity constraint has been violated.