Module 12: Databases Quiz

Contact information for all the people taking a class at a school are stored in a ________ called Students.

A table, is a collection of records for a single subject, such as students at a school.

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

terabytes

What characteristic of Big Data indicates how closely that data matches reality?

veracity, refers to how accurately data reflects reality. For example, a lot of negative reviews for a product could reflect that product's poor quality, or it could be the result of dishonest posts made by a competitor. When using Big Data, its veracity must be examined.

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

A data lake, is a collection of both structured and unstructured data, allowing for more diverse data formats such as video streams or IoT sensor data.

Which data repository type is most likely to include database tables and primary keys in its internal data structure?

A data warehouse, is a type of database, and most use tables, indexes, keys, and SQL queries.

Darcie has hired a programmer to make some custom changes to a DBMS she plans to move her business database to. What kind of DBMS is she using?

An open source

Which of the following would most likely be the key paired with a value of "Canada" in a nonrelational customer database?

Country

Which of the following fields would be most important to encrypt in a customer table?

Customer's credit card number

Melody is building a database for a restaurant. Which pair of tables is least likely to need a direct relationship with each other?

Customers, Ingredients

Morgan needs to hire someone to help implement a business intelligence system for her company. What type of professional would be the best fit for this job?

Data analyst, is used to detect patterns that improve business processes and answer questions related to strategic planning and business intelligence. A data analyst specializes in implementing these techniques.

Which of the following is LEAST likely to be a field in a Customers table?

EmploymentDate

Which of the following scenarios would most likely rely on Big Data? Choose two.

Evaluating applications for disability benefits and Calculating traffic delays during rush hour

Mindy needs to run a SQL query that will pull the names and birthdates of all her students. What should the FROM phrase say in her query?

FROM Students

Aron is building a website that will require a back-end database. He plans to connect the web server on his network in a way that it will be easily accessible from the Internet. He should connect his database server the same way so data in the database is readily accessible to the web server.

False, Web servers are designed to be accessible to the open Internet, but database servers should reside in more secure segments of the network behind a firewall.

Xavier is designing a Students table that will continue to track students even after they have completed their programs. Which of the following fields would work best with the Yes/No data type?

Graduated, The Yes/No data type allows only two values. The Graduated field would indicate whether a student has completed their educational program, which would require either a Yes or No response.

Which data type would be best suited to a field that lists customer email addresses?

Hyperlink

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

Increased database efficiency

Students who complete an online test are not allowed to change their test grades. What aspect of the CIA triad is at work here?

Integrity

What kind of database is needed to hold and organize diverse data types, such as X-ray images and doctors' notes, in a medical database?

Nonrelational databases, use a variety of approaches to store many kinds of data, such as images, videos, or other file types.

Casey is looking for a free, open-source RDBMS for his company. Which of the following best meets these requirements?

PostgreSQL

Dana is creating a table that will show books for sale on a bookstore's website. Which field in the table would best serve as its primary key?

ProductID

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?

SELECT Name, City

Kiera is building a front-end user interface for the database her new website will use. Which of the following languages is NOT used to build a webpage?

SQL

Which of these file types is optimized for processing calculations of numbers in a budget?

Spreadsheet, the software was originally intended as an electronic alternative to paper ledgers. A spreadsheet is designed to store numbers, charts, and other data in a grid of cells where it can perform automatic recalculations as data changes.

What programming language supports relational databases?

Structured Query Language (SQL)

Ibraheem works for a music store. Which of the following tables will give him the company contact information he needs to place a custom order for a guitar?

Vendors

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

ZoneType

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

availability

data breach

can be costly in terms of negative media exposure, loss of trust with customers or business partners, and government fines or even jailtime. Increased database efficiency, however, is not a risk of a data breach.

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

velocity