Question 1

Which of the following is not software that is primarily used for data visualization?

Accepted Answer

A) Tableau 
B) Microsoft Power BI 
C) Adobe Dreamweaver 
D) Microsoft Excel 
A) Tableau 
B) Microsoft Power BI 
C) Adobe Dreamweaver 
D) Microsoft Excel

Question 2

Which of the following is a metalanguage designed for the exchange of data on the web?

Accepted Answer

A) UML 
B) URL 
C) XML 
D) HTTP 
A) UML 
B) URL 
C) XML 
D) HTTP

Question 3

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

Accepted Answer

A) Encapsulation 
B) Fat client architecture 
C) Data warehouse architecture 
D) Local area network 
A) Encapsulation 
B) Fat client architecture 
C) Data warehouse architecture 
D) Local area network

Question 4

What do you call an arrangement of location data with three levels, such as cities within states within countries?

Accepted Answer

A) hierarchy 
B) virtualized 
C) framework 
D) snapshot 
A) hierarchy 
B) virtualized 
C) framework 
D) snapshot

Question 5

What type of Excel chart compares values across geographical locations?

Accepted Answer

A) Globe chart 
B) Atlas chart 
C) GPS chart 
D) Map chart 
A) Globe chart 
B) Atlas chart 
C) GPS chart 
D) Map chart

Question 6

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

Accepted Answer

A) OLAP database 
B) graph database 
C) document database management system 
D) wide column store 
A) OLAP database 
B) graph database 
C) document database management system 
D) wide column store

Question 7

Which of the following could be described as a contemporary implementation of centralized architecture?

Accepted Answer

A) cloud computing 
B) distributed databases 
C) client/server architecture 
D) peer-to-peer computing 
A) cloud computing 
B) distributed databases 
C) client/server architecture 
D) peer-to-peer computing

Question 8

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

Accepted Answer

A) comma-separated values (CSV) 
B) Excel workbook (XLSX) 
C) Open Database Connectivity (ODB
C)  
D) PowerPoint presentation (PPTX) 
A) comma-separated values (CSV) 
B) Excel workbook (XLSX) 
C) Open Database Connectivity (ODB
C)  
D) PowerPoint presentation (PPTX)

Question 9

Which of the following is information that Google Analytics does not provide?

Accepted Answer

A) type of device used to access a website 
B) accessibility of a website 
C) session duration 
D) bounce rate 
A) type of device used to access a website 
B) accessibility of a website 
C) session duration 
D) bounce rate

Question 10

Explain when you are likely to use a NoSQL DBMS and when you are likely to use an object-oriented DBMS.

Accepted Answer

NoSQL is often used for web apps, recomm

Question 11

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

Accepted Answer

A) virtual database 
B) back-end database 
C) distributed database 
D) cloud database 
A) virtual database 
B) back-end database 
C) distributed database 
D) cloud database

Question 12

The data in a data warehouse is often made available to users through the direct use of SQL SELECT statements.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) document database management system 
B) wide column store 
C) graph database 
D) key/value database 
A) document database management system 
B) wide column store 
C) graph database 
D) key/value database

Question 14

_____ means that when using a distributed database, users feel that the data they work with comes from a single central database.

Accepted Answer

A) Replication transparency 
B) Continuous operation 
C) Fragmentation transparency 
D) Network independence 
A) Replication transparency 
B) Continuous operation 
C) Fragmentation transparency 
D) Network independence

Question 15

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?

Accepted Answer

A) Pie chart 
B) Sunburst chart 
C) Waterfall chart 
D) Radar chart 
A) Pie chart 
B) Sunburst chart 
C) Waterfall chart 
D) Radar chart

Question 16

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

Accepted Answer

A) data type 
B) object 
C) level 
D) key/value pair 
A) data type 
B) object 
C) level 
D) key/value pair

Question 17

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

Accepted Answer

A) WordPress 
B) XQuery 
C) Hadoop 
D) SQLite 
A) WordPress 
B) XQuery 
C) Hadoop 
D) SQLite

Question 18

What is a goal of a distributed database?

Accepted Answer

A) It should allow access to only a handful of trusted users. 
B) It should provide an open architecture that organizations can customize as needed. 
C) It should automatically normalize data. 
D) It should feel and work like a single database to users. 
A) It should allow access to only a handful of trusted users. 
B) It should provide an open architecture that organizations can customize as needed. 
C) It should automatically normalize data. 
D) It should feel and work like a single database to users.

Question 19

Which database technology optimizes data for querying, analyzing, and reporting?

Accepted Answer

A) Open Database Connectivity (ODB
C)  
B) online transaction processing (OLTP) 
C) online analytical processing (OLAP) 
D) Unified Modeling Language (UML) 
A) Open Database Connectivity (ODB
C)  
B) online transaction processing (OLTP) 
C) online analytical processing (OLAP) 
D) Unified Modeling Language (UML)

Question 20

Which of the following is a data visualization tool that typically summarizes data from three or more fields?

Accepted Answer

A) PivotChart 
B) histogram 
C) dashboard 
D) graph database 
A) PivotChart 
B) histogram 
C) dashboard 
D) graph database

Which of the following is not software that is primarily used for data visualization?

Which of the following is a metalanguage designed for the exchange of data on the web?

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

What do you call an arrangement of location data with three levels, such as cities within states within countries?

What type of Excel chart compares values across geographical locations?

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

Which of the following could be described as a contemporary implementation of centralized architecture?

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

Which of the following is information that Google Analytics does not provide?

Explain when you are likely to use a NoSQL DBMS and when you are likely to use an object-oriented DBMS.

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

The data in a data warehouse is often made available to users through the direct use of SQL SELECT statements.

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

_____ means that when using a distributed database, users feel that the data they work with comes from a single central database.

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?

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

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

What is a goal of a distributed database?

Which database technology optimizes data for querying, analyzing, and reporting?

Which of the following is a data visualization tool that typically summarizes data from three or more fields?

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters

Exam 1: Introduction to Database Management

Which of the following is not software that is primarily used for data visualization?

Which of the following is a metalanguage designed for the exchange of data on the web?

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

What do you call an arrangement of location data with three levels, such as cities within states within countries?

What type of Excel chart compares values across geographical locations?

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

Which of the following could be described as a contemporary implementation of centralized architecture?

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

Which of the following is information that Google Analytics does not provide?

Explain when you are likely to use a NoSQL DBMS and when you are likely to use an object-oriented DBMS.

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

The data in a data warehouse is often made available to users through the direct use of SQL SELECT statements.

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

_____ means that when using a distributed database, users feel that the data they work with comes from a single central database.

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?

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

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

What is a goal of a distributed database?

Which database technology optimizes data for querying, analyzing, and reporting?

Which of the following is a data visualization tool that typically summarizes data from three or more fields?

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters