SSAS 2008 Practice Test

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Stephanie Young
S
Stephanie Young
Community Contributor
Quizzes Created: 85 | Total Attempts: 71,076
| Attempts: 392
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/10 Questions

    The types of data mart include:

    • Dependent
    • Independent
    • Logical data mart
    • All of the above
Please wait...
About This Quiz

This Microsoft SQL Server Analysis Services, SSAS, quiz has been compiled to cover different aspects of SSAS, so it will be of great benefit to you if you take it. Click the start button to get started, Good Luck!

SSAS 2008 Practice Test - Quiz

Quiz Preview

  • 2. 
    Fact table is directly linked with all dimension tables in which type of database schema?  - ProProfs

    Fact table is directly linked with all dimension tables in which type of database schema? 

    • Star

    • Snowflake

    • Starflake

    • None of the above

    Correct Answer
    A. Star
    Explanation
    In a star schema, the fact table is directly linked with all dimension tables. This means that the fact table serves as the central table in the schema, with the dimension tables connected to it through foreign key relationships. The star schema is a simple and denormalized structure, making it easier to understand and query. It is commonly used in data warehousing and business intelligence applications where fast query performance is essential. The snowflake schema, on the other hand, involves normalizing the dimension tables, resulting in more complex relationships. The starflake schema is not a recognized type of database schema. Therefore, the correct answer is star.

    Rate this question:

  • 3. 
    The dimension table is joined to an intermediate table, which in turn, is joined to the fact table in which type of relation?  - ProProfs

    The dimension table is joined to an intermediate table, which in turn, is joined to the fact table in which type of relation? 

    • Fact

    • Data mining

    • Regular

    • Referenced

    Correct Answer
    A. Referenced
    Explanation
    In a referenced relation, the dimension table is joined to an intermediate table, which is then joined to the fact table. This means that the intermediate table serves as a bridge between the dimension and fact tables, allowing for a more complex relationship between the two.

    Rate this question:

  • 4. 
    The following are the standard storage modes in OLAP applications except: - ProProfs

    The following are the standard storage modes in OLAP applications except:

    • MOLAP

    • ROLAP

    • HOLAP

    • JOLAP

    Correct Answer
    A. JOLAP
    Explanation
    JOLAP is not a standard storage mode in OLAP applications. MOLAP stands for Multidimensional OLAP, which stores data in a multidimensional cube format. ROLAP stands for Relational OLAP, which uses a relational database to store data. HOLAP stands for Hybrid OLAP, which combines the features of both MOLAP and ROLAP. JOLAP, on the other hand, does not exist as a standard storage mode in OLAP applications.

    Rate this question:

  • 5. 
    SQL expression represented as a calculated column is a/an - ProProfs

    SQL expression represented as a calculated column is a/an

    • Named calculation

    • Expressed calculation

    • Column calculation

    • Row calculation

    Correct Answer
    A. Named calculation
    Explanation
    A named calculation in SQL is an expression that is defined and named within a query or a view. It allows users to create a calculated column by specifying the expression and assigning it a name. This named calculation can then be referenced in other parts of the query or view, making it easier to reuse the calculated value. Therefore, a named calculation is the correct answer for a SQL expression represented as a calculated column.

    Rate this question:

  • 6. 
    The fact table consist of how many sections?  - ProProfs

    The fact table consist of how many sections? 

    • 1

    • 2

    • 3

    • 4

    Correct Answer
    A. 2
    Explanation
    The fact table consists of two sections.

    Rate this question:

  • 7. 
    They are how many types of data mart? - ProProfs

    They are how many types of data mart?

    • 1

    • 2

    • 3

    • 4

    Correct Answer
    A. 3
    Explanation
    There are three types of data marts. A data mart is a subset of a data warehouse that is focused on a specific functional area or department within an organization. The three types of data marts are: dependent data mart, independent data mart, and hybrid data mart. A dependent data mart relies on a data warehouse for its data, an independent data mart does not rely on a data warehouse and has its own data sources, and a hybrid data mart combines elements of both dependent and independent data marts.

    Rate this question:

  • 8. 
    The dimension which is sharable across the multiple facts or data model is known as - ProProfs

    The dimension which is sharable across the multiple facts or data model is known as

    • Degenerate attribute

    • Junk dimension

    • Confirm dimension

    • None of the above

    Correct Answer
    A. Confirm dimension
    Explanation
    A confirm dimension is a dimension that is shared across multiple facts or data models. It serves as a common reference point for different sets of data. Unlike degenerate attributes, which are specific to a single fact, or junk dimensions, which are used to group low cardinality attributes, a confirm dimension provides a consistent and standardized way to analyze and compare data across different data sets. Therefore, the correct answer is confirm dimension.

    Rate this question:

  • 9. 
    There are how many types of hierarchies?  - ProProfs

    There are how many types of hierarchies? 

    • 4

    • 3

    • 2

    • 1

    Correct Answer
    A. 2
    Explanation
    The given answer is 2 because hierarchies can be categorized into two main types: vertical and horizontal. Vertical hierarchies represent the traditional top-down structure where authority and decision-making flow from higher-level positions to lower-level positions. Horizontal hierarchies, on the other hand, represent a more collaborative and flat organizational structure where decision-making is decentralized and employees have more autonomy.

    Rate this question:

  • 10. 
    There are how many types of dimensions? - ProProfs

    There are how many types of dimensions?

    • 1

    • 2

    • 3

    • 4

    Correct Answer
    A. 3
    Explanation
    There are three types of dimensions.

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 16, 2018
    Quiz Created by
    Stephanie Young
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.