Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

mongo > DB Foundations > Flashcards

DB Foundations Flashcards

1
Q

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
A 
x Providing computing power
- Storing data
- Making data accessible
- Providing means to secure stored data
x Virtualization
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Every application needs a ______ to store data and function. [one word]

A

database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The process of translating the requirements of an application and the flow of data into a formalized structure is called ________ [two words]

A

data modeling

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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
A
  • 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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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
  • 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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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)
A
  • Understanding the complex relationships that exist between data and business rules
    x Developing front end applications
  • Creating the database schema(s)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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
A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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
A
  • 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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A ________ is a question we ask of the database [one word]

A

query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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
A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Examples of query languages include: [select any that apply]

  • MQL
  • SQL
  • JSON
  • XML
A
  • MQL
  • SQL
    x JSON
    x XML
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

An index speeds up _____ [one word), but slows down ______. [one word] NOTE: please separate your answer(s) with commas.

A

reads, writes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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
A

x Suggesting they apply experience they have with - relational databases
- Selling Professional Services
x Leave them to their own devices

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

When compared to a relational database, MongoDB’s ability to create secondary indexes is:

  • A competitive differentiator
  • Not a competitive differentiator
A

x A competitive differentiator

- Not a competitive differentiator

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Latency is:

  • A measure of the time between request and response
  • A measure of how many concurrent requests a system can handle
A
  • A measure of the time between request and response

x A measure of how many concurrent requests a system can handle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Throughput is:

  • A measure of the time between request and response
  • A measure of how many concurrent requests a system can handle
A

x A measure of the time between request and response

- A measure of how many concurrent requests a system can handle

17
Q

A backup means you’ve made a good _____ of your data. [one word]

A

copy

18
Q

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
A
  • 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
19
Q

The amount of time an organization needs to restore from a backup is known as _________. [three words]

A

Correct Answer: recovery time objective

20
Q

The amount of data an organization is willing to tolerate losing is known as _______. [three words]

A

Correct Answer: recovery point objective

21
Q

The first relational databases got their start in the year ______, when the technology landscape and computers were completely different. [four digit number]

A

1969

22
Q

Relational databases were designed to minimize duplicate data, because the most expensive part of computers was ______. [one or two words]

A

storage

23
Q

Relational databases are commonly abbreviated as ________. [one word acronym] HINT: the acronym incorporates the management system used for relational databases.

A

RDBMS

24
Q

The query language used by all relational databases is known as ________. [three words]

A

Correct Answer: structured query language

25
Q

Common relational databases include: [select any that apply]

  • PostgreSQL
  • Oracle
  • MongoDB
  • MySQL
A
  • PostgreSQL
  • Oracle
    x MongoDB
  • MySQL
26
Q

As a seller, I need to understand relational databases because: [select any that apply]

  • I will be competing with them and need to understand my competition
  • MongoDB uses the relational data model
  • Understanding where databases got their start will help me articulate the value proposition of MongoDB
A
  • I will be competing with them and need to understand my competition
    x MongoDB uses the relational data model
  • Understanding where databases got their start will help me articulate the value proposition of MongoDB
27
Q

Data Validation can be defined as:

  • Rules that dictate how query languages work
  • A set of conditions required to grant access to a database
  • Enforcing rules regarding what types of data are allowed and/or what’s required in a record
A

x Rules that dictate how query languages work
x A set of conditions required to grant access to a database
- Enforcing rules regarding what types of data are allowed and/or what’s required in a record

28
Q

Relational databases are required to do the following:

  • Store everything in a single giant table
  • Store data across many tables (i.e. normalize data)
A

x Store everything in a single giant table

- Store data across many tables (i.e. normalize data)

29
Q

The relational data model presents many challenges, including:
- painstaking data modeling (sometimes resulting in out of control schemas) - scalability - availability - backups It was built to minimize the amount of disk storage needed by an application, but the world has changed substantially since it relational got its start.

In the modern world where disk storage is basically free, does it make sense to keep using a database with many drawbacks that hamper developers and application development?

A

No

30
Q

True or False? Because the relational data model has many drawbacks, it’s safe for me to presume that my customers will always be eager to move their applications to something more modern.

A

False

mongo (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions