Deck 3: Data and Business Intelligence

Question 1

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Answer 1

True

Question 2

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Answer 2

False

Question 3

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

Answer 3

True

Question 4

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Question 5

Apache Hadoop is the most commonly used platform for big data analytics.

Question 6

Tableau can utilize data from various sources including data files, relational databases, and big data sources.

Question 7

Static Web sites are useful for e-commerce sites that need frequent updates.

Question 8

Business intelligence (BI)uses scorecards and dashboards to support decision-making activities, whereas business analytics (BA)uses data mining tools and predictive modeling.

Question 9

The earliest users of automated marketing tools included credit bureaus and mail-order catalog companies.

Question 10

With the indexed sequential access method (ISAM), records cannot be accessed randomly.

Question 11

Database marketing works by using multivariate analysis, data segmentation, and automated tools to transform marketing from a proactive to a reactive process.

Question 12

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

Question 13

Labor and population statistics are examples of sources for internal data that are accessed by a database.

Question 14

A disadvantage of Power BI is that it only accepts data from a single source.

Question 15

Although a database can consist of only a single file, it is usually a group of files.

Question 16

The use of the OR operator in a query form, when using query by example (QBE), means that all conditions must be met.

Question 17

Conventional computing methods are able to efficiently process and manage big data.

Question 18

Data in a database is used for analytical purposes, whereas data in a data warehouse is used for capturing and managing transactions.

Question 19

Disks are sequential access devices, whereas tapes are random access devices.

Question 20

A network model is similar to a hierarchical data model because in both data models records are organized in the same way.

Question 21

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

A)sequential access file structure
B)random access file structure
C)indexed sequential access
D)physical view access

Question 22

For each database, there:

A)is only one physical view of data.
B)are only two logical views of data.
C)are multiple physical views of data.
D)is only one logical view of data.

Question 23

In the context of the types of data in a database, which is a source of internal data?

A)Tax records
B)Sales records
C)Distribution networks
D)Economic indicators

Question 24

In the context of business analytics, prescriptive analytics recommends a precise course of action that a decision maker should follow and shows the likely outcome of each decision.

Question 25

In comparison with flat file systems, databases:

A)minimize data redundancy.
B)are easier to design.
C)have less sophisticated security measures.
D)require more storage space.

Question 26

In comparison with a flat file system, _____ in a database.

A)storage space is reduced
B)programs and data are interdependent
C)complex requests cannot be handled easily
D)data redundancy is introduced

Question 27

_____ is a component of a data model that defines the boundaries of a database, such as maximum and minimum values allowed for a field, constraints, and access methods.

A)Data structure
B)Schema diagrams
C)Integrity rules
D)File procedure

Question 28

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

A)data warehouse
B)data mart
C)data dictionary
D)data model

Question 29

In the context of data models, relationships among records in a hierarchical model are called _____.

A)nodes
B)branches
C)roots
D)segments

Question 30

Which file structure is similar to a book index that lists page numbers where certain topics can be found?

A)The indexed sequential access method
B)The indexed network access structure
C)The indexed random access file structure
D)The indexed hierarchical access method

Question 31

A data mart is designed for an entire organization's use.

Question 32

Which component of a data model describes methods and calculations that can be performed on data, such as updating and querying data?

A)Data structure
B)Operations
C)Integrity rules
D)File structure

Question 33

In the context of business analytics, mobile analytics is declining in popularity.

Question 34

Which statement is true of a flat file system?

A)Same data can be stored in more than one file.
B)Programs and data are independent.
C)Complex requests can be handled easily.
D)It requires very less storage space.

Question 35

In a(n)_____, nodes with the same parents are called twins or siblings.

A)hierarchical model
B)network model
C)relational model
D)object-based model

Question 36

In the context of how information is viewed in a database, the _____ involves how data is stored on and retrieved from storage media.

A)physical view
B)logical view
C)rational view
D)analytical view

Question 37

In the context of the types of data in a database, which is a source of external data?

A)Tax records
B)Sales records
C)Transaction records
D)Personnel records

Question 38

There are, to date, many legal requirements for protecting privacy while using big data analytics.

Question 39

Data marts usually have more limited scope than data warehouses, and consolidating information from different departments is more difficult.

Question 40

Data markets focus on business functions for the marketing department of an organization.

Question 41

In a relational database model, the columns are called _____.

A)attributes
B)tuples
C)branches
D)roots

Question 42

In the context of the operators used in a query by example (QBE)form, the _____ is used when only one of the conditions in the QBE form must be met.

A)NOT operator
B)AND operator
C)OR operator
D)NOR operator

Question 43

A data _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

A)dictionary
B)pattern
C)mine
D)warehouse

Question 44

In a(n)_____, each record can have multiple parent and child records.

A)network model
B)hierarchical model
C)object-oriented model
D)relational model

Question 45

The data _____ component of a database management system (DBMS)is used for tasks such as backup and recovery, security, and change management.

A)manipulation
B)generation
C)definition
D)administration

Question 46

When using query by example (QBE)in the data manipulation component of a database management system (DBMS), the _____ is used when all the conditions in the QBE form must be met.

A)NOT operator
B)AND operator
C)OR operator
D)NOR operator

Question 47

In a relational database model, the rows are called _____.

A)tuples
B)attributes
C)branches
D)roots

Question 48

To begin designing a relational database, you must define the _____ by defining each table and the fields in it.

A)physical structure
B)logical structure
C)primary key
D)foreign key

Question 49

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

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

Question 50

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

A)data-driven Web site
B)flat Web page
C)stationary Web page
D)static Web site

Question 51

Which component of a database management system (DBMS)is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

A)application generation
B)application definition
C)application administration
D)application manipulation

Question 52

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

A)secondary key
B)foreign key
C)serial key
D)domain key

Question 53

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

A)create, read, update, and delete
B)copy, revise, undo, and define
C)create, repeat, undo, and develop
D)copy, read, update, and define

Question 54

Which type of databases is not limited by the data's physical location?

A)distributed
B)relational
C)multi-structured
D)semi-structured

Question 55

In a relational database model, which operation searches data in a table and retrieves records based on certain criteria?

A)insert operation
B)join operation
C)find operation
D)select operation

Question 56

The data _____ component of a database management system (DBMS)is used to add, delete, modify, and retrieve records from a database.

A)manipulation
B)generation
C)definition
D)administration

Question 57

In a relational database model, which operation pares down a table by eliminating columns according to certain criteria?

A)project operation
B)join operation
C)find operation
D)insert operation

Question 58

Which approach to set up a distributed database management system (DDBMS)combines the fragmentation approach and the replication approach?

A)optimization
B)allocation
C)encapsulation
D)normalization

Question 59

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

A)Triangulation
B)Fragmentation
C)Normalization
D)Encapsulation

Question 60

The data _____ component of a database management system (DBMS)is used to create and maintain the data dictionary.

A)manipulation
B)generation
C)definition
D)administration

Question 61

Data warehouses are sometimes called hypercubes because they _____.

A)are function oriented
B)store multidimensional data
C)capture raw transaction data
D)manage transactions

Question 62

Which statement is true of database marketing?

A)It works by using univariate analysis to transform marketing from a proactive to a reactive process.
B)It works by utilizing information that can be found outside the organizational database.
C)It makes an organization responsive to the needs of its customers.
D)It allows an organization to resist changes in the marketplace.

Question 63

The variety dimension of big data refers to the combination of _____.

A)data warehouses and data marts
B)object-oriented data models and relational data models
C)structured data and unstructured data
D)data definition and data manipulation

Question 64

A data _____  is the structure and organization of data, which involves fields, records, and files.

A)mine
B)mart
C)warehouse
D)hierarchy

Question 65

In contrast to data in a database, data in a data warehouse is described as subject oriented, which means that it _____.

A)captures aggregated data
B)manages data transactions
C)focuses on a specific area
D)categorizes based on time

Question 66

Which statement is true of big data?

A)It eliminates unethical actions based on interpretations.
B)It can be efficiently processed and managed by conventional computing methods.
C)It has three dimensions, which are value, density, and uniformity.
D)It is the result of the exponential growth of data in both public and private organizations.

Question 67

In a(n)_____ , records in files are organized and processed in numerical order.

A)sequential access file structure
B)random access file structure
C)indexed access file structure
D)direct access file structure

Question 68

In a(n)_____  access file structure , records can be accessed in any order, regardless of their physical locations in storage media.

A)sequential
B)random
C)indexed
D)direct

Question 69

In the context of database marketing, when a buyer is segmented on the basis of variable psychographics, it explains _____.

A)why the buyer buys a product or service
B)who the buyer is
C)how the buyer buys a product or service
D)where the buyer is

Question 70

A data _____ is usually a smaller version of a data warehouse, used by a single department or function.

A)domain
B)mine
C)dictionary
D)mart

Question 71

Unlike data in databases, data in data warehouses is:

A)function oriented.
B)raw transaction data.
C)collected from a single source.
D)used for analytical purposes.

Question 72

The _____ dimension of big data refers to the sheer quantity of transactions, measured in petabytes or exabytes.

A)velocity
B)volume
C)area
D)time

Question 73

Which is a key factor that has contributed to the growth and popularity of big data?

A)Implosion in data growth
B)Brick and mortar businesses
C)Mobile and wireless technology
D)Exponential decay of organizational data

Question 74

In data warehouses, _____ is information about data-its content, quality, condition, origin, and other characteristics.

A)metadata
B)big data
C)summary data
D)raw data

Question 75

Which statement is true of data marts and data warehouses?

A)Consolidating information from different departments is easier in data marts than in data warehouses.
B)Data marts have more extended scope than data warehouses.
C)Access to data is often slower in data marts than in data warehouses.
D)Data marts usually perform the same types of analysis as data warehouses.

Question 76

In a data warehouse, _____ is the process of collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

A)extraction
B)transformation
C)optimization
D)aggregation

Question 77

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

A)Database mining
B)Database marketing
C)Data encapsulation
D)Data normalization

Question 78

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

A)predictive modeling
B)dashboards
C)query reports
D)application generators

Question 79

In the context of the input component of a data warehouse, _____ collect, integrate, and process data that can be used by all functional areas in an organization.

A)online analytical processing systems
B)online transaction management systems
C)enterprise resource planning systems
D)data mining analysis systems

Question 80

A _____  is software for creating, storing, maintaining, and accessing database files.

A)database management system
B)data hierarchical system
C)database modelling tool
D)data warehousing tool