0
Alien head

platforms and products Online Quiz - 87

Description: platforms and products Online Quiz - 87
Number of Questions: 20
Created by:
Tags: platforms and products

When gathering business information requirements, you should focus only on the requirements provided by the business groups.

  1. True

  2. False

Answer: 2

The ROI or value proposition for developing and delivering a data warehouse has no influence on the project direction.

  1. True

  2. False

Answer: 1

The data in Data Warehouse is generally:

  1. Clean Data

  2. Dirty Data

  3. Clean and Dirty Data

  4. None of above

Answer: 1

In datamarts stovepipe means:

  1. Similar Data

  2. Isolated data

  3. Unique data

  4. None of Above

Answer: 2

Consolidated data mart is:

  1. Second level data mart

  2. First level data mart

  3. All of these

  4. None of above

Answer: 1

Degenerate Dimensions(DD)

  1. Transaction Number, bill of lading number, invoice number may be DD.

  2. DD has no attributes

  3. DD does not join to actual dimension table

  4. All of the above are correct

Answer: 4

Dimensions are Confirmed when:

  1. They are different

  2. They are either same or one is subset of another

  3. When they can be compared mathematically

  4. None of these

Answer: 2

Centipede fact table means:

  1. Fact table with no dimensions

  2. Factless fact table

  3. Fact table with two or three dimensions

  4. Fact table with to many dimensions

Answer: 4

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

  1. First Step

  2. Second Step

  3. Third Step

  4. Fourth Step

Answer: 2

In datamarts stovepipe means:

  1. Similar Data

  2. Isolated data

  3. None of Above

  4. Both 1& 2

Answer: 2

Consolidated data mart is:

  1. First level data mart

  2. Second level data mart

  3. All of these

  4. None of Above

Answer: 2

In general data in Data Warehousing is:

  1. Normalized

  2. Denormalized

  3. none

  4. All of the above

Answer: 3

Drill Across generally use the following join to generate report:

  1. Self Join

  2. Inner Join

  3. Outter Join

  4. Both 1 & 2

Answer: 3

Snowflaking means

  1. Normalizing the data

  2. Denormalizing the data

  3. Both 1 & 2

  4. None of the above

Answer: 1

Sequence of jobs to load data in to warehouse

  1. First load data into fact tables then dimension tables, then Aggregates if any

  2. First load data into dimension tables, then fact tables, then Aggregates if any

  3. First Aggregates then load data into dimension tables, then fact tables

  4. Does not matter if we load either of fact, dimensions, or aggregates

Answer: 2

During ETL load we generally have

  1. Unsorted data for Aggregator

  2. Sorted data for Aggregator

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

  4. None of the above

Answer: 2

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

  1. Type One

  2. Type Two

  3. Type Three

  4. None of above

Answer: 2

The data in Data Warehouse is generally

  1. Clean Data

  2. Dirty Data

  3. Clean and Dirty Data

  4. None of above

Answer: 1

In Star Schema Dimension tables are:

  1. Short and Fat

  2. Long and Thin

  3. Long and Fat

  4. Short and thin

Answer: 1

You can open reports, templates, or analyses that were created in Query Studio or Analysis Studio in:

  1. Report Studio

  2. Query Studio

  3. Analysis Studio

  4. Metric Studio

Answer: 1
+ View questions