Basics of Databases Module
Started: 02/15/2015 5:40 PM EST
Submitted: 02/15/2015 5:57 PM EST
Score: 95%
Points: 180 out of 190
Question 1
Points: 10 out of 10
If you need to determine impacts on revenue resulting from an increase or
decrease in prices and/or sales, the best option to use is a .
spreadsheet
Feedback
Correct. The spreadsheet is an ideal place to do a “what if” analysis to
analyze potential price changes, or to perform a trend analysis of sales
amounts, generating charts and graphs from the data.
Question 2
Points: 10 out of 10
Which of the following issues would appear to have the greatest potential
for losing current customers?
Direct advertising of additional related items the
customer might like, based on past purchasing history
Lack of loyalty rewards or points that can be used in
the future
, Contacting a service representative who does not have
access to information in all pertinent departments
Mishandling issues and complaints (customer
dissatisfaction)
Feedback
Correct. The ability to deal with issues quickly and fairly makes a real
difference to customers’ perceptions of the company.
Question 3
Points: 10 out of 10
True or false? Demographic data is the collection of data related to
customer age, gender, location, income level, and so on.
True
False
Feedback
Correct. This type of data is often used to identify potential customers.
Question 4
Points: 10 out of 10
Paul has been working long hours. He is tired and distracted by family
issues, so he has not been doing record updates regularly. There is a sudden
power outage in the building and the last 15 records he has been working
,on have not been saved to the database. Which of the following best
describes this data issue?
Accidental data loss
Accidental data leak
Malicious data loss
Malicious data leak
Feedback
Correct. The power outage is the reason for the lost data. Although Paul
was negligent by not executing timely updates, he did not deliberately
cause the data to be lost.
Question 5
Points: 10 out of 10
Alejandra is using a flash drive that a friend gave to her to copy some
financial records from the company database so she can complete a
department presentation at home. She does not realize that the flash drive
is infected with a virus that enables a malicious hacker to take control of
her computer. This is a potential to the confidentiality of the
threat
data in the files.
Feedback
, Correct. This is an example of an accidental breach resulting from incorrect
(but not malicious) usage. The threat comes not from data being accessed
via the company’s network, but from making the data visible via the attack
on the computer to which the flash drive has been attached.
Question 6
Points: 10 out of 10
Which is the largest component found inside a field?
Bits
Characters
Records
Tables
Feedback
Correct. Fields are composed of a collection of one or more characters.
Question 7
Points: 10 out of 10
What is the software called that allows the user to create, access, and
manage a database?
DLP
Started: 02/15/2015 5:40 PM EST
Submitted: 02/15/2015 5:57 PM EST
Score: 95%
Points: 180 out of 190
Question 1
Points: 10 out of 10
If you need to determine impacts on revenue resulting from an increase or
decrease in prices and/or sales, the best option to use is a .
spreadsheet
Feedback
Correct. The spreadsheet is an ideal place to do a “what if” analysis to
analyze potential price changes, or to perform a trend analysis of sales
amounts, generating charts and graphs from the data.
Question 2
Points: 10 out of 10
Which of the following issues would appear to have the greatest potential
for losing current customers?
Direct advertising of additional related items the
customer might like, based on past purchasing history
Lack of loyalty rewards or points that can be used in
the future
, Contacting a service representative who does not have
access to information in all pertinent departments
Mishandling issues and complaints (customer
dissatisfaction)
Feedback
Correct. The ability to deal with issues quickly and fairly makes a real
difference to customers’ perceptions of the company.
Question 3
Points: 10 out of 10
True or false? Demographic data is the collection of data related to
customer age, gender, location, income level, and so on.
True
False
Feedback
Correct. This type of data is often used to identify potential customers.
Question 4
Points: 10 out of 10
Paul has been working long hours. He is tired and distracted by family
issues, so he has not been doing record updates regularly. There is a sudden
power outage in the building and the last 15 records he has been working
,on have not been saved to the database. Which of the following best
describes this data issue?
Accidental data loss
Accidental data leak
Malicious data loss
Malicious data leak
Feedback
Correct. The power outage is the reason for the lost data. Although Paul
was negligent by not executing timely updates, he did not deliberately
cause the data to be lost.
Question 5
Points: 10 out of 10
Alejandra is using a flash drive that a friend gave to her to copy some
financial records from the company database so she can complete a
department presentation at home. She does not realize that the flash drive
is infected with a virus that enables a malicious hacker to take control of
her computer. This is a potential to the confidentiality of the
threat
data in the files.
Feedback
, Correct. This is an example of an accidental breach resulting from incorrect
(but not malicious) usage. The threat comes not from data being accessed
via the company’s network, but from making the data visible via the attack
on the computer to which the flash drive has been attached.
Question 6
Points: 10 out of 10
Which is the largest component found inside a field?
Bits
Characters
Records
Tables
Feedback
Correct. Fields are composed of a collection of one or more characters.
Question 7
Points: 10 out of 10
What is the software called that allows the user to create, access, and
manage a database?
DLP
