Module 9

Which of the following is a technology that data scientists use to store and analyze big data?

Hadoop

What do you call the prediction that the number of transistors on a chip is likely to double every two years?

Moore's Law

Which of the following is not a type of NoSQL database system?

OLAP database

Which of the following is a language for querying web-based documents and similarly structured data repositories?

XQuery

Which of the following statements is true about selecting a DBMS?

a. Large businesses are unlikely to switch from one DBMS to another because they have already made significant investments in their systems.

What type of Excel chart would you create to compare the relative amount of sales between different categories of products within different regions as proportionally sized rings?

a. Sunburst chart

Because _____ read and write files as well as communicate with a centralized database, they run on a server.

a. back-end technologies

A(n) _____ is a special data type for complex data such graphics, drawings, photographs, video, and sound.

a. binary large object (BLOB)

Which of the following types of NoSQL database systems are commonly used for artificial intelligence (AI) applications?

a. graph database

Which of the following is not a high-level programming language?

b. Assembler

Which of the following is not a common data file format that database management systems use to export data?

b. PowerPoint presentation (PPTX)

A _____ is a set of standards, development tools, and software libraries that help programmers develop software solutions faster and with more consistency.

b. framework

What is a goal of a distributed database?

c. It should feel and work like a single database to users.

In an OODBMS, a(n) _____ is a set of related attributes along with the actions that are associated with the set of attributes.

c. object

Which of the following is not one of Codd's 12 rules for distributed databases?

c. reliance on a central site

Google searches and social media postings that direct traffic to a website are known as _____.

channels

_____ refers to the hardware and software an organization needs to address the analytical requirements of users without detracting from traditional operations.

d. Data warehouse architecture

_____ is a format for storing and transporting data often used when data is sent from a server to a webpage.

d. JavaScript Object Notation (JSON)

In object-oriented technologies, what is a class?

d. an object that functions as a blueprint for more objects

A _____ is a single logical database that is physically divided among computers at several sites on a network.

d. distributed database

JSON data is shared in _____.

d. key/value pairs

In cloud computing, although many clients share the same resources, a company's systems operate as if they were running on their own dedicated system because of _____.

d. virtualization

A _____ is a one-page grouping of key performance indicators (KPIs) that allow decision makers to evaluate and act on important data.

dashboard

Which of the following does not describe the data in a data warehouse?

dynamic

Git and GitHub operate on what type of distributed database model?

snapshot