Practice Test GeeksCDP - Certified Data Professional Practice Test
← All CDP Flashcard Decks

Data Warehousing and Business Intelligence Flashcards

6 cards from real CDP practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Data Warehousing and Business Intelligence flashcards as text

  1. What is the primary advantage of columnar storage over row-based storage for analytical queries?

    Answer: Improved compression and faster reading of specific columns without scanning entire rows

    Columnar storage stores data by column rather than row, enabling better compression of similar values and faster reads for analytics that access only specific columns.

  2. In BI, what is 'self-service analytics'?

    Answer: Enabling business users to create their own reports and analyses without requiring IT intervention

    Self-service analytics empowers business users to independently access, analyze, and visualize data without needing to submit requests to IT or data teams.

  3. What is 'data freshness' in a data warehouse context?

    Answer: How current or up-to-date the data in the warehouse is relative to the source systems

    Data freshness measures how current the warehouse data is compared to source systems, reflecting the lag introduced by batch load frequencies.

  4. What is a 'junk dimension' in dimensional modeling?

    Answer: A single dimension table that consolidates miscellaneous, low-cardinality flag and indicator fields from the fact table

    A junk dimension consolidates miscellaneous boolean flags and low-cardinality indicators into a single dimension table to reduce fact table width.

  5. What does 'slice and dice' mean in OLAP analysis?

    Answer: Filtering data by selecting specific values on dimensions (slice) and viewing data across multiple dimensions simultaneously (dice)

    Slicing selects a subset of data by fixing one dimension's value, while dicing selects specific values across multiple dimensions to create a smaller subcube for analysis.

  6. What is the 'bus matrix' (also called the data warehouse bus matrix) used for?

    Answer: A planning tool that maps which business processes (fact tables) share which conformed dimensions

    The data warehouse bus matrix maps business process fact tables against conformed dimensions, enabling cross-process integration and guiding incremental data warehouse development.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. iccp.org — Test delivery, passing score, retake policy, score release, score validity, time limit, renewal, fees, eligibility · verified Oct 2026