Database Management Systems

A star schema is a dimensional model containing a single fact table at the center surrounded by one or more dimension tables. Models with multiple fact tables are typically called galaxy or fact constellation schemas. Therefore, the option describing a single fact and one or multiple dimensions is correct.

Dimension tables must be loaded first because fact tables contain foreign keys that reference dimension tables. Loading dimensions before facts ensures referential integrity - you can't reference a dimension record that doesn't exist yet.

Informatica, DataStage, and Ab Initio are all ETL (Extract, Transform, Load) tools used for data integration. BusinessObjects and Cognos are BI tools, Hyperion is planning software, Oracle Builder isn't a standard ETL tool, and MicroStrategy is a BI platform.

SCD stands for Slowly Changing Dimension in data warehousing. This refers to dimensions that change gradually over time rather than changing rapidly. The correct terminology uses 'changing' not 'change' and 'dimension' not 'direction' or 'chance'.

SCD stands for Slowly Changing Dimension in data warehousing. This refers to dimensions that change gradually over time rather than changing rapidly. The correct terminology uses 'changing' not 'change' and 'dimension' not 'direction' or 'chance'.

SCD stands for Slowly Changing Dimension in data warehousing. This refers to dimensions that change gradually over time rather than changing rapidly. The correct terminology uses 'changing' not 'change' and 'dimension' not 'direction' or 'chance'.

Business Objects provides additional join types beyond standard SQL joins. The shortcut join is a BO-specific optimization that bypasses intermediate tables. Equi joins and theta joins (based on non-equality conditions) are standard, but the inclusion of shortcut join makes option B correct as it uniquely identifies BO's contribution.

Business Objects is classified as ROLAP (Relational OLAP) because it works directly with relational databases rather than pre-aggregated multidimensional cubes. MOLAP uses specialized multidimensional structures, while HOLAP combines both approaches. BO's universe-based queries against RDBMS place it in the ROLAP category.

In Business Objects, a repository is a centralized storage location that contains all the BO environment's assets including universes, reports, users, and security settings. It is not merely a data type or data structure, but the complete persistent storage system. Options A and B are incomplete definitions.

Degrafa is a declarative graphical framework for Flex and AIR applications that allows developers to create graphics using MXML or ActionScript. It provides a way to define vector graphics, shapes, and complex visual elements programmatically. Data visualization is just one application of Degrafa, not its fundamental definition.

A WorkPool in PEGA is a collection of similar Work Objects that share common characteristics and are processed together. WorkGroups are organizational groupings, not collections of work objects. The WorkPool helps in managing and routing similar types of work items efficiently.

A WorkPool in Pega is a collection of similar Work Objects grouped together for organizational and routing purposes. It allows related work items to be managed collectively. WorkGroups are collections of users, not work objects. ClassGroup refers to Pega class groups, which is a different concept entirely.

A class group causes PRPC to store instances from multiple concrete classes sharing a common key format in a single database table. This is a database optimization technique that reduces table proliferation while maintaining logical separation at the application level.

Database Management System (DMS) implementations like DMS 1100 and DMS II are based on the network database model. They do not conform to relational or hierarchical models.

A Data Item is the basic unit of a record, representing the smallest individual field or attribute within a database structure. Data items are the atomic building blocks that define what specific pieces of information can be stored - like a name field, date field, or numeric value. This contrasts with Record Type (the structure definition) or Record Occurrence (the actual instance with values).