Tag: enterprise content management

Questions Related to enterprise content management

  1. OLAP and DMR

  2. Dimensional and DMR

  3. Relational and SAP BW

  4. Relational and Dimensional


Correct Option: D
  1. De-normalized hierarchy of dimension tables and fact tables.

  2. Normalized dimension tables and detailed fact tables.

  3. Normalized dimension tables and summarized fact tables.

  4. De-normalized dimension tables and fact tables.


Correct Option: D

The illustration below represents which of the following data traps?

  1. Bridge

  2. Connection

  3. Parallel relationship

  4. Many-to-many relationship


Correct Option: C
  1. Bridge

  2. Connection

  3. Parallel relationship

  4. Many-to-many relationship


Correct Option: C
  1. model

  2. query item

  3. namespace

  4. query subject


Correct Option: C
Explanation:

To solve this question, the user needs to have knowledge of the Framework Manager environment in IBM Cognos Analytics. In this environment, different objects are used to organize and manage data and metadata.

The object that acts as a container and provides a unique name for objects in the Framework Manager environment is the Namespace.

A Namespace is a container that groups related objects, such as Query Subjects, Query Items, Filters, and Calculations. It provides a unique name for each object within its scope, ensuring that there are no naming conflicts between objects.

Option A, Model, is incorrect because it is a higher-level object that contains multiple namespaces and is used to organize and manage data sources and metadata in Framework Manager.

Option B, Query Item, is incorrect because it is a specific data item that is used in a query or report. It does not act as a container or provide a unique name for objects.

Option D, Query Subject, is incorrect because it is an object that defines a set of related data items that can be used in a query or report. It does not act as a container or provide a unique name for objects.

Therefore, the correct answer is:

The Answer is: C. Namespace

Which of the following is true regarding the operational data structure illustrated below?

  1. It illustrates a parallel relationship.

  2. It should be consolidated into one table.

  3. . It should be examined for a connection trap.

  4. The cardinality between the tables should be reversed.


Correct Option: C
  1. Comprised of normalized dimension and fact tables.

  2. Organizes dimension tables into hierarchies and levels.

  3. Allows "real time" analysis against disparate data sources.

  4. Cardinality between tables is typically configured as inner joins.


Correct Option: B
Explanation:

To answer this question, the user needs to understand what OLAP means and the characteristics of an OLAP data structure.

OLAP stands for Online Analytical Processing. It is a technology used to store and analyze large amounts of data in a multidimensional format. OLAP data structures are designed to support complex queries and analysis of data.

Now, let's go through each option and explain why it is right or wrong:

A. Comprised of normalized dimension and fact tables.

This option is incorrect. While OLAP data structures do use dimension and fact tables, they are not necessarily normalized. In fact, OLAP data structures use denormalized tables to improve performance.

B. Organizes dimension tables into hierarchies and levels.

This option is correct. OLAP data structures are designed to organize dimension tables into hierarchies and levels to enable quick and easy analysis of data.

C. Allows "real time" analysis against disparate data sources.

This option is incorrect. While OLAP data structures are designed to support complex queries and analysis of data, they are not typically used for real-time analysis. OLAP systems are often updated on a regular basis, rather than in real-time, to improve performance.

D. Cardinality between tables is typically configured as inner joins.

This option is incorrect. While inner joins are often used in OLAP data structures, other types of joins can also be used depending on the specific requirements of the system.

Therefore, the correct answer is:

The Answer is: B. Organizes dimension tables into hierarchies and levels.

In a transitive relationship scenario, what problems exist when reporting from the tables below?

  1. The Order table must be included in each query.

  2. The Order Detail table has conflicting cardinalities.

  3. Outer joins are generated when querying from Customer.

  4. There is more than one possible path between the tables.


Correct Option: D