Glossary: Terms and definitions

We’ve covered a lot of terms—some of which you may have already known, and some of which are new. To make it easy to remember what a word means, we created this glossary of terms and definitions.

To use the glossary for this course item, click the link below and select “Use Template.”

Link to glossary: Week 3 Glossary

OR

If you don’t have a Google account, you can download the glossary directly from the attachment below.

Weekly challenge 3

Question 1

In a relational database, which type of key is unique in every role of its table, and cannot be null or blank?

A. Normalized

B. Foreign

C. Secondary

D. Primary

The correct answer is D. Primary

Question 2

What is a tool used to store metadata so analysts can ensure that data is consistent and reliable?

A. Relational database

B. Metadata server

C. Text files

D. Metadata repository

The correct answer is D. Metadata repository

Question 3

Structural metadata indicates how a piece of data is organized and whether it’s part of one or more than one data collection. True or False?

A. True

B. False

Question 4

What is the process that data analysts use to ensure the formal management of their company’s data assets?

A. Data integrity

B. Data mapping

C. Data aggregation

D. Data governance

The correct answer is D. Data governance

Question 5

Which type of data is typically generated from within a company and lives in that company's own systems?

A. Internal

B. Third party

C. External

D. Second party

The correct answer is A. Internal

Question 6

A nonprofit maintains a list of how many laptops they provide to each school in the county. In the table, there is a column called number_of_laptops. A data analyst wants to determine which schools were given the fewest laptops. How should they sort the data to display these schools first?

A. Sort numerically in descending order.

B. Sort alphabetically in ascending order.

C. Sort alphabetically in descending order.

D. Sort numerically in ascending order.

The correct answer is D. Sort numerically in ascending order.

Question 7

When writing a query, you add a WHERE condition to filter the set. What must you put around the value you are trying to match or search for?

A. single quotes (‘)

B. curly braces ({})

C. underscores (_)

D. backslash (/)

The correct answer is A. single quotes (‘)

Question 8

You are working with a database table that contains customer data. The company column lists the company affiliated with each customer. You want to find customers from the company Riotur.

You write the SQL query below.

SELECT * FROM Customer

What code would be added to return only customers affiliated with the company Riotur?

A. WHERE company = ‘Riotur’

B. company = ‘Riotur’

C. JOIN company = ‘Riotur’

D. IN company = ‘Riotur’

The correct answer is A. WHERE company = ‘Riotur’.