Week 8 Asynch. Quiz: Data Repositories and Schema-on-Write Database Design

"Schema" is a fancy word for ___________.

 a. Data

 b. Software or hardware

 c. model or design

 d. Information

c. model or design

Which of the following is not one of the five V's of big data?

 a. Variety

 b. Variability

 c. Veracity

 d. Volume

b. Variability

Extract-Transform-Load (ETL) is the process of what?

 a. Organizing big data

 b. Schema-on-read

 c. Building a data warehouse

 d. Building a business

c. Building a data warehouse

With a Schema-on-Write database, structure (schema) is given to my database ________. 

 a. After the data has been captured.

 b. When it is loaded into the visualization software.

 c. As data comes into my database.

 d. Upon creating the database.

d. Upon creating the database.

T/F:  Many-to-many relationships can exist in a schema-on-write database.

 a. True

 b. False

b. False

Relational databases are an example of __________.

 a. Object orientated databases

 b. Schema-on-write databases

 c. Big databases

 d. Schema-on-read databases

b. Schema-on-write databases

In a relational database, the lines that connect one table to another are called __________.

 a. Relationships

 b. Joins

 c. Connectors

 d. Intersections

a. Relationships

If the Customer_ID field is the primary key in the Customer table, what is Customer_ID called when it shows up in the Orders Table?

 a. Secondary Key

 b. Primary Key

 c. Main Key

 d. Foreign Key

d. Foreign Key

What diagram is commonly used to represent a conceptual model?

 a. UML Activity Diagram

 b. Gantt Chart

 c. Data Flow Diagram (DFD)

 d. Entity Relationship Diagram (ERD)

d. Entity Relationship Diagram (ERD)

What is the difference between a primary key and a foreign key?

 a. They are interchangeable in database design

 b. A primary key is always numeric, while a foreign key is text-based

 c. A foreign key is always optional, while a primary key is required

 d. A primary key uniquely identifies records, while a foreign key links tables

d. A primary key uniquely identifies records, while a foreign key links tables