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
Attempted 0/20 Correct 0 Score 0

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

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: A

The data in Data Warehouse is generally:

  1. Clean Data

  2. Dirty Data

  3. Clean and Dirty Data

  4. None of above


Correct Option: A

In datamarts stovepipe means:

  1. Similar Data

  2. Isolated data

  3. Unique data

  4. None of Above


Correct Option: B

Consolidated data mart is:

  1. Second level data mart

  2. First level data mart

  3. All of these

  4. None of above


Correct Option: A

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


Correct Option: D

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


Correct Option: B

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


Correct Option: D

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

In datamarts stovepipe means:

  1. Similar Data

  2. Isolated data

  3. None of Above

  4. Both 1& 2


Correct Option: B

Consolidated data mart is:

  1. First level data mart

  2. Second level data mart

  3. All of these

  4. None of Above


Correct Option: B

In general data in Data Warehousing is:

  1. Normalized

  2. Denormalized

  3. none

  4. All of the above


Correct Option: C

Drill Across generally use the following join to generate report:

  1. Self Join

  2. Inner Join

  3. Outter Join

  4. Both 1 & 2


Correct Option: C

Snowflaking means

  1. Normalizing the data

  2. Denormalizing the data

  3. Both 1 & 2

  4. None of the above


Correct Option: A

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


Correct Option: B

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


Correct Option: B

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


Correct Option: B

The data in Data Warehouse is generally

  1. Clean Data

  2. Dirty Data

  3. Clean and Dirty Data

  4. None of above


Correct Option: A

In Star Schema Dimension tables are:

  1. Short and Fat

  2. Long and Thin

  3. Long and Fat

  4. Short and thin


Correct Option: A

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


Correct Option: A
+ View questions