week 14 quiz

An expanded version of a star schema in which all of the tables are fully normalized is called a(n): A. snowflake schema. B. operational schema. C. DSS schema. D. complete schema.

A

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data. A. reconciled B. subject C. derived D.detailed

A

OLAP(Online Analytical Processing ) tools that use the database as a traditional relational database are called: A. Correct ROLAP(Relational Online Analytical Processing) tools. B. MOLAP tools. C. slice and dice. D. None of these.

A

A class of database technology used to store textual and other unstructured data is called: A. mySQL. B. NoSQL. C. KnowSQL. D. PHP.

B

A dependent data mart: A. is filled with data extracted directly from the operational system. B. is filled exclusively from the enterprise data warehouse with reconciled data. C. is dependent upon an operational system. D. participates in a relationship with an entity

B

Going from a summary view to progressively lower levels of detail is called data: A. cubing. B. drill-down. C. dicing. D. pivoting.

B

The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the: A. span. B. grain. C. selection. D. aggregation.

B

A data mart is a(n): A. enterprisewide data warehouse. B. smaller system built upon file processing technology. C. data warehouse that is limited in scope. D. generic on-line shopping site.

C

A star schema contains both fact and ________ tables. A. narrative B. cross functional C. dimension D. starter

C

An operational data store (ODS) is a(n): A. place to store all unreconciled data. B. representation of the operational data. C. integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users. D.small-scale data mart.

C

The use of a set of graphical tools that provides users with multidimensional views of their data is called: A. on-line geometrical processing (OGP). B. drill-down analysis. C. on-line analytical processing (OLAP). D. on-line datacube processing (ODP).

C

All of the following are limitations of the independent data mart EXCEPT: A. separate extraction, transformation, and loading processes are developed for each data mart. B. data marts may not be consistent with one another. C. there is no capability to drill down into greater detail in other data marts. D. it is often more expedient to build a data mart than a data warehouse.

D

All of the following are some beneficial applications for real-time data warehousing EXCEPT: A. just-in-time transportation. B. e-commerce. For example, an abandoned shopping cart can trigger an email promotional message. C. fraud detection in credit card transactions. D. data entry.

D

The real-time data warehouse is characterized by which of the following? A. It accepts near-real time feeds of transaction data. B. Data are immediately transformed and loaded into the warehouse. C. It provides near-real-time access for the transaction processing systems to an enterprise data warehouse. D. All of these.

D

Which of the following is true of data visualization? A. It is easier to observe trends and patterns in data. B. Correlations and clusters in data can be easily identified. C. It is often used in conjunction with data mining. D. Correct All of these.

D

NoSQL is a great technology for storing well-structured data. True False

False

For performance reasons, it may be necessary to define more than one fact table for a star schema. True False

True

Medical claims and pharmaceutical data would be an example of big data. True Flase

True