Exam (elaborations)
BCIS EXAM 2 - CHAPTERS 5-9 QUIZZES WITH COMPLETE SOLUTION!!
- Course
- Institution
BCIS EXAM 2 - CHAPTERS 5-9 QUIZZES WITH COMPLETE SOLUTION!!
[Show more]
Content preview
BCIS EXAM 2 - CHAPTERS 5-9 QUIZZES WITH COMPLETESOLUTION!!
Between 2017 and 2025, _____.
Answers :the volume of data in the digital universe is expected to grow tenfold
For each data item, a data dictionary usually contains information such as the name
of the data item, the range of values that can be used, and the amount of storage
needed for the item.
Answers :true
Mark creates a new relational database table that includes only five of the seven
columns in the existing products table. This action is known as ____.
Answers :projecting
What core component of an integrated set of functions defining data processing
defines the roles, responsibilities, and processes for ensuring that data can be
trusted and used by the entire organization?
Answers :data governance
A(n) [Blank] is a characteristic or set of characteristics in a record that uniquely
identifies the record.
Answers :primary key
Data quality management, data architecture management, and data development
are three of the many functions of _____.
Answers :data management
Penelope decides to enroll in Amazon Relational Database Service (Amazon RDS),
which allows her to set up and operate her choice of a MySQL, Microsoft SQL,
,Oracle, or PostgreSQL database in the cloud. What kind of service is Amazon
RDS?
Answers :database as a service
A DaaS arrangement can be especially cost effective for businesses that _____.
Answers :have fluctuating needs for database storage capacity
Carlos is working with an existing database, but he wants to eliminate some of the
columns in the table to create a new, more streamlined database. He will use
projection to create his new database.
Answers :true
Effective data governance _____.
Answers :requires the active participation of a cross-functional, multilevel team
Sometimes a database can contain "bad data," meaning incomplete, incorrect,
inaccurate, or irrelevant records, which can be corrected or deleted through data
cleansing.
Answers :true
One factor driving the need for data management is the need to meet external
regulations designed to _____.
Answers :manage risk associated with the misstatement of financial data
Which statement about maintaining accurate and complete data is true?
Answers :Data cleansing may involve standardizing data.
,A consultant hired to evaluate Blue Street Bank's business processes and controls
judges that they are haphazard and incomplete. Bess, an executive at the bank,
wisely says that _____.
Answers :they must establish more rigorous management practices to govern their
data
A key purpose of data normalization is to eliminate _____.
Answers :data redundancy
Data normalization _____.
Answers :eliminates redundancy and ensures data dependencies are sensible
Which process consists of one application program following a logical access path
(LAP) and then a DBMS following a physical access path (PAP)?
Answers :data retrieval
You would use Query by Example if _____.
Answers :you wish to use a visual approach to query building
After Lindy's team improves their department's data management by implementing
rigorous data management processes, _____.
Answers :the quality of their data improves as well
Raw facts such as a social security number or catalog item number for a shirt are
known as _____.
Answers :data
, Today, due to security concerns, most organizations avoid the database approach to
data management, where multiple information systems share a pool of related data.
Answers :false
Kyle works for National Sporting Goods, where he manages critical data elements,
such as identifying and acquiring new data sources, creating consistent reference
data, and analyzing data for quality. Kyle is a _______.
Answers :data steward
Brenda uses a SQL database that conforms to ACID properties at her job. She is
happy to know that this guarantees _____.
Answers :data integrity
Julie is a non-IS employee who is responsible for, among other tasks, creating and
maintaining consistent reference data and master data definitions and for analyzing
data for quality. Coworkers consult with Julie to find out what data to use to
answer a business question. Julie is a _____.
Answers :data steward
The relational model describes data using a standard tabular format; all data
elements are placed in three-dimensional tables called relations, which are the
logical equivalent of files.
Answers :false
If "color" is an attribute, then "green" is a data item.
Answers :true
Allie has noticed that people at her company spend a lot of time researching the
reasons for and correcting errors in the data they must use for their job functions.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller IANWAZASKISTUVIA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79202 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now