Exam 3: Data and Business Intelligence

Risks associated with big data technology include which of the following?

A data mart is usually _______ a data warehouse.

In a relational database, every record must be uniquely identified by a _____ key .

In the context of data models, relationships among records in a hierarchical model are called _____.

Which file structure is similar to a book index that lists page numbers where certain topics can be found?

A disadvantage of Power BI is that it only accepts data from a single source.

A data _____  is the structure and organization of data, which involves fields, records, and files.

In the context of the data manipulation component of a database management system (DBMS), briefly explain structured query language (SQL).

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

In the context of a database marketing campaign, _______ tells a business how much it should spend to maintain a relationship.

Static Web sites are useful for e-commerce sites that need frequent updates.

In the context of the input component of a data warehouse, _____ collect, integrate, and process data that can be used by all functional areas in an organization.

Discuss the advantages of data marts over data warehouses.

In the context of business analytics, which method prepares a decision maker for future events?

Which type of databases is not limited by the data's physical location?

Business intelligence (BI)uses scorecards and dashboards to support decision-making activities, whereas business analytics (BA)uses data mining tools and predictive modeling.

In the context of the types of data in a database, which is a source of external data?

Which of the following is not considered an advantage of Power BI?

A data mart is designed for an entire organization's use.

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