CSIS 100 - Module 2 Week 8 Exam
Question and answers verified to pass
ACID Properties - correct answer guarantee relational database transactions
are processed reliably and ensure the integrity of data in the database
concurrency control - correct answer A method of dealing with a situation in
which two or more users or applications need to access the same record at
the same time
Data Administrator (DA) - correct answer An individual responsible for
defining and implementing consistent principles for a variety of data issues
Data Cleansing - correct answer The process of detecting and then correcting
or deleting incomplete, incorrect, inaccurate, or irrelevant records that reside
in a database
Data Definition Language (DDL) - correct answer A collection of instructions
and commands used to define and describe data and relationships in a
specific database
Data Dictionary - correct answer A detailed description of all the data used in
the database
Data Governance - correct answer The core component of data
management; it defines the roles, responsibilities, and processes for ensuring
that data can be trusted and used by the entire organization, with people
identified and in place who are responsible for fixing and preventing issues
with data
, Data Item - correct answer The specific value of an attribute
Data Lake - correct answer A "store everything" approach to big data that
saves all the data in its raw and unaltered form
Data Lifecycle Management (DLM) - correct answer A policy-based approach
to managing the flow of an enterprise's data, from its initial acquisition or
creation and storage to the time when it becomes outdated and is deleted
Data Management - correct answer An arrangement where the database is
stored on a service provider's servers and accessed by the service subscriber
over a network, typically the Internet, with the database administration
handled by the service provider
Data Manipulation Language (DML) - correct answer A specific language,
provided with a DBMS, which allows users to access and modify the data, to
make queries, and to generate reports
Data Mart - correct answer A policy-based approach to managing the flow of
an enterprise's data, from its initial acquisition or creation and storage to the
time when it becomes outdated and is deleted
Data Steward - correct answer An individual responsible for the management
of critical data elements, including identifying and acquiring new data sources;
creating and maintaining consistent reference data and master data
definitions; and analyzing data for quality and reconciling data issues
Database Administrators - correct answer Skilled and trained IS professionals
who hold discussions with business users to define their data needs; apply
database programming languages to craft a set of databases to meet those
needs; test and evaluate databases; implement changes to improve the
Question and answers verified to pass
ACID Properties - correct answer guarantee relational database transactions
are processed reliably and ensure the integrity of data in the database
concurrency control - correct answer A method of dealing with a situation in
which two or more users or applications need to access the same record at
the same time
Data Administrator (DA) - correct answer An individual responsible for
defining and implementing consistent principles for a variety of data issues
Data Cleansing - correct answer The process of detecting and then correcting
or deleting incomplete, incorrect, inaccurate, or irrelevant records that reside
in a database
Data Definition Language (DDL) - correct answer A collection of instructions
and commands used to define and describe data and relationships in a
specific database
Data Dictionary - correct answer A detailed description of all the data used in
the database
Data Governance - correct answer The core component of data
management; it defines the roles, responsibilities, and processes for ensuring
that data can be trusted and used by the entire organization, with people
identified and in place who are responsible for fixing and preventing issues
with data
, Data Item - correct answer The specific value of an attribute
Data Lake - correct answer A "store everything" approach to big data that
saves all the data in its raw and unaltered form
Data Lifecycle Management (DLM) - correct answer A policy-based approach
to managing the flow of an enterprise's data, from its initial acquisition or
creation and storage to the time when it becomes outdated and is deleted
Data Management - correct answer An arrangement where the database is
stored on a service provider's servers and accessed by the service subscriber
over a network, typically the Internet, with the database administration
handled by the service provider
Data Manipulation Language (DML) - correct answer A specific language,
provided with a DBMS, which allows users to access and modify the data, to
make queries, and to generate reports
Data Mart - correct answer A policy-based approach to managing the flow of
an enterprise's data, from its initial acquisition or creation and storage to the
time when it becomes outdated and is deleted
Data Steward - correct answer An individual responsible for the management
of critical data elements, including identifying and acquiring new data sources;
creating and maintaining consistent reference data and master data
definitions; and analyzing data for quality and reconciling data issues
Database Administrators - correct answer Skilled and trained IS professionals
who hold discussions with business users to define their data needs; apply
database programming languages to craft a set of databases to meet those
needs; test and evaluate databases; implement changes to improve the
