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

  1. First Step

  2. Second Step

  3. Third Step

  4. Fourth Step


Correct Option: B

AI Explanation

To answer this question, we need to understand the 4-step dimensional process and identify where declaring the grain of the business process occurs.

The 4-step dimensional process is a methodology used in data warehousing to design and build a data model. The steps involved are:

  1. Identify the business process: This step involves understanding the key business processes and identifying the one that will be the focus of the data model.

  2. Declare the grain: This step involves determining the level of detail at which the data will be captured and analyzed. The grain represents the lowest level of detail in the data model.

  3. Identify the dimensions: This step involves identifying the different aspects or dimensions that will be used to analyze the data. Dimensions are the different ways in which data can be sliced and diced.

  4. Identify the facts: This step involves identifying the numeric measures or facts that will be captured and analyzed in relation to the dimensions.

Based on the above information, we can conclude that declaring the grain of the business process occurs in the second step of the 4-step dimensional process.

Therefore, the correct answer is B) Second Step.

Find more quizzes: