Filters
Question type
Study Flashcards

Operational databases store historical data.

A) True
B) False

Correct Answer

verifed

verified

What is the NoSQL movement?

Correct Answer

verifed

verified

The NoSQL movement is a school of though...

View Answer

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

A) True
B) False

Correct Answer

verifed

verified

Slowly changing dimensions are handled by a(n) ________.


A) operational database
B) dimensional database
C) structured storage
D) A or B
E) All of the above

F) A) and B)
G) A) and E)

Correct Answer

verifed

verified

In RFM analysis,F stands for "how frequently."

A) True
B) False

Correct Answer

verifed

verified

In a common form of RFM analysis,customers are sorted into five groups and given an associated score depending on their group.

A) True
B) False

Correct Answer

verifed

verified

Compare the characteristics of an operational database and a dimensional database.

Correct Answer

verifed

verified

An operational database is used for stru...

View Answer

RFM analysis analyzes and ranks customers based on:


A) their purchasing patterns.
B) their income status.
C) their residential location.
D) A and B
E) A,B,and C

F) B) and D)
G) C) and D)

Correct Answer

verifed

verified

Business Intelligence (BI) systems do which of the following?


A) Analyze current and past activities
B) Predict future events
C) Record and process transactions
D) A and B
E) A,B,and C

F) B) and C)
G) C) and E)

Correct Answer

verifed

verified

The structured storage equivalent of an RDBMS table is a ________.


A) column
B) super column
C) column family
D) map
E) reduce

F) C) and E)
G) B) and E)

Correct Answer

verifed

verified

Business Intelligence (BI) systems obtain their data by which of the following means?


A) Read and process data from an operational database
B) Process extracts from operational databases
C) Process data purchased from data vendors
D) A and B
E) A,B,and C

F) A) and E)
G) B) and E)

Correct Answer

verifed

verified

To use an SQL Server 2012 database in an Microsoft Excel 2013 PivotTable,it is generally useful to:


A) create a view in SQL Server 2012 to organize the data.
B) store the needed data in an Excel worksheet.
C) store the needed data in a Word document.
D) store the needed data in a PowerPoint slide show.
E) store the needed data in a Visio diagram.

F) A) and D)
G) B) and D)

Correct Answer

verifed

verified

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

A) True
B) False

Correct Answer

verifed

verified

Operational databases contain a fact table.

A) True
B) False

Correct Answer

verifed

verified

Microsoft Excel 2013 cannot import SQL Server 2013 data directly into a PivotTable report,but must first place the data into a worksheet.

A) True
B) False

Correct Answer

verifed

verified

A data warehouse database differs from an operational database because:


A) data warehouse data are not stored in tables.
B) data warehouse databases do not have metadata.
C) data warehouse data are often denormalized.
D) B and C
E) A,B,and C

F) B) and C)
G) B) and D)

Correct Answer

verifed

verified

What is a slowly changing dimension?

Correct Answer

verifed

verified

A slowly changing dimension is an attrib...

View Answer

An OLAP cube is called that because some products show OLAP displays on ________ axes.


A) one
B) two
C) three
D) four
E) a number that varies depending upon the analysis being done

F) A) and C)
G) None of the above

Correct Answer

verifed

verified

What are Business Intelligence (BI)systems?

Correct Answer

verifed

verified

Business Intelligence (BI)systems are in...

View Answer

Metadata about the data's source,format,assumptions and constraints are kept in a data warehouse metadata database.

A) True
B) False

Correct Answer

verifed

verified

Showing 41 - 60 of 102

Related Exams

Exam 1

Introduction

100 Questions

Exam 2

Introduction to Structured Query Language SQL

105 Questions

Exam 3

The Relational Model and Normalization

100 Questions

Exam 4

Database Design Using Normalization

100 Questions

Exam 5

Data Modeling With the Entity-Relationship Model

100 Questions

Exam 6

Transforming Data Models Into Database Designs

103 Questions

Exam 7

Sql for Database Construction and Application Processing

100 Questions

Exam 8

Database Redesign

101 Questions

Exam 9

Managing Multiuser Databases

102 Questions

Exam 10

A: Managing Databases With SQL Server 20012

100 Questions

Exam 10

B: Managing Databases With Oracle Database 11g Release 2

100 Questions

Exam 10

C: Managing Databases With MySQL

100 Questions

Exam 11

The Web Server Environment

198 Questions

Exam 13

Microsoft Access 2013

48 Questions

Exam 14

Getting Started With Systems Analysis and Design

35 Questions

Exam 15

E-R Diagrams and the Idef1x Standard

35 Questions

Exam 16

E-R Diagrams and the UML Standard

36 Questions

Exam 17

Getting Started With MySQL Workbench Data Modeling Tools

37 Questions

Exam 18

Getting Started With Microsoft Visio 2013

34 Questions

Exam 19

Data Structures for Database Processing

35 Questions

Exam 20

the Semantic Object Model

35 Questions

Exam 21

Getting Started With Web Servers php and the Eclipse PDT

35 Questions

Exam 22

Business Intelligence Systems

80 Questions

Show Answer