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
