BCIS Exam 3 Notes – Flashcards
Unlock all answers in this set
Unlock answersquestion
What is usability?
answer
The system is easy to learn and efficient and satisfying to use
question
What measures how quickly a system performs a process or transaction?
answer
Performance
question
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.
answer
Hot Site
question
What does reliability ensure?
answer
The system is functioning correctly and providing accurate information
question
What offers a pay-per-use revenue model similar to a metered service such as gas or electricity?
answer
Utility computing
question
With grid computing a problem is broken into pieces and distributed to many machines, allowing _________ processing than could occur with a single system
answer
Faster
question
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.
answer
Cold site
question
Which of the following delivers electricity using two-way digital technology?
answer
A smart grid
question
Which term refers to the time frames when the system is operational?
answer
Availability
question
What occurs when a primary machine recovers and resumes operations, taking over from a secondary server?
answer
Failback
question
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?
answer
Recovery
question
Which of the following reflects Moore's law?
answer
The computer chip performance per dollar doubles every 18 months
question
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.
answer
Disaster recovery plan
question
What uses resources and applications hosted remotely on the Internet?
answer
Cloud Computing
question
What is the difference between hardware and software?
answer
Hardware is the physical devices associated with a computer system, where software is the instructions the hardware executes to carry out task
question
What is the difference between unavailable and high availability?
answer
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.
question
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?
answer
Failover
question
Which of the following describes the difference between a backup plan and a recovery plan?
answer
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.
question
Which of the following is an effect a company could experience because of a disaster such as a fire, flood, or hurricane?
answer
All above
question
What is a computer dedicated to providing information in response to requests?
answer
Server
question
What service delivers hardware networking capabilities, including the use of servers, networking, and storage over the cloud using a pay-per-use revenue model?
answer
Infrastructure as a Service (laaS)
question
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
answer
Virtualization
question
What is a foreign key?
answer
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.
question
Which of the following represent the four primary traits that help determine the value of information?
answer
Information Type, Information timeliness, information quality, and information governance
question
What does extraction, transformation, and loading mean?
answer
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
question
Which of the following is correct in reference to a database?
answer
A database can support many logical views
question
Which of the following represents the different information formats?
answer
Document, presentation, spreadsheet, database
question
What are the rules that help ensure the quality of information?
answer
Integrity constraints
question
What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks?
answer
Analytical information
question
Which of the following occurs when the same data element has different values?
answer
Data inconsistency issue
question
What are rules that enforce basic and fundamental information-based constraints?
answer
Relational integrity constraint
question
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
answer
Database management system
question
Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?
answer
Data integrity issue
question
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
answer
Transactional information
question
What is the physical view of information?
answer
Deals with the physical storage of information on a storage device such as a hard disk
question
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?
answer
Levels, formats, granularities
question
What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?
answer
data=driven website
question
What is the overall management of the availability, usability, integrity, and security of company data?
answer
Data Governance
question
Which of the following would not be considered part of the timely characteristic of high-quality information?
answer
Is the zip code missing in the address
question
What is it called when a manager has so much data and information that they cannot make a decision?
answer
Data rich, information poor
question
What is data mining?
answer
Process of analyzing data to extract information not offered by the raw data alone
question
Which of the following is the common term for the representation of multidimensional information?
answer
Cube
question
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
answer
Entity
question
What is data redundancy?
answer
All of the above
question
What is the smallest or basic unit of information?
answer
Data element
question
Which of the following describes ETL?
answer
All above
question
What exists to represent the relationship between two other entities?
answer
Composite entity
question
What kind of attribute would be date of birth?
answer
Stored attribute
question
What is a statement that defines an aspect of a business?
answer
Business rule
question
Which of the following is a possible business rule?
answer
All above
question
What is a primary key?
answer
A field that uniquely identifies a given record in a table
question
What kind of attribute would be age?
answer
Derived attribute
question
What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?
answer
One-To-many- relationship
question
What occurs when two entities can be related to each other in many instances?
answer
Many-to-many relationship
question
What is a characteristic of a table?
answer
field
question
What kind of attribute can be calculated using the value of another attribute?
answer
Derived attribute
question
What kind of attribute would be given for a person who does not have an email address?
answer
Null-Valued attribute
question
What has only a single value of each attribute of an entity?
answer
Single-valued attribute
question
Which of the following is a type of attribute?
answer
All above
question
What is a collection of related data elements?
answer
record
question
What is a technique for documenting the entities and relationships in a database environment?
answer
entity-relationship diagram
question
Which of the following statements is accurate?
answer
all of the above
question
What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?
answer
one-to-one relationship
question
What kind of attribute is assigned to an attribute when no other value applies or when a value is unknown?
answer
null-valued attribute
question
What has the potential to contain more than one value for an attribute?
answer
Multi-valued attribute
