> > SAP MCQs > Business Warehousing MCQs

Business Warehousing MCQ

Warehousing and ____ are substitutes for each other.

Transportation

Materials handling

Packaging

Inventory management

None of the above

Answer

Correct Answer: Transportation

Note: This Question is unanswered, help us to find answer for this one

During ETL load we generally have

Unsorted data for Aggregator

Does not matter if we use Sorted or Unsorted data for Aggregation

None of these

Sorted data for Aggregator

Answer

Correct Answer: Sorted data for Aggregator

Note: This Question is unanswered, help us to find answer for this one

You need to create an index on the SALES table, which is 10 GB in size. You want your index to be spread across many tablespaces, decreasing contention for index lookup, and increasing scalability and manageability.

Bitmap

Reverse Key

Partitioned

UNIQUE

Answer

Correct Answer: Partitioned

Note: This Question is unanswered, help us to find answer for this one

Which type of table is usually created to enable the building of scalable applications, and is useful for large tables that can be queried or manipulated using several processes concurrently?

Partitioned table

Clustered table

Ndex-organized table

Regular table

Answer

Correct Answer: Partitioned table

Note: This Question is unanswered, help us to find answer for this one

In Star Schema Dimension tables are:

Long and Fat

Short and Fat

Short and thin

Long and Thin

Answer

Correct Answer: Short and Fat

Note: This Question is unanswered, help us to find answer for this one

Centipede fact table means:

Fact table with no dimensions

Factless fact table

Fact table with to many dimensions

Fact table with two or three dimensions

Answer

Correct Answer: Fact table with to many dimensions

Note: This Question is unanswered, help us to find answer for this one

Dimensions are Confirmed when:

They are different

When they can be compared mathematically

They are either same or one is subset of another

None of these

Answer

Correct Answer: They are either same or one is subset of another

Note: This Question is unanswered, help us to find answer for this one

In 4 step dimensional process, declaring grain of business process is:

Second Step

Fourth Step

First Step

Third Step

Answer

Correct Answer: Second Step

Note: This Question is unanswered, help us to find answer for this one

In datamarts stovepipe means:

Similar Data

None of these

Isolated data

Normalized Data

Answer

Correct Answer: Isolated data

Note: This Question is unanswered, help us to find answer for this one

In which type of SCD(Slowly changing dimensions) do we preserve history of data:

Type Three

None of these

Type Two

Type One

Answer

Correct Answer: Type Two

Note: This Question is unanswered, help us to find answer for this one

In general data in Data Warehousing is:

Normalized

None of Above

Denormalized

Cusomized

Answer

Correct Answer: None of Above

Note: This Question is unanswered, help us to find answer for this one