BIAM 410 Week 1 Database for Business Intelligence Quiz new text questions with answers solved solution
Question 12 pts
(TCO 1) _____ tools work together in retrieving, processing, and modeling data from a data wareh
...
BIAM 410 Week 1 Database for Business Intelligence Quiz new text questions with answers solved solution
Question 12 pts
(TCO 1) _____ tools work together in retrieving, processing, and modeling data from a data warehouse.
OMG
XML
OLTP
OLAP
Question 22 pts
(TCO 1) _____ refers to a comprehensive approach to capture and process business data to support decision making.
Database design
Online transaction processing
Business intelligence
Extensible Markup Language
Question 32 pts
(TCO 1) Data that have been partially processed, such as a web page loosely formatted to convey some information, are
structured data.
unstructured data.
semistructured data.
metadata.
Question 42 pts
(TCO 1) A problem associated with storing data in a flat-file system rather than in a database is
simple system administration.
difficulty of getting quick answers.
short development times.
robust data sharing.
Question 52 pts
(TCO 1) An early data model that could support only simple parent-child relationships in multilevel tree structures was the
object-oriented model.
relational model.
network model.
hierarchical model.
Question 62 pts
(TCO 2) The _____ phase of the SDLC includes coding, testing, debugging, and installation of the system.
planning
analysis
design
implementation
Question 72 pts
(TCO 2) Actions during the database design phase of the DBLC include
select the DBMS.
define problems and constraints.
install the DBMS.
fine-tune the database.
Question 82 pts
(TCO 2) Actions during the testing and evaluation phase of the DBLC include
define objectives.
DBMS software selection.
fine-tune the database.
load or convert the data.
Question 92 pts
(TCO 2) The last stage in the database design process is
physical design.
logical design.
conceptual design.
detailed design.
Question 102 pts
(TCO 2) _____ design starts by identifying data sets and then determines the data elements for each set.
Bottom-up
Top-down
Centralized
Decentralized
[Show More]