Question 1

Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.​

Accepted Answer

Dynamic scaling for database servers requires the addition of shards to be handled in real-time by the DBMS. This can be a challenge as it requires the system to allocate resources and balance workload on the fly.

Question 2

The process of dividing a database into distributed subsets is called ________.​

Accepted Answer

The answer of The process of dividing a database into...

Question 3

When joining two tables using SQL, the convention is to use ______ notation for field names.​

Accepted Answer

The answer of When joining two tables using SQL, the...

Question 4

1024 Zettabytes = 1 _______.​

Accepted Answer

The answer of 1024 Zettabytes = 1 _______.​...

Question 5

The simplest structure for storing data in a(n) _________ database is the key-value data model.​

Accepted Answer

The answer of The simplest structure for storing data in...

Question 6

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.​

Accepted Answer

The answer of The term __________ is used to refer...

Question 7

_________-density data refers to large volumes of very detailed data in which many of the details are not important.​

Accepted Answer

The answer of _________-density data refers to large volumes of...

Question 8

The entire Internet contains about a zettabyte of data.​

Accepted Answer

As of 2023, the entire Internet contains multiple zettabytes of data, with estimates suggesting it has surpassed 100 zettabytes.

Question 9

An example of _________ data is the 1 million transactions generated by Walmart sales registers every hour.​

Accepted Answer

The answer of An example of _________ data is the...

Question 10

Ten terabytes offer enough storage capacity to hold the printed collection of the Library of Congress.​

Accepted Answer

The printed collection of the Library of Congress contains approximately 170 million items, which would require around 10 terabytes of storage capacity.

Question 11

SQL is banned from the NoSQL technology collection.​

Accepted Answer

SQL and NoSQL are two different types of database technologies. While SQL databases are relational databases that store data in structured tables with predefined schemas, NoSQL databases are non-relational and can store data in various structures, including document-based, key-value pair, graph, and column-family. Therefore, SQL is not banned from the NoSQL technology collection, it just does not fall within the realm of NoSQL databases.

Question 12

__________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.​

Accepted Answer

The answer of __________ is a file system developed in...

Question 13

Relational databases are organized according to a(n) _________, which is simply the blueprint for its structure.​

Accepted Answer

The answer of Relational databases are organized according to a(n)...

Question 14

____________ scaling (or autoscaling) ensures acceptable database throughput by scaling out as necessary to handle peak loads.​

Accepted Answer

The answer of ____________ scaling (or autoscaling) ensures acceptable database...

Question 15

A __________ solution for data storage adds resources to a single device, while a __________ solution adds more devices to a system.​
A) ​SQL, NoSQL
B) ​structured, unstructured
C) ​scale out, scale up
D) ​scale up, scale out

Accepted Answer

A scale-up solution adds resources to a single device, while a scale-out solution adds more devices to a system.

Question 16

In a key-value database, each data item has a key that is a unique identifier similar to a relational database key​

Accepted Answer

In a key-value database, each data item is identified by a unique key, similar to a relational database key.

Question 17

The term __________ refers to huge collections of data that are difficult to process, analyze, and manage using conventional database tools.​

Accepted Answer

The answer of The term __________ refers to huge collections...

Question 18

Relational databases store unstructured data.​

Accepted Answer

Relational databases store structured data. Semi-structured data may also be stored in some cases, but not unstructured data.

Question 19

An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed.​
A) ​The 3rd platform
B) ​NoSQL
C) ​SQL
D) ​BLOB

Accepted Answer

The description of massive scale in cloud-based hardware technology and vast amounts of data points towards the 3rd platform, which includes cloud computing, big data analytics, mobile computing, and social networking. NoSQL and SQL are database technologies, while BLOB stands for Binary Large Object and is not related to computing platforms.

Question 20

The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.​
A) ​MERGE
B) ​JOIN
C) ​SELECT
D) ​UPDATE

Accepted Answer

The JOIN command allows you to combine and access data from more than one table simultaneously.

Quiz 10: Databases

Dynamic scaling for database servers can be a challenge because the additional sharding has to be handled on the fly by the DBMS.

The process of dividing a database into distributed subsets is called ________.

When joining two tables using SQL, the convention is to use ______ notation for field names.

1024 Zettabytes = 1 _______.

The simplest structure for storing data in a(n) _________ database is the key-value data model.

The term __________ is used to refer to a group of technologies for managing databases that do not adhere to the relational model and standard SQL query language.

_________-density data refers to large volumes of very detailed data in which many of the details are not important.

The entire Internet contains about a zettabyte of data.

An example of _________ data is the 1 million transactions generated by Walmart sales registers every hour.

Ten terabytes offer enough storage capacity to hold the printed collection of the Library of Congress.

SQL is banned from the NoSQL technology collection.

__________ is a file system developed in 2005 that handles millions of files distributed across multiple server nodes.

Relational databases are organized according to a(n) _________, which is simply the blueprint for its structure.

____________ scaling (or autoscaling) ensures acceptable database throughput by scaling out as necessary to handle peak loads.

A solution for data storage adds resources to a single device, while a solution adds more devices to a system.

In a key-value database, each data item has a key that is a unique identifier similar to a relational database key

The term __________ refers to huge collections of data that are difficult to process, analyze, and manage using conventional database tools.

Relational databases store unstructured data.

An emerging computing platform that is likely to drive innovation and disruption through the next decade called __________ has massive scale, not only in cloud-based hardware technology, but also in the vast amount of data that will be generated, consumed, and analyzed.

The SQL ________ command allows you to temporarily join and simultaneously access the data in more than one table.