Question 1

Meghan signs into Zoom to attend a video call for her online class.What kind of cloud service is she using?

Accepted Answer

This is a Software as a Service (SaaS) since Meghan is using a cloud-based software application (Zoom) to attend her online class.

Question 2

Some nonrelational databases support SQL-based languages.

Accepted Answer

Some nonrelational databases, such as Apache Cassandra and Couchbase, support SQL-based languages for querying and manipulating data.

Question 3

Which of the following job roles would most likely need permission to delete records in a Customers table?

Accepted Answer

The database administrator is responsible for managing the database, including setting permissions for users. They would likely have the ability to delete records in a Customers table if necessary. The other job roles listed do not typically require this level of access to the database.

Question 4

Which type of data storage allows for the most variety of data types?

Accepted Answer

Data lakes are designed to store unstructured and semistructured data and can handle a huge variety of data types such as images, video, sensor data, social media data, and more. They are highly scalable and can easily accommodate data of different sizes and formats, making them the best choice for storing a variety of data types.

Question 5

Randall needs to monitor rapidly changing statistics for a social media campaign for his company.Which of the following should he use to access this information?

Accepted Answer

A dashboard is a graphical user interface that displays real-time data in a visual format, making it the best choice for monitoring rapidly changing statistics for a social media campaign. A DBMS is a software system for managing databases, a data lake is a storage repository that holds a vast amount of raw data in its native format, and a data warehouse is a large repository of historical data that's used for analysis and business intelligence. While these options may be useful in other contexts, they are not the optimal choice for monitoring rapidly changing social media statistics.

Question 6

Which cloud technology characteristic ensures that a cloud customer can make changes to her cloud database from her smartphone while traveling for a conference and from her laptop when she's at home?

Accepted Answer

Broad network access allows the cloud customer to access their cloud resources from anywhere with an internet connection, using any device with appropriate access credentials.

Question 7

Terrance needs to set up a Windows server in his company's public cloud.What kind of cloud service will work best for this situation?

Accepted Answer

IaaS (Infrastructure as a Service) provides Terrance with the necessary infrastructure for setting up his Windows server in the public cloud. With IaaS, he can choose the operating system, install software, and manage network and storage settings. This gives him complete control over the server and its configuration, making IaaS the best option for this situation. SaaS (Software as a Service), DBaaS (Database as a Service), and PaaS (Platform as a Service) do not provide the necessary level of control and flexibility required for setting up a Windows server.

Question 8

Which of the following tables in a database would NOT need to be encrypted?

Accepted Answer

Store_Locations table does not contain sensitive or private information that needs to be protected, hence it does not require encryption. On the other hand, Patient_Records, Customer_Payments, and Employee_Passwords all contain sensitive and private information that should be encrypted to prevent unauthorized access.

Question 9

Malisa is designing a database for a doctor's office where receptionists, office managers, and other office staff will need to manage patient data.Which database object should Malisa create to make it easy for these non-technical users to add patient records?

Accepted Answer

Forms offer an easy-to-use graphical user interface for data entry and can be customized to fit the specific needs of the user. It allows non-technical users to add and update patient records in the database. Queries are used to extract specific information from the database, Tables store the actual data, and Reports are used to present data in an organized manner.

Question 10

The volume of Big Data generated over time is typically measured in terms of ____________.

Accepted Answer

The volume of Big Data is typically measured in terms of terabytes, as it refers to a massive amount of data that exceeds the processing capacity of traditional databases and computing systems. Kilobytes and characters are too small to gauge the magnitude of Big Data, while records are a measure of the number of data items or entries, not the volume of data itself.

Question 11

Kim is writing a SQL query that will pull a list of customers with outstanding orders and the sales rep for each order.What should the WHERE phrase say in her query?

Accepted Answer

The WHERE phrase should specify the condition that filters for outstanding orders. OrderStatus = Pending would indicate that the order has not been fulfilled yet. The other options do not address outstanding orders.

Question 12

A national bank processes approximately 1,500 transactions per second.The fact that the bank's database must add this many Big Data records every second refers to its high _________.

Accepted Answer

Velocity refers to the speed at which data is being generated and processed, which is the case for the national bank processing 1,500 transactions per second. The other options (value, variety, and veracity) do not accurately describe the situation.

Question 13

Which of the following is NOT a leading provider of PaaS and IaaS services?

Accepted Answer

Walmart is not a leading provider of PaaS and IaaS services. Google, Microsoft, and Amazon are all top players in this field.

Question 14

Jake is a sales rep for a trucking company and travels throughout the Midwest.He uses a cloud-based _________ service so he can access updated information about his customers' sales transactions from his laptop as he travels.

Accepted Answer

Jake is using a cloud-based CRM (Customer Relationship Management) service to access updated information about his customers' sales transactions while travelling. A CRM is a software that helps businesses manage their interactions with customers and maintain customer relationships by keeping track of customer details and communication history. It allows sales reps like Jake to access customer information anytime, anywhere from a central location, in this case, the cloud-based CRM service.

Question 15

Which of the following would most likely be a key in a key-value database of investment properties owned by a company?

Accepted Answer

"ZoneType" would be the most relevant and useful key value in a database for investment properties as it categorizes the properties based on their rehabilitation and construction requirements, potential profit margins, etc. The other answer choices are not as relevant or specific for investment properties.

Question 16

During a thunderstorm, the database server for Jason's store loses power.This is an example of failed _________.

Accepted Answer

The loss of power to the database server means that the server is no longer available, making this an example of failed availability. Integrity refers to the accuracy and consistency of data, encryption refers to the process of converting data into a code to protect its confidentiality, and confidentiality refers to keeping data private and secure from unauthorized access.

Question 17

All cloud technologies must be accessed over the Internet.

Accepted Answer

Cloud technologies can also be accessed through private networks, not just over the Internet. This is common in private or hybrid cloud setups where security and control over data are paramount.

Question 18

Rafael needs to run a query that will show the name and city of all his clients.Which of the following phrases will determine which fields are returned in the query?

Accepted Answer

The SELECT statement is used to choose which fields to return in a query, so option B is the correct answer. The other options are not appropriate for this purpose.

Question 19

Which of the following is NOT a risk to a company or its employees as a result of a data breach?

Accepted Answer

Increased database efficiency is not a risk associated with a data breach. A data breach can result in loss of trust with customers, negative media exposure, and in some cases, legal consequences such as jailtime.

Question 20

Hackers pose the only real risk to database security.

Accepted Answer

While hackers are a significant risk to database security, they are not the only risk. Other potential risks include insider threats, human error, and inadequate security measures or protocols.

Quiz 9: Technology and Digital Ethics