MSIS Exam 2 || A+ Guaranteed Solutions.
An organization may require high-quality data to avoid fines and penalties for non-conformance
to regulatory requirements. True or False? correct answers true
Input/output devices provide data and instructions to the computer and receive results from it.
correct answers true
A collection of attributes about a specific entity is a correct answers Record
A(n)_____ is a person, place, or thing (object) for which data is collected, stored, and
maintained. correct answers entity
A _______________ is a collection of similar entities while a(n) _______________ is a
characteristic of an entity. correct answers File, Attribute
Which of the following is not a function of the database management system _______________?
correct answers database data normalization and data cleansing
A database and a database management system are the same thing. True or False? correct
answers False
A collection of instructions and commands to define and describe data and relationship in a
specific database is a correct answers data definition language
The process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, or
irrelevant records that reside in a database is called _______________. correct answers data
cleansing
In the design of a database, it is not necessary to know how long the data must be stored. True or
False? correct answers False
The use of primary keys and foreign keys make it impossible to define relationships between the
data in two tables of a relational database. True or False? correct answers False
The purpose of data normalization is to _______________. correct answers eliminate data
redundancies and ensure data dependencies make sense
__________ properties of SQL databases help ensure the integrity of data in the database. correct
answers ACID
Which of the following is not an advantage associated with database-as-a-service (DaaS)?
correct answers The customer has complete responsibility for database security access and
database backup.
Data governance is a subset of data management. True or False? correct answers False
, One of the driving reasons behind the need for data management is to manage risk associated
with the misstatement of financial data. True or False? correct answers True
The individual who is responsible for planning, designing, creating, operating, securing,
monitoring, and maintaining databases is the correct answers database administrator
Which of the following is not a key responsibility of the data governance team? correct answers
decide which database technology should be used
is a measure of the quality of big data. correct answers Veracity
The fact that big data comes in many formats and may be structured or unstructured is an
indicator of its correct answers Variety
Choosing what data to store and where and how to store the data are two key challenges
associated with big data. True or False? correct answers true
______________ is not a key challenge associated with big data. correct answers Which format
the data should be stored in
A _______________ is a large database that holds business information from many sources in
the enterprise, covering all aspects of the company's processes, products, and customers. correct
answers data warehouse
The goal of the _______step of the ETL process is to take the source data from all the various
sources and convert it into a single format suitable for processing. correct answers extract
A _______________ database enables hundreds or even thousands of servers to operate on the
data, providing faster response times for queries and updates. correct answers NoSQL
A _______________ differs from a _______________ in that it provides a means to store and
retrieve data that is modelled using some means other than the simple two-dimensional tabular
relations. correct answers NoSQL database and relational database
The _______________ component of the Hadoop environment is composed of a Procedure that
performs filtering and sorting and a method that performs a summary operation. correct answers
Map/Reduce program
The primary advantage associated with the use of an in-memory database to process big data is
that _______________. correct answers it provides access to data at rates much faster than
storing data on some form of secondary storage
There are many business intelligence (BI) and analytics techniques that can be used to support
improved decision making. correct answers BI is used to analyze historical data to tell what
An organization may require high-quality data to avoid fines and penalties for non-conformance
to regulatory requirements. True or False? correct answers true
Input/output devices provide data and instructions to the computer and receive results from it.
correct answers true
A collection of attributes about a specific entity is a correct answers Record
A(n)_____ is a person, place, or thing (object) for which data is collected, stored, and
maintained. correct answers entity
A _______________ is a collection of similar entities while a(n) _______________ is a
characteristic of an entity. correct answers File, Attribute
Which of the following is not a function of the database management system _______________?
correct answers database data normalization and data cleansing
A database and a database management system are the same thing. True or False? correct
answers False
A collection of instructions and commands to define and describe data and relationship in a
specific database is a correct answers data definition language
The process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, or
irrelevant records that reside in a database is called _______________. correct answers data
cleansing
In the design of a database, it is not necessary to know how long the data must be stored. True or
False? correct answers False
The use of primary keys and foreign keys make it impossible to define relationships between the
data in two tables of a relational database. True or False? correct answers False
The purpose of data normalization is to _______________. correct answers eliminate data
redundancies and ensure data dependencies make sense
__________ properties of SQL databases help ensure the integrity of data in the database. correct
answers ACID
Which of the following is not an advantage associated with database-as-a-service (DaaS)?
correct answers The customer has complete responsibility for database security access and
database backup.
Data governance is a subset of data management. True or False? correct answers False
, One of the driving reasons behind the need for data management is to manage risk associated
with the misstatement of financial data. True or False? correct answers True
The individual who is responsible for planning, designing, creating, operating, securing,
monitoring, and maintaining databases is the correct answers database administrator
Which of the following is not a key responsibility of the data governance team? correct answers
decide which database technology should be used
is a measure of the quality of big data. correct answers Veracity
The fact that big data comes in many formats and may be structured or unstructured is an
indicator of its correct answers Variety
Choosing what data to store and where and how to store the data are two key challenges
associated with big data. True or False? correct answers true
______________ is not a key challenge associated with big data. correct answers Which format
the data should be stored in
A _______________ is a large database that holds business information from many sources in
the enterprise, covering all aspects of the company's processes, products, and customers. correct
answers data warehouse
The goal of the _______step of the ETL process is to take the source data from all the various
sources and convert it into a single format suitable for processing. correct answers extract
A _______________ database enables hundreds or even thousands of servers to operate on the
data, providing faster response times for queries and updates. correct answers NoSQL
A _______________ differs from a _______________ in that it provides a means to store and
retrieve data that is modelled using some means other than the simple two-dimensional tabular
relations. correct answers NoSQL database and relational database
The _______________ component of the Hadoop environment is composed of a Procedure that
performs filtering and sorting and a method that performs a summary operation. correct answers
Map/Reduce program
The primary advantage associated with the use of an in-memory database to process big data is
that _______________. correct answers it provides access to data at rates much faster than
storing data on some form of secondary storage
There are many business intelligence (BI) and analytics techniques that can be used to support
improved decision making. correct answers BI is used to analyze historical data to tell what
