A database is primarily responsible for: [select any that apply]
Providing computing power Storing data Making data accessible Providing means to secure stored data Virtualization
x Providing computing power - Storing data - Making data accessible - Providing means to secure stored data x Virtualization
Every application needs a ______ to store data and function. [one word]
database
The process of translating the requirements of an application and the flow of data into a formalized structure is called ________ [two words]
data modeling
Which of these statements are true about data modeling? [select any that apply]
- Data models vary by type of database (i.e. modeling data is different for relational vs. document model)
- The process of data modeling can involve data architects and/or developers
- The process of data modeling for a relational database is painstakingly involved and detailed
- Data modeling for a relational database is vastly different from a document database
- Data models vary by type of database (i.e. modeling data is different for relational vs. document model)
- The process of data modeling can involve data architects and/or developers
- The process of data modeling for a relational database is painstakingly involved and detailed
- Data modeling for a relational database is vastly different from a document database
A schema is:
- A visual representation of what’s being stored (and the relationships that exist) in the database
- A visual representation of how the database connects to users and applications
- A visual representation of the components of a computer (CPU, GPU, RAM, storage, etc.)
- The relationship between containers and applications
- A visual representation of what’s being stored (and the relationships that exist) in the database
x A visual representation of how the database connects to users and applications
x A visual representation of the components of a computer (CPU, GPU, RAM, storage, etc.)
x The relationship between containers and applications
Data architects are responsible for: [select any that apply]
- Understanding the complex relationships that exist between data and business rules
- Developing front end applications
- Creating the database schema(s)
- Understanding the complex relationships that exist between data and business rules
x Developing front end applications - Creating the database schema(s)
The difference between a schema and an Entity Relationship Diagram (ERD) is:
- There is no difference
- Schemas are only applied to relational databases, whereas ERDs are used everywhere
- An ERD is specifically a schema for a relational database
x There is no difference
x Schemas are only applied to relational databases, whereas ERDs are used everywhere
- An ERD is specifically a schema for a relational database
Rules for Entity Relationship Diagrams (ERDs) include: [select any that apply]
- They are very rigid in production
- They tend to stay small over time
- They can get enormous
- They get built prior to the database
- They are very rigid in production
x They tend to stay small over time - They can get enormous
- They get built prior to the database
A ________ is a question we ask of the database [one word]
query
A query language is:
- A specialized way of verbally asking questions of a database
- The same for every database
- A highly defined way a database stipulates questions may be asked
x A specialized way of verbally asking questions of a database
x The same for every database
- A highly defined way a database stipulates questions may be asked
Examples of query languages include: [select any that apply]
- MQL
- SQL
- JSON
- XML
- MQL
- SQL
x JSON
x XML
An index speeds up _____ [one word), but slows down ______. [one word] NOTE: please separate your answer(s) with commas.
reads, writes
Creating indexes is part art, and part science. The best way to help my customers “get it right” in MongoDB is by:
- Suggesting they apply experience they have with - relational databases
- Selling Professional Services
- Leave them to their own devices
x Suggesting they apply experience they have with - relational databases
- Selling Professional Services
x Leave them to their own devices
When compared to a relational database, MongoDB’s ability to create secondary indexes is:
- A competitive differentiator
- Not a competitive differentiator
x A competitive differentiator
- Not a competitive differentiator
Latency is:
- A measure of the time between request and response
- A measure of how many concurrent requests a system can handle
- A measure of the time between request and response
x A measure of how many concurrent requests a system can handle
Throughput is:
- A measure of the time between request and response
- A measure of how many concurrent requests a system can handle
x A measure of the time between request and response
- A measure of how many concurrent requests a system can handle
A backup means you’ve made a good _____ of your data. [one word]
copy
Backups are important because: [select any that apply]
- Data is critically important for an organization
- Even with steps taken to ensure data replication, errors in the database would be also replicated and it’s important to have a “good” copy of the data
- None of these are true: backups are not important for modern databases
- Data is critically important for an organization
- Even with steps taken to ensure data replication, errors in the database would be also replicated and it’s important to have a “good” copy of the data
x None of these are true: backups are not important for modern databases
The amount of time an organization needs to restore from a backup is known as _________. [three words]
Correct Answer: recovery time objective
The amount of data an organization is willing to tolerate losing is known as _______. [three words]
Correct Answer: recovery point objective
The first relational databases got their start in the year ______, when the technology landscape and computers were completely different. [four digit number]
1969
Relational databases were designed to minimize duplicate data, because the most expensive part of computers was ______. [one or two words]
storage
Relational databases are commonly abbreviated as ________. [one word acronym] HINT: the acronym incorporates the management system used for relational databases.
RDBMS
The query language used by all relational databases is known as ________. [three words]
Correct Answer: structured query language
