Module 3 Quiz: Data and Business Intelligence

One of the main applications of database and database systems is database marketing.

True or False?

-True

A data lake gathers and stores data in its original format in a central location. The collected data can be structured as well as unstructured.

True or False?

-True

In a data warehouse environment, ETL refers to extraction, transformation, and language.

True or False?

False

One of the following is not a type of mobile analytics:

a. Advertising and marketing analytics

b. In-app analytics

c. Installation analytics

d. Performance analytics

c. installation analytics

One of the following is not among the 5 Vs of big data:

a. Variety

b. Variance

c. Value

d. Veracity

b. Variance

Tableau and Power BI are used for all of the following purposes except:

a. Exploring and finding patterns in data

b. Creating multiple charts to get meaningful insight into data

c. Allowing analyzing data with different formats

d. All of these choices

d. all the these choices

In the context of how information is viewed in a database, the _____ involves how data is stored on and retrieved from storage media.

a. logical view

b. analytical view

c. physical view

d. rational view

c. physical view

In a(n) _____, nodes with the same parents are called twins or siblings.

a. relational model

b. network model

c. hierarchical model

d. object-based model

c. hierarchical model

The data _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.

a. manipulation

b. generation

c. administration

d. definition

d. definition

Which component of a database management system (DBMS) is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

a. application manipulation

b. application definition

c. application generation

d. application administration

c. application generation

In comparison with flat file systems, databases:

a. minimize data redundancy.

b. have less sophisticated security measures.

c. require more storage space.

d. are easier to design.

a. minimize data redundancy.

Considering the data types in a database, which is a source of internal data?

a. Tax records

b. Distribution networks

c. Sales records

d. Economic indicators

c. sales records

A _____ converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

a. static site

b. database engine

c. database mine

d. data-driven site

b. database engine

All of the following are true about SQL except:

a. It uses keywords such as SELECT, FROM, and WHERE

b. It was first called a Structured English Query Language, or Sequel

c. Microsoft Access and Oracle database support it

d. It does not support relational database design

d. It does not support relational database design.