Practice Test GeeksIKM - International Knowledge Measurement Practice Test
← All IKM Flashcard Decks

Data Analysis and Business Intelligence Flashcards

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

Read the first 7 Data Analysis and Business Intelligence flashcards as text

  1. Which SQL aggregate function would you use to count the number of non-NULL values in a column?

    Answer: COUNT()

    COUNT(column_name) returns the number of rows where the specified column is not NULL, making it the correct function for counting non-null values.

  2. What is a 'pivot table' used for in data analysis tools like Excel or Power BI?

    Answer: Summarizing and reorganizing data to identify patterns and trends

    A pivot table dynamically summarizes, groups, and aggregates large datasets, allowing analysts to reorganize rows and columns to reveal patterns and trends quickly.

  3. Which chart type is most appropriate for showing the distribution of a single continuous variable?

    Answer: Histogram

    A histogram groups continuous data into intervals (bins) and displays the frequency of values in each bin, making it ideal for visualizing the distribution of a single variable.

  4. In data analysis, what does the term 'data granularity' refer to?

    Answer: The level of detail or precision at which data is stored or reported

    Data granularity refers to the level of detail in data records — fine granularity means each row represents a single transaction, while coarse granularity means rows represent daily or monthly summaries.

  5. A correlation coefficient of -0.92 between two variables indicates which of the following?

    Answer: A strong negative linear relationship

    A correlation coefficient close to -1 (such as -0.92) indicates a strong negative linear relationship, meaning as one variable increases, the other tends to decrease significantly.

  6. What is the primary purpose of data profiling in a data quality initiative?

    Answer: Examining data to understand its structure, content, and quality issues

    Data profiling involves analyzing a dataset to discover its structure, completeness, uniqueness, and anomalies, which is the essential first step in any data quality improvement effort.

  7. Which BI concept refers to pre-computing and storing aggregated query results to speed up report performance?

    Answer: Aggregate caching / materialized views

    Materialized views (or aggregate caches) store the results of expensive queries so that subsequent requests can retrieve pre-computed results instead of recalculating them each time.