What is usability?
The system is easy to learn and efficient and satisfying to use
What measures how quickly a system performs a process or transaction?
Performance
Within the sites that support disaster recovery, ___________ is a separate and fully equipped facility where the company can move immediately after a disaster and resume business.
Hot Site
What does reliability ensure?
The system is functioning correctly and providing accurate information
What offers a pay-per-use revenue model similar to a metered service such as gas or electricity?
Utility computing
With grid computing a problem is broken into pieces and distributed to many machines, allowing _________ processing than could occur with a single system
Faster
Within the sites that support disaster recovery, __________ is a separate facility that does not have any computer equipment but is a place where employees can move after a disaster.
Cold site
Which of the following delivers electricity using two-way digital technology?
A smart grid
Which term refers to the time frames when the system is operational?
Availability
What occurs when a primary machine recovers and resumes operations, taking over from a secondary server?
Failback
What is the ability to get a system up and running in the event of a system crash or failure that includes restoring the information backup?
Recovery
Which of the following reflects Moore's law?
The computer chip performance per dollar doubles every 18 months
To combat disasters a company can create a _________ that would detail the process for recovering information or a system in the event of a catastrophic disaster.
Disaster recovery plan
What uses resources and applications hosted remotely on the Internet?
Cloud Computing
What is the difference between hardware and software?
Hardware is the physical devices associated with a computer system, where software is the instructions the hardware executes to carry out task
What is the difference between unavailable and high availability?
unavailability is when the system is not operating and cant be used, where high availability is when a system is continuously operating at all times.
What occurs when a redundant storage server offers an exact replica of the real-time data, and if the primary server crashes, the users are automatically directed to a secondary server?
Failover
Which of the following describes the difference between a backup plan and a recovery plan?
Backup plan is an exact copy of a system's information, where recovery is the ability to get a system up and running in the event of a system crash or failure.
Which of the following is an effect a company could experience because of a disaster such as a fire, flood, or hurricane?
All above
What is a computer dedicated to providing information in response to requests?
Server
What service delivers hardware networking capabilities, including the use of servers, networking, and storage over the cloud using a pay-per-use revenue model?
Infrastructure as a Service (laaS)
What enables computers to run multiple operating systems and multiple software applications at the same time and creates multiple 'virtual' machines all on a single computing device
Virtualization
What is a foreign key?
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables.
Which of the following represent the four primary traits that help determine the value of information?
Information Type, Information timeliness, information quality, and information governance
What does extraction, transformation, and loading mean?
It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse
Which of the following is correct in reference to a database?
A database can support many logical views
Which of the following represents the different information formats?
Document, presentation, spreadsheet, database
What are the rules that help ensure the quality of information?
Integrity constraints
What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks?
Analytical information
Which of the following occurs when the same data element has different values?
Data inconsistency issue
What are rules that enforce basic and fundamental information-based constraints?
Relational integrity constraint
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
Database management system
Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?
Data integrity issue
What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks
Transactional information
What is the physical view of information?
Deals with the physical storage of information on a storage device such as a hard disk
Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the below represents the three common types of information found throughout an organization?
Levels, formats, granularities
What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?
data=driven website
What is the overall management of the availability, usability, integrity, and security of company data?
Data Governance
Which of the following would not be considered part of the timely characteristic of high-quality information?
Is the zip code missing in the address
What is it called when a manager has so much data and information that they cannot make a decision?
Data rich, information poor
What is data mining?
Process of analyzing data to extract information not offered by the raw data alone
Which of the following is the common term for the representation of multidimensional information?
Cube
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
Entity
What is data redundancy?
All of the above
What is the smallest or basic unit of information?
Data element
Which of the following describes ETL?
All above
What exists to represent the relationship between two other entities?
Composite entity
What kind of attribute would be date of birth?
Stored attribute
What is a statement that defines an aspect of a business?
Business rule
Which of the following is a possible business rule?
All above
What is a primary key?
A field that uniquely identifies a given record in a table
What kind of attribute would be age?
Derived attribute
What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?
One-To-many- relationship
What occurs when two entities can be related to each other in many instances?
Many-to-many relationship
What is a characteristic of a table?
field
What kind of attribute can be calculated using the value of another attribute?
Derived attribute
What kind of attribute would be given for a person who does not have an email address?
Null-Valued attribute
What has only a single value of each attribute of an entity?
Single-valued attribute
Which of the following is a type of attribute?
All above
What is a collection of related data elements?
record
What is a technique for documenting the entities and relationships in a database environment?
entity-relationship diagram
Which of the following statements is accurate?
all of the above
What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?
one-to-one relationship
What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?
null-valued attribute
What has the potential to contain more than one value for an attribute?
Multi-valued attribute