BIS 366: Exam 1

The logical database model is created prior to the conceptual database model. A. True B. False

b. false

Which of the following is a legitimate exact minimum and maximum cardinality? A. (5, 4) B. (20, 10) C. (5, 10) D. (5, 0)

c. (5, 10)

Which of the following is typically found in the database metadata? A. Data types B. Product prices C. Employee names D. Student ages

a. data types

How many entities are depicted by the following requirements? School XYZ keeps track of its 100 students, 10 teachers, and 5 classrooms. A. 4 B. 3 C. 116 D. 115

b. 3

Operational queries are typically issued: A. Only to verify the results of analytical queries B. More often than analytical queries C. Less often than analytical queries D. Equally as often as analytical queries E. Never in a corporation that has users issuing analytical queries

b. more often than analytical queries

The purpose of the source system is: A. As a write-only source system (no queries) B. Original operational purpose only C. As a source system for the data warehouse only D. Both the original operational purpose and as a source system for the data warehouse E. Either as the original operational purpose or as a source system for the data warehouse, but not both

b. original operational purpose only

Which of the following is a part of the data warehouse requirements step? A. Data warehouse deployment B. Creating ETL Infrastructure C. Conceptual modeling D. Logical modeling E. All of the above

c. conceptual modeling

Which of the following allows use of the same dimensions with multiple fact tables? A. Time column B. Snowflaking C. Galaxy of stars D. Transaction identifier E. Degenerate dimension

c. galaxy of stars

The description of the structure and the properties of the data fits into which category? A. DBMS B. Data C. Metadata D. Information

c. metadata

Analytical information is based on operational information. A. True B. False

a. true

Typically, in a star schema all ________ are given a simple, non-composite system-generated primary key, also called a surrogate key. A. Fact tables B. Dimension tables C. Time columns D. Transaction identifiers E. Measures

b. dimension tables

Maximum cardinality can be: A. Zero or many B. Optional or many C. One or many D. Optional or mandatory

c. one or many

Which of the following is NOT true: A. Data marts typically have fewer data sources than data warehouses B. Data marts typically have more narrow focus than data warehouses C. Data marts are typically not as big as data warehouses D. Data marts typically have shorter implementation time than data warehouses E. Data marts typically have more subjects of analysis than data warehouses

b. data marts typically have more narrow focus than data warehouses

In a typical properly-designed star schema, the number of records/rows in any of the dimension tables is: A. Larger than in the fact table B. Same as in the fact table C. Smaller than in the fact table D. No typical rule—there is a similar number of dimension tables with larger, smaller and same number of records as in the fact table E. Between 50 and 100

c. smaller than in the fact table

Due to multiple subjects of analysis sharing dimensions, the following occurs: A. A star schema is composed strictly of fact tables B. A dimensional model contains more than one fact table C. Some dimensions are eliminated D. All dimensions are reduced E. Time of day is eliminated

b. a dimensional model contains more than one fact table

DMBS software is used for the following purpose: A. All of the above B. Maintenance of databases C. Creation of databases D. Insertion, storage, retrieval, update, and deletion of the data in the database

a. all of the above

________ are in charge of implementing the database model as a functioning database using the DBMS software. A. Database developers B. Database analysts C. Database architects D. DBAs

a. database developers

Which of the following is NOT a possible cardinality constraint? A. Optional zero B. Optional one C. Mandatory one D. Optional many

a. optional zero

Which of the following is a component of a database system? A. Database B. All of the above C. DBMS D. Front-end application

b. all of the above

Which of the following is a format in which data can appear? A. Image B. Numbers C. Text D. All of the above

d. all of the above

Which of the following is a part of the database requirements step? A. Database implementation B. Logical modeling C. Database deployment D. Conceptual modeling

d. conceptual modeling

Which of the following would typically be stored in source (operational database) systems? A. Subject-Oriented Data B. Derived Data C. Summarized Data D. Detailed Data E. All of the above is typically present in source systems.

d. detailed data

Which of the following is NOT true? Mapping an M:N relationship that has no attributes will result in: A. A composite primary key B. A foreign key in both of the relations mapped from the involved entities C. A new relation D. Two foreign keys

b. a foreign key in both of the relations mapped from the involved entities

The ________ slowly changing dimension approach creates a new additional dimension record using a new value for the surrogate key every time a value in a dimension record changes. A. Type 1 B. Type 2 C. Type 3 D. Type 0 E. No type

b. type 2

Front-end applications facilitate: A. Both direct and indirect use B. Direct use C. Neither direct nor indirect use D. Indirect use

d. indirect use