Quiz
Untitled
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (15)
1 A class of database technology used to store textual and other unstructured data is called:
- AmySQL
- BNoSQL
- CKnowSQL
- DPHP
2 An expanded version of a star schema in which all of the tables are fully normalized is called a(n):
- Asnowflake schema.
- Boperational schema.
- CDSS schema.
- Dcomplete schema.
3 Operational and informational systems are generally separated because of which of the following factors?
- AA data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications.
- BA properly designed data warehouse decreases value to data.
- CA separate data warehouse increases contention for resources.
- DOnly operational systems allow SQL statements.
4 Which of the following factors drive the need for data warehousing?
- ABusinesses need an integrated view of company information.
- BInformational data must be kept together with operational data.
- CData warehouses generally have better security.
- DReduce virus and Trojan horse threats.
5 When we consider data in the data warehouse to be time variant, we mean:
- Athat the time of storage varies.
- Bdata in the warehouse contain a time dimension so that they may be used to study trends and changes.
- Cthat there is a time delay between when data are posted and when we report on the data.
- Dthat time is relative.
6 Which of the following factors drive the need for data warehousing?
- ABusinesses need an integrated view of company information.
- BInformational data must be kept together with operational data.
- CData warehouses generally have better security.
- DReduce virus and Trojan horse threats.
7 The key discovery that triggered the development of data warehouses was:
- Acomputer viruses.
- Bnew ways to present information using mobile devices.
- Cthe recognition of the differences between transactional systems and informational systems.
- Dthe invention of the iPad.
8 A data mart is a(n):
- Aenterprise-wide data warehouse.
- Bsmaller system built upon file processing technology.
- Cdata warehouse that is limited in scope.
- Dgeneric on-line shopping site.
9 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:
- Aspan
- Bgrain
- Cselection.
- Daggregation.
10 Which of the following data-mining applications identifies customers for promotional activity?
- APopulation profiling
- BTarget marketing
- CUsage analysis
- DProduct affinity
11 ________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data.
- AMean data
- BSmall data
- CStar data
- DBig data
12 Data federation is a technique which:
- Acreates an integrated database from several separate databases.
- Bcreates a distributed database.
- Cprovides a virtual view of integrated data without actually creating one centralized database.
- Dprovides a real-time update of shared data.
13 The real-time data warehouse is characterized by which of the following?
- AIt accepts batch feeds of transaction data.
- BData are immediately transformed and loaded into the warehouse.
- CIt provides periodic access for the transaction processing systems to an enterprise data warehouse.
- DIt is based on Oracle technology.
14 Going from a summary view to progressively lower levels of detail is called data:
- Acubing
- Bdrill down.
- Cdicing.
- Dpivoting
15 A star schema contains both fact and ________ tables.
- Anarrative
- Bcross functional
- Cdimension
- Dstarter
Information
- Description
- Quiz on Untitled, created by Jose Martinez on 06/05/2022.
- Author
- Jose Martinez
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz